Bookmark page
Printable version
Advanced Excel course London & UK
Microsoft Excel 2000 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 2000 Advanced course is designed for those with experience of working regularily with Excel's spreadsheets and wish to understand and adopt the most complex functions and features.
Prerequisites
You should be comfortable with working with Excel's spreadsheets and basic formulae and features or have attended our Excel Intermediate course.
Benefits
At the end of this course, 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. Your level of proficiency should enable you to confidently take up 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 text files 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 |
||||||||
| 2010 | Mon 6 Feb 2012 | Limehouse | 3 |  |
£285 | £295 | £299 | ||
| 2007 | Mon 6 Feb 2012 | Bloomsbury | 3 | |
£232 | £242 | £245 | ||
| 2003 | Tue 7 Feb 2012 | Bloomsbury | 4 | |
£232 | £242 | £245 | ||
| 2007 | Fri 10 Feb 2012 | Limehouse | 7 | |
£232 | £242 | £245 | ||
| 2007 | Thu 16 Feb 2012 | Limehouse | 7 | |
£232 | £242 | £245 | ||
| 2007 | Wed 22 Feb 2012 | Bloomsbury | 0 | FULL | £245 | ||||
| 2010 | Fri 24 Feb 2012 | Limehouse | 7 | |
£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 | ||
| Full Schedule: See all 103 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.
A lot of people search for us using search phrases including: excel.advanced.course, advanced+excel+courses, advanced excel class, advanced excel courses, advanced+excel+course and advanced excel course. Most people find it useful to have a look at our Excel training overview page.
 |
How To Create A Multiple Pie Chart In Excel Ever wanted to create a chart with multiple pies? Read this article to discover how to build a composite chart with a central pie surrounded by details pies » Article: Excel training london |
» Forum post: Pivot table |
» Tip: Freeze Rows and Columns |
Please can you tell me how to create a pivot table and why are they used?
You can freeze rows and columns in your worksheet so they don't move. 
