Excel 2010 Advanced Course
2007 / 2003 courses - click here
London and UK wide
1 day instructor-led. Courses never cancelled: Guaranteed. From £150 (list price £299)
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 2010 Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
Prerequisites
A working knowledge of Excel or our Excel Intermediate course.
Benefits
At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
Course Syllabus
| Using logical functions Working with lookups Advanced list management |
PivotTables and PivotCharts Using analytical options Macros |
Public Schedule - Pricing and Availability
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2010 | Fri 24 Feb 2012 | Limehouse | 6 | ![]() |
£285 | £295 | £299 | ||
| 2010 | Fri 9 Mar 2012 | Southwark | 6 | ![]() |
£285 | £295 | £299 | ||
| 2010 | Fri 23 Mar 2012 | Bloomsbury | 7 | ![]() |
£273 | £283 | £299 | ||
| 2010 | Tue 17 Apr 2012 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Tue 8 May 2012 | Bloomsbury | 7 | ![]() |
£252 | £262 | £299 | ||
| 2010 | Tue 29 May 2012 | Southwark | 8 | ![]() |
£252 | £262 | £299 | ||
| 2010 | Tue 12 Jun 2012 | Bloomsbury | 9 | ![]() |
£160 | £170 | £299 | ||
| 2010 | Tue 26 Jun 2012 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Tue 10 Jul 2012 | Southwark | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Wed 25 Jul 2012 | Bloomsbury | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Wed 8 Aug 2012 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Mon 20 Aug 2012 | Southwark | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Wed 5 Sep 2012 | Bloomsbury | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Fri 21 Sep 2012 | Bloomsbury | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Mon 8 Oct 2012 | Bloomsbury | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Wed 14 Nov 2012 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Thu 29 Nov 2012 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Thu 13 Dec 2012 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Thu 17 Jan 2013 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Mon 4 Feb 2013 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
| 2010 | Fri 22 Feb 2013 | Limehouse | 10 | ![]() |
£150 | £160 | £299 | ||
"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.
|
Creating Tables Automatically In Excel 2010 It used to be the case that users would have to add data to a spread sheet and then manually format the data into a table. This manual process is made far more efficient with the automatic table tool, which can turn the data into a functionality filled and beautifully designed table. This article will examine how to use this functionality. » Article: Training microsoft excel |
» Forum post: Function |
» Tip: Generate andom numbers |



Course updates





