Course Description

This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2003 effectively.

Pre-Requisites

This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions.

Outcomes

At the completion of this course, participants will be able to:

• Protect data
• Use Lookup functions
• Nest functions to create complex formulas
• Use advanced filters
• Use data validation techniques
• Use goal seeking
• Create, use and modify data tables
• Use the Scenario Manager
• Create, modify and work with PivotTables
• Group cells and use Outlines
• Use linking
• Share workbooks with other users
• Combine data using Consolidation
• Publish workbooks for the web
• Create macros