Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Excel 2003 Advanced

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:

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


Rate this page:
3.3/5 (4 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard