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
