Duration

1 day

Aim

The skills and knowledge acquired in Microsoft Excel 2003 Level Three are sufficient to be able to use and operate the software at an advanced level. This workshop will give you the tools and confidence to manipulate data in a more time efficient and professional manner with an understanding of why and how this is working.

Target Audience

Microsoft Excel 2003 Level Three is designed for users who are keen to extend their understanding and knowledge of the software.

Prerequisites

Microsoft Excel 2003 Level Three assumes a good knowledge of the software.

Course Content

Nesting Functions Workshop Advanced Filters Validations Goal Seeking Data Tables Scenarios PivotTables Linking Workbooks Consolidation Summarising Data Recorded Macros Advanced Filters Validations Goal Seeking Data Tables Scenarios PivotTables Consolidation Summarising Data Recorded Macros

Course Objectives

At the completion of Microsoft Excel 2003 Level 3 you should be able to:

• 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 • combine data in separate worksheets or workbooks using consolidation • summarise data using subtotals and relative range naming • create recorded macros in Excel

Course Outline