Bookmark page
Printable version
Excel training in London & UK wide
Microsoft Excel 2003 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 2003 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. You will then be qualified to progress to the VBA course for Excel.
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 | 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.
 |
Tell AutoFill What To Do And It Will Oblige AutoFill is a useful function in Excel that many of us are familiar with. It saves time by automatically inserting predictive data, such as numbers, months or days. But there is more to AutoFill than entering the straightforward, as this article shows. » Article: Excel training london |
» Forum post: Date |
» Tip: Count Text Counta |
When I add a value in a cell (an amount of money for example) is it possible to have the today's date appear in a correspondant cell in another column?
If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =CO...
