Classroom Training
Classroom training course - online version also available
£585 + VAT for most venues (£685 + VAT for London)
2 days
Excel can do so much more than simple formulae! This two-day advanced course will show you how to use VLOOKUP and MATCH/INDEX functions, create pivot tables and much, much more. The idea is that by the time you finish the course you will have seen virtually everything that Excel can offer(apart from VBA, the subject of a separate two-day Excel VBA course).
The contents of this course are as follows:
If time
If time
If time
Delegates should already have a good working knowledge of Excel (one way to achieve this would be to attend our one-day introduction to Excel and one-day intermediate Excel courses). Note that the course uses Excel 2016, although if you're using Excel 2013, 2010 or even 2007 you'll still find the vast majority of this course useful (you can see what's different about Excel 2016 here).
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Charlotte Carson (Barbican Insurance / Arch Capital Gp Ltd)
Hannah Rodger (Barbican Insurance / Arch Capital Gp Ltd)
Ross Smith (Marley Ltd)
Cameron Copeland (ICE Futures Europe)
Sammi Lee (Kier Highways Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Here are the classroom Excel Advanced courses we have scheduled for the next 3 months:
Dates | Days | Venue | Price | Booking |
---|---|---|---|---|
Tue/Wed 18-19 May 2021 | 2 | Manchester | £585 | Book places |
Thu/Fri 15-16 July 2021 | 2 | Manchester | £585 | Book places |
Date(s) | Venue |
---|---|
18/05 | Manchester |
15/07 | Manchester |
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Excel training at your offices (we'll even provide and set up the computers).
View Excel, Excel VBA or PowerPivot exercises
View Excel tips, Excel VBA - Basics, Microsoft Excel or PowerPivot videos
View Test your VBA knowledge or Test your Excel 365 skills skills assessment tests
View Excel, Power BI - Excel or VBA macros blogs