Excel 2002 Advanced & VBA

Excel Training Courses

· Excel 2010 Introduction
· Excel 2010 Intermediate
· Excel 2010 Advanced
· Excel 2010 VBA Intro Intermediate
· Excel 2010 VBA Advanced
· Upgrade to Office 2010

· Excel 2007 Introduction
· Excel 2007 Intermediate
· Excel 2007 Advanced
· Excel 2007 VBA Intro Intermediate
· Excel 2007 VBA Advanced
· Upgrade to Office 2007

· Excel 2003 Introduction
· Excel 2003 Intermediate
· Excel 2003 Advanced
· Excel 2003 VBA Intro Intermediate
· Excel 2003 VBA Advanced

· Excel 2002 XP Introduction
· Excel 2002 XP Intermediate
· Excel 2002 XP Advanced
· Excel 2002 XP VBA Intro Intermediate

· Excel 2000 Introduction
· Excel 2000 Intermediate
· Excel 2000 Advanced
· Excel 2000 VBA Intro Intermediate

· Excel 97 Introduction
· Excel 97 Intermediate
· Excel 97 Advanced

· Excel Training On-site UK
· Excel Consulting Services
· Microsoft Excel Training
· Excel Tips, Tools and Resources

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