Excel 2002 Advanced & VBA

Now offering London's widest choice in
dates, venues, and prices.

Training formats available

On a public schedule at one of our
London training venues.
On-site at your company office UK wide
Near-site, at a location close to you
Bespoke one-to-one basis
Tailored training courses to your requirements
See all formats...

Promotions

Excel training london

Training is available in one of our 6 London centres, on-site or tailored training courses

How to Book :: Training Schedule :: Contact Us

Other Excel training courses

Visual Basic for Excel Applications (VBA) for more information click here

Microsoft Excel 2002 Advanced

Duration: 1 Day
Level: Advanced
Prerequisites: An intermediate knowledge of Excel or our Excel 2002 Intermediate course.
Platform: PC
See also: Excel VBA

Syllabus includes:

Working with Advanced Formulas
Using names
Using decision-making functions
Creating nested functions
Using financial functions

Lookups and Data Tables
Working with lookup functions
Creating data tables

Advanced List Management
Creating subtotals
Validating cell entries
Exploring database functions

Working with PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with PivotCharts Exporting and Importing

Exporting and importing text files
Querying external databases

Using Analytical Options
Working with Goal Seek and Solver
Working with scenarios
Working with views

Working with Macros
Running and recording a macro
Viewing VBA code
Function procedures

Interactive Web Pages
Creating interactive Web spreadsheets
Publishing PivotTables on the Web

Some feedback from recent courses...

"Very good course, covered a lot of areas"
- S.M, Le Meridien
[Excel Advanced]

"Trainer was great. She kept the course moving while also making sure that everyone was keeping up. I feel confident that I can apply what I've learned at work to make my life easier!"
- E.K, Tourism Australia
[Excel Advanced]

"Thankyou!"
- P.F
[Excel Advanced]

Click here for our client list