Pagoda Training Ltd
Helping clients deliver effective IT training projects
 
Microsoft Excel 2003 Advanced - Course outline
   
Duration One Day
Objectives To provide greater data management skills, and to build more advanced function-based formulae. Delegates will also learn how to analyse data with Goal Seek and Scenario features.
Who should attend Those who are already using Excel to an intermediate level, but who wish to analyse their data further with some of Excel's more advanced features.
Experience needed Delegates should have attended an intermediate Excel course, or gained the relevant experience through working with Excel.
   
Content Advanced Sorting techniques
Advanced Filtering techniques
Creating Outlines
Subtotals
Pivot Tables & Charts

Statistical Functions
Combining Extraction with Statistics

The Lookup Function
Vlookup
The One Input Table
The Two Input Table

Custom Number Formats
Array Formulae

Overview of Using Scenario Manager
Scenario Command
Setting a Scenario
Using Goal Seek

Importing Data
Data Validation

   
   
 

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465
  Back to top