Microsoft Excel 2003 – Advanced (Course Code: 709)

Overview:

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. It includes areas such as:

• workbook and worksheet consolidation and linking
• data analysis tools
• automating workbook operations using macros.

Learning Method:

This course uses a combination of instructor presentation, and student hands-on practical exercises. You will have the opportunity to apply what they have learned in the classroom throughout the course.

Who will benefit from this course?

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.

Pre-requisites:

Completion of Course 708: Microsoft Excel 2003 – Intermediate or equivalent skills are needed to gain maximum benefit from this training course. It is assumed that you will know how to create and save a workbook, create formulas and use functions, and perform simple formatting of the data.

What can you expect to gain from this course?

After completing this course you will be able to:

• nest functions to create complex formulas
• use advanced filters to analyse data in a list
• use a variety of data validation techniques
• use goal seeking to determine the values required to reach a desired result
• create, use and modify data tables
• create and work with scenarios and the Scenario Manager
• create, modify and work with PivotTables
• use linking to create more efficient workbooks
• combine data in separate worksheets or workbooks using consolidation
• publish workbooks and worksheets for the web
• summarise data using subtotals and relative range naming
• confidently open workbooks that contain macros
• create recorded macros in Excel
• use the macro recorder to create a variety of macros.

Course contents