Bookmark page
Printable version
Course updatesMicrosoft Excel Courses in London & UK wide
Microsoft Excel 2002 XP Advanced
1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £245)
Training formats available
- on a public schedule at one of our London training venues
- on-site at your company office UK wide (60 second quote)
- closed group at one of our London training venues (60 second quote)
- near-site at a location close to you
- bespoke one-to-one basis
- tailored training courses to your requirements
Who is this training course suitable for?
Our Microsoft Excel 2002 / XP Advanced course is designed for those with a good knowledge of Excel's most fundamental functions and wish to take advantage of the most complex functions and features.
Prerequisites
A sound working knowledge of Excel or our Excel Intermediate course.
Benefits
By the end of this course you will be proficient in the higher functions of Excel. As well as consolidating your understanding of Excel's fundamentals, you will be able to perform the most complex calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.
On completion of this course you will be capable of the tackling the syllabus for our VBA course for Excel.
Course Syllabus
Working with Advanced Formulas Lookups and Data Tables Advanced List Management Working with PivotTables and PivotCharts |
Exporting and Importing Using Analytical Options Working with Macros Interactive Web Pages |
Public Schedule - Pricing and Availability
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2007 | Thu 16 Feb 2012 | Limehouse | 4 |  |
£232 | £242 | £245 | ||
| 2007 | Wed 22 Feb 2012 | Bloomsbury | 0 | FULL | £245 | ||||
| 2010 | Fri 24 Feb 2012 | Limehouse | 6 | |
£285 | £295 | £299 | ||
| 2007 | Fri 2 Mar 2012 | Southwark | 7 | |
£232 | £242 | £245 | ||
| 2010 | Fri 9 Mar 2012 | Southwark | 6 | |
£285 | £295 | £299 | ||
| 2007 | Fri 9 Mar 2012 | Bloomsbury | 6 | |
£232 | £242 | £245 | ||
| 2003 | Thu 15 Mar 2012 | Bloomsbury | 5 | |
£232 | £242 | £245 | ||
| 2007 | Fri 16 Mar 2012 | Limehouse | 7 | |
£232 | £242 | £245 | ||
| 2010 | Fri 23 Mar 2012 | Bloomsbury | 7 | |
£273 | £283 | £299 | ||
| 2007 | Mon 26 Mar 2012 | Southwark | 9 | |
£232 | £242 | £245 | ||
| Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 22nd February 2013. |
|||||||||
"What do I get on the day?"
- Microsoft qualified trainers with industry relevant experience
- Modern air conditioned training suite, flat screen PC's, 1 per delegate
- Lunch provided in a comfortable and relaxed setting
- Comprehensive course material and files to take away
- What do I get on the day? - More information
What is Microsoft Excel?
Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.
 |
|
» Forum post: Pivot table |
Run through creating a pivot table
