Microsoft Excel

Training available in version Office 2003 and 2007

Excel enables you to turn data into information with powerful tools to analyse, communicate, and share results.

Suggested topics

Introductory

Understand the MicrosoftTM Excel workspace
Create, save and print an MicrosoftTM Excel spreadsheet
Edit a spreadsheet
Make formatting changes to a spreadsheet
Create a basic chart and format the chart
Understand the different printing options
Microsoft Help feature
Use short cuts to enter and manipulate data
Manage workbooks and windows
Work with formulas and functions
Manage files effectively
Work with macros

Intermediate

Learn about Excel shortcuts
Manage workbooks and windows
Format in Microsoft Excel
Work with formulas and functions
Create and format charts
Introduce macros for automating tasks
Print spreadsheets
Manage files effectively
Introduce range names for managing lists and formulas
Work with scenarios
Understand the report features
Customise toolbars
Use the drawing tools to enhance spreadsheets
Insert graphics
Use some special features
Design better spreadsheets
Understand design policy

Advanced

Protect sheets, workbooks and objects
Identify and correct errors in worksheets/spreadsheets
Work with range names
Create and edit macros
Link formulas
Use math, statistical, logical and other functions
Create worksheet outlines
Create advanced charts
Create and use templates
Customise number formatting
Import and export data
Sort and filter lists
Use subtotals
Create pivot tables
Use data consolidation
Create worksheet/spreadsheet forms