Show as: Mobile

Excel - Advanced

Wise Owl
Course summary
Length: 2 days
Price: 585 - 685 GBP excl. VAT
Provider: Wise Owl plus
Course type: Open / Scheduled
Next available date: 27/03/2018 - Manchester
Course Dates
585 GBP
585 GBP
585 GBP
685 GBP
685 GBP
685 GBP

Course Description

Advanced Excel Training Course - London, Manchester, BirminghamLearn Advanced Skills in Microsoft Excel 2016 - 2-Day Course in London & Manchester

When it comes to Microsoft Excel, the possibilities are endless. This 2-day training course is designed to provide delegates with the advanced skill set required to take their excel sheets and presentations to the highest level. 

This course is targeted to excel users who are familiar with the program, but suspect that they could make better and broader use of the programme. Delegates of this course will work through exercises and practical activities to learn a new set of sophisticated and limitless excel functions. 

Suitability - Who should attend?

This advanced training course is suitable for individuals who have an understanding of the excel programme, but feel that they could gain more benefit from the programme. 

In order to make the most of each delegate's experience, class sizes are kept to a maximum of 6 delegates. 

Outcome / Qualification etc.

Advanced Excel Training CourseUpon completion of this advanced course, delegates will become able to apply and manipulate the Microsoft Excel programme more effectively and efficiently.

Training Course Content

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

Tracking changes

  • Turning tracking on/off
  • How tracking works
  • Accepting and rejecting changes

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

Advanced charts (if time)

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


The cost of this course is £585 + VAT per delegate for most venues and £685 + VAT for London. Lunch at a local restaurant is included in course fees as well as a USB stick with course files.

In-House Option

This course can also be delivered on-site for groups, teams or companies. 

Provider: Wise Owl

Wise Owl - Specialist Microsoft Training in London, Birmingham, Manchester and more

The Wise Owl team has made a name for itself delivering specialist Microsoft training for software enthusiasts, by software enthusiasts. With a team of six dedicated full-time trainers, Wise Owl have the knowledge, resources and enthusiasm to deliver Microsoft training...

Read more and show all courses with Provider: Wise Owl

Contact information for Wise Owl

Wise Owl

Kingsmoor House, Railway Street,
SK13 2AA Hadfield Derbyshire

 Show phone number

Reviews by course attendees

Hannah Elliot   |   02/11/2016
Amazing course, very beneficial, I learnt a lot. Fabulous course leader, easy to learn from.
Donna Stonehouse   |   05/12/2015
I felt I learnt a lot on the course.
Colin McGarry   |   03/12/2015
Excellent course - relevant and eye opening at times! Very good presentation.