Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


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: Sep. 30
  • 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

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: PivotTables
Lesson 2.3: More About PivotTables
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 2: Macros, VBA, and Excel Programming
Lesson 2.1: Macros
Lesson 2.2 More Macro Tasks
Lesson 2.3: Visual Basic and Macros


Prerequisites & Certificates
Pre-Requisites

Excel 2007 Level 2 or equivalent knowledge

Certificates offered

Certificate of completion


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
30-September-2016 $236 Regular Price $295 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
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 31 times.