Learning Outcomes
By the end of this course students will be able to:

Incorporate simple built-in functions into a worksheet
Organise and maintain data in a list
Edit data and worksheets using productivity features
Develop template to standardise worksheet layout

Method
This course is provided as hands on and includes and extensive workshop manual and data disk for use during the course.

Working with Large Worksheets

Viewing a large worksheet effectively
Printing a large worksheet effectively
Working with sheets within notebooks
Excel's functions
Auditing your workbook

Productivity Tools

Creating your own templates
Summarising data across multiple sheets
Using functions with 3-D references
Consolidation
Applying Excel's productivity tools
Format painter and paste special
AutoCorrect and AutoComplete
Cell comments
Find and replace
Workbook and template security

Working With Lists

Using lists to manage and sort data
Filtering lists
Subtotalling a list
Creating advanced filters

Appendix

Additional opening/saving features
Worksheet properties
Creating custom lists for AutoFill
Customising the toolbars
Learning as you work using Help and the Office Assistant