Advanced Excel Training Course

Duration :1 DayCost: From £195
Venues :Manchester | Leeds | Birmingham | Liverpool | Online

Advanced Excel Training Course

Learn how to use advanced features of Excel to manipulate data and create detailed, useful spreadsheets on this 1 day, 5-star rated course.

  • 6 Small Class Sizes
  • 5 star rated courses
  • Practice led learning
  • 3 month online support
  • Lunch & refreshments provided

Select from the tabs below to find out more:

Advanced Excel Course Dates

Browse all public Advanced Excel course dates below or use the filter to show only dates in specific locations.

Filter by venue:
  • Course Dates
  • Venue
  • 30 July 2025
  • Liverpool
  • View
  • 29 August 2025
  • Liverpool
  • View
  • 26 September 2025
  • Liverpool
  • View
  • 24 October 2025
  • Liverpool
  • View
Private Course Enquiries

Private Advanced Excel Course

We are happy to run private Advanced Excel courses at your offices, at our Manchester office, or at a venue to suit you.

The course content can be adapted to suit your requirements. Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.

Private Advanced Excel courses are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.

Private Course Costs:

The cost of any private courses is dependent on the number of delegates, the location, the length of the course and the degree of adaption of the course. The following are for guidance only:

Private one to one classroom-based courses are available from £590 plus VAT

Private Group Courses in Excel are available from £690 plus VAT 

Online Private Advanced Excel Courses are available from £550 + VAT (6 hours).

To get a quote please complete the form below or call us on 0161 226 6032.

Private Advanced Excel Course Enquiry

google-logo.jpg
5
  • Useful Functions

    • Concatenate
    • Left, Right, Trim and Proper
    • Text to Columns
  • Analysing data using Pivot Tables

    • Understanding Pivot Tables
    • Using recommended pivot tables
    • Editing a pivot table’s data source
    • Refreshing pivot table data
    • Adding calculated fields
    • Creating slicers
    • Linking slicers to other pivot tables
    • Adding timelines (Office 2013 & above)
    • Filtering
    • Calculating percentages from data
    • Finding and replacing blanks within a pivot table
    • Producing Pivot Charts
  • Auditing Data

    • Tracing precedents and dependents
    • Error checking
    • Adding a Watch Window
    • Displaying Formulas
  • What-If Tools

    • Using the Payment function (PMT)
    • Applying Goal seek
    • Creating multiple scenarios and producing a scenario report
    • Creating a data table
  • LookUp Tables

    • Create VLookUps
    • Nesting IFNA or IFError into a VLookUp
    • Produce a HLookUp
    • XLookUp
    • Use the Index/Match feature as an alternative to VLookUp
  • Macros

    • Record a new macro
    • Perform basic editing using VBA
    • Add a macro to the quick access bar
    • Run a macro from an object in a worksheet
    • Save a workbook containing a macro
  • Workbook Security

    • Add a password to a workbook
    • Add security to worksheets
    • Secure elements of a worksheet
    • Securing formulas
    • Adding security to the book
  • Dynamic Array Functions

    • Understand Dynamic Array Functions
    • Unique
    • Sort and Sortby
    • Filter
    • Sequence
  • Chat GPT for Excel

    • What is ChatGPT
    • Formulas from a description
    • Troubleshoot a broken formula
    • Complex Formula
    • Macro Example
    • Best Practice

Manchester Advanced Excel Courses

Our Manchester Venue:

All our Advanced Excel Manchester courses are run from 9.30am to 4.30pm at our head office:

Rutherford House
Manchester Science Park
Pencroft Way
Manchester
M15 6SZ

Public Transport/Parking:

The closest public park is Cecil Street Car Park - 5 min walk

Manchester Oxford Road Train Station - 15 min walk

Manchester Piccadilly Train Station - 30 min walk

Access

Please let us know in advance if you have any mobility issues and will need any assistance.

More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page

Birmingham Advanced Excel Courses

Our Birmingham Venue:

Our public Advanced Excel courses in Birmingham are usually ran 9.30am to 4.30pm at:

Innovation Birmingham Campus,

Faraday Wharf,

Holt Street,

Birmingham,

B7 4BB

Public Transport /Parking:

Parking is available at Faraday Wharf and is located on Love Lane off Holt Street. Please note that parking here is charged and subject to availability. 

Both Birmingham Snow Hill and Birmingham Moor Street rail stations are situated just a short 15-minute walk away from the Innovation Birmingham Campus.

More Information about our Birmingham training courses, along with a map, can be found on our Birmingham Training page

Online Advanced Excel Courses

The Online Advanced Excel courses are run on Zoom.

You will be sent a link to join the training session the day before the course along with any course materials needed.

The courses run from 9:30 am to 4/4:30 pm. 

Because we limit the number of delegates to a maximum of 6 on our public courses specific timings are flexible, but generally, the day will run as follows:

9.20 am | Sign in

9.30 am | Start - First session

11.00 am | 15 min break

11.15 am |  Second session

12.30 pm  | 30 min break

1.00 pm  | Third session

2.15 pm | 15 min break

2.30 pm | Fourth session

3.50 pm | Finish & Q&A

4.30pm | End

Find out more about how our online courses work on the Online Courses Page

Leeds Advanced Excel Courses

Our Leeds Venue:

Our public Advanced Excel Courses in Leeds are start at 9.30 am and finish at 4 pm.

The courses are either held at:

West One,

100 Wellington Street,

Leeds,

LS1 4LT

(venue subject to change)

 

Public Transport /Parking:

There are a few public car parks close to the venue, the nearest is Wellington Street Multi-Story Car Park.

The venue is also only a 15 minute walk from Leeds Train Station.

More Information about our Leeds training courses, along with a map, can be found on our Leeds Training page

Advanced Excel Course in Liverpool

Our Liverpool Venue:

Our public Liverpool Advanced Excel Courses are usually ran at 9.30am to 4.30pm at:

The Plaza
Liverpool,
L3 9QJ

(venue subject to change)

Public Transport/Parking:

The closest public car park is St Paul's Square Car Park which is around 1 minute walk from The Plaza.

The venue is a 20 minute walk from Liverpool Lime Street Station, however the closest station is Moorfields which is a 10 minute walk.

More Information about our Liverpool training courses, along with a map, can be found on our Liverpool Training page

Advanced Excel Course Reviews

35
Other Courses You May Be Interested In
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • AZ 2.png
  • Amazon
  • barclays-course.png
  • BC 2.png
  • Bt
  • Bupa
  • chanel 2.png
  • Jd Sports
  • Jet2com
  • Manchester client logo 8.png
  • Manchester City training 2.png
  • nestle training 2.png
  • Next
  • nhs-logo.png (1)
  • M Training Clients 10.png (1)
  • PTL-Manchester-training-client-logo-200.png
  • skym-courses.png (1)
  • client logo leeds.jpg
  • coop manchester 2.png
  • Tui
  • liverpool training 2.png
  • Siemens
  • Kraftheinz
  • HM Government
Head Office: Base, Greenheys Lane, Manchester Science Park, Manchester, M15 6LR
Leeds: West One, 114 Wellington St, Leeds, LS1 1BA
Birmingham: Innovation Birmingham, Faraday Wharf, Birmingham, B7 4BB
Click here to sign up for offers, advice and industry news Subscribe