|
Overview
& Prerequisite
This course
is aimed at those who have a very good understanding of Excel
2003 at a Foundation level.
Knowledge
of the following topics will be assumed:
Basic
Formula, Relative Reference, Absolute Reference, Page Setup
& Presentation.
Course
content
|
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
Autotemplate
2003
Changes
Smart tags
Task Pains
Document Recovery
|
