Excel 2003 Advanced

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

Excel 2003 training is available at our 5 London centres, on-site or tailored training courses.

How to Book :: Training Schedule :: Contact Us

Other Excel training courses

Microsoft Excel 2003 Advanced

Duration: 1 Day
Prerequisites: A working knowledge of Excel or our Excel Intermediate course
See also: Excel VBA
Platform: PC

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

Other relevant courses:

Excel overview

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

How would you code in the step to select blank cells in paticular columns and fill them with the information from the cell above.
This is to achieve a complete table when viewing a summary so the visible cells can be copied into a new report of standard ..