Microsoft Excel 2007 Level 2

Microsoft Excel 2007 Level 2

Course ID: S172
Duration: 1 day

Prerequisites

Microsoft Excel 2007 Level 1

Course Objectives

After completing the course, participants will be able to:

Organize, protect, and display data, using various tools
Create linking formulas and use the IF function
Set up multiple worksheets, using information from other sources through consolidation, and copy and paste links to combine information into one worksheet
Set up multiple worksheets, using information from other sources through consolidation, and copy and paste links to combine information into one worksheet
Create and apply styles to format worksheets consistently and quickly; use conditional formatting, comments, and text boxes to highlight and explain data

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

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver