After completing this Microsoft Excel 2003 training course, you will know how to assign Names to cells and  cell range, use financial functions in formulas You will be able to view the effects of multiple input values on a formula by using data tables. 

Microsoft Excel 2003 Advanced Training Course

You will learn to use the Subtotal command, the Subtotal function and database functions to summarise .ata in a list or database. Use data forms and validation to ensure correct data entry in lists and databases. Use PivotTables to analyse large quantities of data. and perform what-if analysis. You will also learn how to record and run Macros to automate repetitive tasks. 

Target audience

Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel
 

Course prerequisites 

This course is designed for students who have completed the Excel 2003 Intermediate course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
 

Course content

Advanced Formulas

  •    Using Names 
  •   Decision-Making

Financial Formulae 

  •   Financial Functions 
  •   Data Tables

Advanced List Management 

  •   Database Functions 
  •   Data Forms and Validation 
  •   Subtotal Function 
  •   Group and Outline Listed Data

Analytical Options 

  •   Goal Seek And Solver 
  •   Scenarios 
  •   Views 
  •   Reports

Exporting And Importing 

  •   Exporting & Importing Data 
  •   Querying Access Databases 

Pivot Tables 

  •   Creating A Pivot Table 
  •   Rearranging Pivot Tables 
  •   Formatting Pivot Tables 
  •   Pivot Charts 
  •   Group and Outline Pivots 
  •   Apply Table Options 
  •   Extract a Grouped Value

Macros 

  •   Recording And Running A Macro 
  •   Editing VBA Code 
  •   Function Procedures