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
Outlining    

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
Pre-Requisites

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 ]

Reviews
 
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
need-to-train-a-group-banner

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 1435 times.