WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
Wise Owl Training
See 479 reviews for our classroom and online training

Classroom Training

Classroom training course - online version also available

£750 + VAT for most venues (£895 + 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 18 July 2022
• Time:09:30-16:30

Course Contents

The contents of this course are as follows:

• 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

• 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

• Removing duplicates
• Grouping/outlining controls

Pivot tables

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

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

Getting data (was Power Query)

• Using different data sources
• Query steps
• The "Column by example" transform

If time

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

If time

Scenarios

• Creating what-if scenarios
• The scenario manager

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

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

"Our trainer was patient and friendly and made what seemed like another language make sense!"

Chantelle Hare (Hampshire and Isle of Wight Fire and Rescue Service)

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

"Our trainer was really knowledgeable and explained things well. There was the right number of breaks and the course length was good. I enjoyed the online training more than I thought I would, there were no technical issues either."

Maria White (The Office of the Director of Public Health)

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

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

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
Mon/Tue 18-19 July 2022 2 £750 Book places
Thu/Fri 22-23 September 2022 2 £750 Book places
Thu/Fri 17-18 November 2022 2 £750 Book places
Date(s) Venue
18/07
22/09
17/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).

Excel Modelling

2 day course

Excel VBA macrosRECOMMENDED

VBA macros in Excel

2 day course

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

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

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 VBA knowledge or Test your Excel 365 skills skills assessment tests

Excel blogs

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

View Excel, PowerPivot or VBA macros blogs