Excel 2007 Intermediate
The Excel 2007 Intermediate tutorial takes you step by step through intermediate spreadsheet tasks as specified in the Microsoft Certified Application Specialist (MCAS) exam (77-602).
Working with Existing Spreadsheets Modifying Worksheets
Formatting Worksheets
Custom and Conditional Formats
Cell and Table Styles
Workspaces and Views Saving a Workspace
Excel Views
Using Custom Views
Presenting Data Visually Illustrations
Sorting and Filtering Data
Spreadsheet Tools Auditing Tools
Scenario Manager
Using Macros
Importing, Exporting and Pivot Tables Importing, Exporting and Queries
Working with PivotTables