Excel 2003 - Advanced

General Description:

This course covers aspects of Microsoft Excel 2003 beyond building basic workbooks and deals with workbook automation and productivity features.

Learning Outcomes

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

· Outline and group your data

· Create subtotals

· Create Pivot Tables from your data

· Modify and customize Pivot Tables

· Use scenarios to model data

· Use goal seeker

· Introducting to Macros

Target Audience:

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills in the more advanced areas of Excel such as goal seeking, linking, macros, web publishing and PivotTables.

Prerequisites:

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 use a variety of functions and formulas, have a basic understanding of absolute and relative referencing, be able to use names and labels and sort lists.

Duration:

3 hours