Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4

This course introduces a user to Excel's intermediate features to edit, analyze and organize data.

Course Outline
Course Description

This course introduces a user to Excel's intermediate features to edit, analyze and organize data. Building on skills learned in Level 1, more advanced uses of  formulas and formats are explored along with creating and defining range names.  In addition, how  to protect worksheets and files is discussed. Participants will also learn how to plot chart data and develop skills to manage multiple worksheets.

Course Content

Worksheet Organization

Range Names
Workbook Templates
Worksheet Security

Advanced Formulas

Using the IF Function
Linking Formulas

Using Multiple Workbooks and Worksheets

Working with Multiple Workbooks
Setting Up Multiple Worksheets
Using Multiple Worksheets
Creating Links with Formulas
Modifying and Restoring Links
Consolidating Data

Working with Charts

Creating Charts
Changing Chart Data
Modifying Chart Elements
Creating Custom Charts
Applying Formatting

Creating Styles
Working with Styles
Using Conditional Formatting
Annotating Worksheets
Using Sparklines


Prerequisites & Certificates

Excel 2010 - Level 1 or equivalent experience

Certificates offered

Certificate of Completion

Cancellation Policy
10 business days cancellation or full course fee will be charged
Map & Reviews
Technology Training Centre
[ View Provider's Profile ]

this was a vary knowlageable course and i look forward to using all my new found tips
Reviewed by 2013
She was very knowledgeable. I enjoyed the course!
Reviewed by 2012
Course instuctor did not hand out the manuals until end of the day. Therefore not able to write notes in for reference later on. - kinda silly.
Reviewed by 2011
You shoudl have a Excel 3 class available
Reviewed by 2011
Course materials were not handed out till the end of the course and may have been useful to follow along. Some of the example/course files were missing from my folder.
Reviewed by 2011

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1416 times.