Microsoft Office training - Excel Advanced

Excel Training

Advanced Excel Training Course

£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:Manchester, London
Next course:Tue 02 October 2018
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Advanced IFs

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

Lookup functions

Using VLOOKUP for continuous values
Using VLOOKUP for exact matches
List 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

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
526 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

"We had a brilliant trainer. He engages trainees and delivers the topics clearly and concisely."

Michael Siddall (Lex)

"Excellent course, content and delivery. Manuals, exercises and take away info is excellent. Will highly recommend to anyone. I like the six person limit and easy to use website which I'll use in the future."

Robert Cooper (Royal Sun Alliance (RSA Group))

"Very good course, paced correctly, full answers given. Like the memory stick; will be very, very useful."

Robert Stevenson (Cross Keys Homes)

"I would like to say the training was absolutely fantastic, the trainer was brilliant and was able to answer any questions regardless of the context or complexity. The session was intense but well-paced and there was a great deal of flexibility so that it could be tailored to the three of us on the course! I had high expectations but was still surprised at the number of topics I learned including some interesting ad-hoc topics which were fascinating. I am going to beg my managers for as much budget as possible so that I can come back for more courses in the near future!! Thank You very much! "

Adam Yates (Bako North Western Ltd)

"Very good manual, easy to understand and follow."

Elena Nedelcu (Halliburton)

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

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

Scheduled Excel Advanced training dates

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

Dates	Days	Venue	Price	Booking
Tue/Wed 02-03 October 2018	2	Manchester	£585	Book places
Mon/Tue 12-13 November 2018	2	Manchester	£585	Book places
Thu/Fri 22-23 November 2018	2	London	£685	Book places
Mon/Tue 07-08 January 2019	2	Manchester	£585	Book places
Thu/Fri 24-25 January 2019	2	London	£685	Book places
Thu/Fri 14-15 February 2019	2	Manchester	£585	Book places
Tue/Wed 02-03 April 2019	2	Manchester	£585	Book places

Date(s)	Venue
02/10	Manchester
12/11	Manchester
22/11	London
07/01	Manchester
24/01	London
14/02	Manchester
02/04	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).