To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.
Classroom training -  Excel Advanced

Classroom Training

Advanced Excel

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).

Course details

  • Locations for Excel Advanced coursesPossible locations:London, Manchester, Online
  • Next Excel Advanced course locationNext classroom course:Tue 04 August 2020
  • Excel Advanced course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Advanced IFs

  • Revision of single IFs
  • Nesting =IF
  • =IFS and =SWITCH

Lookup functions

  • Using VLOOKUP for continuous values
  • Using VLOOKUP for exact matches
  • Data validation for exact matches
  • Dynamic range names
  • Handling errors in lookup tables

Advanced lookup functions

  • Using = MATCH to find values
  • Combining =INDEX and =MATCH
  • The OFFSET function
  • The INDIRECT function

Text functions

  • Basic text functions
  • Finding and replacing text
  • Extracting and joining text

Multiple worksheets

  • Group editing
  • Formulae across sheets
  • 3D summing across sheets

Advanced tables

  • Removing duplicates
  • Advanced filters (multiple criteria)
  • Adding and removing subtotals
  • Grouping/outlining controls

Pivot tables

  • Creating pivot tables
  • Changing the aggregation function
  • Drilling down
  • Filtering and sorting

Advanced pivot tables

  • Grouping fields
  • Showing % of grand totals, etc
  • Slicers and timelines

Getting data (was Power Query)

  • Using different data sources
  • Query steps
  • Massaging data before loading it
  • The "Column by example" transform

Covered if time allows If time

Advanced charts

  • Combination charts
  • Regression and trendlines
  • Picture charts
  • Sparklines

Covered if time allows If time

Scenarios

  • Creating what-if scenarios
  • The scenario manager

Covered if time allows If time

Goal-seeking

  • Targeting a given value
  • Setting the number of iterations

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).

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Very enjoyable, informative, fun and educational. Maintained an excellent level of teaching and professionalism throughout."

Cameron Copeland (ICE Futures Europe)

"Good content delivered in an easy-to-understand manner, without over-complicating. Been on previous courses & good experience, so natural progression."

Daniel Gates (ICE Futures Europe)

"The trainer was very helpful in answering any questions and explained everything well and in detail."

Sammi Lee (Kier Highways Ltd)

"Very enjoyable. Trainer knowledgeable and helpful."

Ross Smith (Marley Ltd)

"Really enjoyed the course. Great pace. Learnt loads of useful tips. Looking forward to advanced course. Great website."

Nicola Leah (Shell International Trading and Shipping Company Ltd.)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Excel Advanced training dates

Here are the classroom Excel Advanced courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 04-05 August 2020 2 £585 Book places
Thu/Fri 27-28 August 2020 2 £685 Book places
Mon/Tue 05-06 October 2020 2 £585 Book places
Thu/Fri 22-23 October 2020 2 £685 Book places
Thu/Fri 05-06 November 2020 2 £685 Book places
Thu/Fri 19-20 November 2020 2 £585 Book places
Date(s) Venue
04/08
27/08
05/10
22/10
05/11
19/11

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).

Related Courses

Excel Business Modelling

Excel Modelling

2 day course

Excel VBA macros RECOMMENDED

VBA macros in Excel

2 day course

Other Microsoft Excel training resources

Excel exercises

Excel exercises

Don't book a course blind - have a look at some of our Excel exercises published online first, to see if you like our approach.

View Excel, Excel VBA or PowerPivot exercises

Excel videos

Excel videos

We've got loads of videos on Excel tips and other Excel subjects online.

View Excel tips, Excel VBA - Basics, Microsoft Excel or PowerPivot videos

Excel skills assessment

Excel skills assessment

To see how well you know Excel, try taking one of our tests - they're designed to show you how well you know Excel relative to others.

View Test your current Excel skills or Test your VBA knowledge skills assessment tests

Excel blogs

Excel blogs

There are lots of Wise Owl blogs on Excel, usually answering specific questions about the software.

View Excel, Power BI - Excel or VBA macros blogs

This page has 0 threads Add post