Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


In this course, you'll extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others..

  • Course Start Date: Nov. 27
  • Location: Ottawa (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 1 Day
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
Course Outline

Course Length: 6hrs (1 Day)
 

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Learning Objectives:
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline:
Section 1: Advanced Topics
Lesson 1.1: Setting Excel Options
Lesson 1.2: Excel and Windows
Lesson 1.3: Using the Excel Viewer

Section 2: Getting the Most From Your Data
Lesson 2.1: Getting the Most From Your Data
Lesson 2.2: Pivot Tables
Lesson 2.3: More About Pivot Tables
Lesson 2.4: Exploring Scenarios
Lesson 2.5: What If Analysis

Section 3: Excel and the Internet
Lesson 3.1: Excel and Hyperlinks
Lesson 3.2: Saving Workbooks as Web Pages
Lesson 3.3: Getting Data from the Internet
Lesson 3.4: Excel and Office Servers

Section 4: Advanced Excel Tasks
Lesson 4.1: Creating and Using Shared Workbooks
Lesson 4.2: Using Custom AutoFill Lists
Lesson 4.3: Using the VLOOKUP Function
Lesson 4.4: Linking, Consolidating, and Combining Workbooks

Section 5: Macros, VBA, and Excel Programming
Lesson 5.1: Macros
Lesson 5.2: More Macro Tasks
Lesson 5.3: Visual Basic and Macros


Prerequisites & Certificates
Pre-Requisites

Excel 2007 Level 2 or equivalent knowledge

Certificates offered

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support


Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.


Map & Reviews
CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
130 Albert Street
Suite 801

Ottawa, ON
Canada   K1P 5G4


Reviews
 
This was the first time ever that I can remember having a two instructors teach a course. The tag team approach to teaching kept me on the edge of my seat. The thought of having a new voice and personality teaching the course material was like a breathe of fresh air. We was so wrapped up the level of passion the instructors brought to the classroom regarding Excel that we only stopped for a 30 minute lunch and then spent an additional hour at the end of the day where the instrctors shared experiences which had even challenged them.
Reviewed by 2011

 

Registration for this course has been closed.

This course may be available on a different date listed below.
 

need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 44 times.