Overview & Prerequisite

This Microsoft Excel 2007 Training course is aimed at those who have a very good understanding of Excel 2007 at a Foundation level.

Knowledge of the following topics will be assumed:

Basic Formula, Relative Reference, Absolute Reference, Page Setup & Presentation.

Course content

Getting Started with 2007
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
The New File Menu

Multiple Sheets
Moving Around
Selection Techniques
Inserting
Deleting
Copying
Fill by Example
Group Mode
Consolidation

Template
Create
Modify
Save
Auto templates
Using templates
Inserting templates

Protection
Cell Protection
Sheet Protection
Workbook Protection
File Protection

File Linking
External Reference
Dependant Workbook
Source Workbook
Update Links

Printing
View Manager
Print Manager

Lists
Forms
Custom Filtering
Advanced Filtering
Subtotals

Charts
Creating Charts
Autotemplate