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

Possible locations:London, Manchester, Online
Next classroom course:Mon 13 September 2021
Time:10.00-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The contents of this course are as follows:

Advanced IFs

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

Lookup functions

The XLOOKUP function
VLOOKUP for continuous values
VLOOKUP for exact matches
Data validation for exact matches

Advanced lookup functions

The XMATCH function
Combining =INDEX and =MATCH
The OFFSET 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?

No more than 5 people per class
Proper restaurant lunch included
548 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

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

"Really enjoyed advanced filtering. Our trainer was wonderful, very friendly and always checking our understanding. Never felt left behind/rushed - very happy with this course."

Charlotte Steele (The Office of the Director of Public Health)

"Very good course - I enjoyed it and learnt a lot. The trainer taught the course very well and explained everything clearly. Recommendation came from colleagues."

Hannah Rodger (Barbican Insurance / Arch Capital Gp Ltd)

"The trainer was a really good teacher. She explained everything very clearly, went at my pace and made me feel at ease throughout the two days"

Charlotte Carson (Barbican Insurance / Arch Capital Gp Ltd)

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

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
Mon/Tue 13-14 September 2021	2	Manchester	£585	Book places
Tue/Wed 12-13 October 2021	2	London	£685	Book places
Thu/Fri 21-22 October 2021	2	Manchester	£585	Book places
Thu/Fri 25-26 November 2021	2	Manchester	£585	Book places
Tue/Wed 14-15 December 2021	2	London	£685	Book places

Date(s)	Venue
13/09	Manchester
12/10	London
21/10	Manchester
25/11	Manchester
14/12	London

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