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
- Time: 9:00 am - 4:00 pm (Note on end times)
- Duration: 1 Day
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.
- Delivery Method(s):Instructor Led
- Discount Seats Available:2
- Category:Microsoft Excel Training
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.
- 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.
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.
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
Excel 2007 Level 2 or equivalent knowledge
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
[ View Provider's Profile ]
CompuEase Training Classroom
130 Albert Street
Canada K1P 5G4
Registration for this course has been closed.
This course may be available on a different date listed below.
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 45 times.