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. 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. 

Next Microsoft Excel 2003 Advanced Open Training Course
03/02/2012

Manchester City Centre Venue
Limited Places-Book Now -
Call 0161 408 0435
Or
Book Online

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