Advanced Excel Training Course

  • 1 Day
  • Manchester | Leeds | Birmingham | Liverpool | Online

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

Make an Enquiry/Booking

Choose a Public Course or Private Course below

From

£195 +vat
Make an Enquiry
  • Small class sizes
  • 5 Star Rated Course
  • Practical courses
  • 3 month support

Advanced Excel Course Introduction

If you have day to day experience of using Excel and you want to develop your skills further to use Excel more efficiently and to create more complex and useful spreadsheets, this course is for you.

It will give you theoretical knowledge and practical skills that you can take away and apply to your own spreadsheets and develop your Excel skills even further with confidence.

You will also be shown shortcuts, hints and tips to help you use Excel more efficiently.

This course is suitable for users of Excel 2010/2013/2016/2019 & 365 (Also Excel for Mac).

 

Learn Advanced Excel Skills

On this 1 day, 5-star rated, practical course you will be taken through exercises to help you understand how utilising formulas, pivot tables and macros can create complex but useful spreadsheets and reports in an efficient way.

As well as manipulating data, we will also look at formatting tools for you to display your data, or create forms, that are clear and user-friendly.

After the course, you will also be provided with helpful course notes for your own reference.

Advanced Excel Course Outline

  • Useful Functions

    • Concatenate
    • Left, Right, Trim and Proper
    • Text to Columns

     

    What-If Tools

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

     

    Workbook Security

    • Add a password to a workbook
    • Add security to worksheets
    • Secure elements of a worksheet
    • Securing formulas
    • Adding security to the book
  • 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

     

    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

     

    Dynamic Array Functions

    • Understand Dynamic Array Functions
    • Unique
    • Sort and Sortby
    • Filter
    • Sequence
  • Auditing Data

    • Tracing precedents and dependents
    • Error checking
    • Adding a Watch Window
    • Displaying Formulas

     

    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

     

    Chat GPT for Excel

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

Why Choose M Training

  • Small class sizes

    We run small classes so that there is more interactivity, opportunity for questions and is more personal.

  • Convenient Locations

    Public courses are held in Manchester, Leeds, Liverpool, Birmingham and Online. Private courses can be ran anywhere in the UK. 

  • Course Materials

    Detailed course materials are provided for each delegate as well as post course notes

  • Expert Trainers

    Run by an experienced Microsoft trainer and consultant

  • Follow up support

    Along with the course notes, you also recieve 3 months email support for any follow up questions that you may have. 

  • 5 Star Rated

    Our courses are rated 5 stars by delegates, through post-course feedback forms, on Google and Facebook.

Who Should Attend this Advanced Excel Training?

This course is designed for people who are currently using Excel within their work and have a good understanding of the basic data manipulations and formulas and want to expand on this.

You will have prior knowledge of Excel basics and are comfortable using Excel.

If you do not feel like you have enough knowledge of the basics of Excel take a look at our Beginners Excel or our Intermediate Excel Courses

 

Advanced Excel Course Topics

Below is a summary of the topics covered on the 1-day Advanced Excel course.

  • Useful Functions (Left, Right, Trim, Proper)
  • Creating and Using Pivot Tables
  • Linking Slicers & adding Timelines to Pivot Tables
  • Creating Pivot Charts
  • Error Checking
  • Adding a Watch Window
  • What-If Tools
  • Creating and using Lookups (Vlookup, Hlookup & Xlookup)
  • Creating and using Macros
  • Workbook Security
  • Creating Dynamic Array Functions
  • Utilising Chat GPT for Excel

For a full course outline click here to download a PDF

 

Advanced Excel Course Day Details

Our 5 star rated Advanced Excel courses are practical courses with small class sizes, a maximum of 6 delegates, which allows for plenty of time to interact with the trainer and ask any questions!

These are held as in-person classroom courses or as live, online courses (over Zoom). All courses, run from 9:30 am to 4:30 pm, with plenty of breaks.

Scheduled Advanced Excel Courses

Our scheduled public Advanced Excel Courses are run in Manchester, Birmingham, Leeds, Liverpool and Online. Dates for these can be found below and information about the venues can be found on the Timing & Venue Info tab.

Private / Bespoke Advanced Courses

We run private one to one and group Excel Courses at our training centres, or at a location to suit you, anywhere in the UK. These can also be held Online.

Advanced Excel Course Dates

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

Enquire about a private course
Filter by venue:
  • Course Dates
  • Venue
  • 07 January 2026
  • Manchester
  • View
  • 14 January 2026
  • Liverpool
  • View
  • 16 January 2026
  • Leeds
  • View
  • 20 January 2026
  • Online
  • View
  • 30 January 2026
  • Birmingham
  • View
  • 13 February 2026
  • Manchester
  • View
  • 13 February 2026
  • Leeds
  • View
  • 18 February 2026
  • Online
  • View
  • 27 February 2026
  • Liverpool
  • View
  • 06 March 2026
  • Birmingham
  • View
  • 11 March 2026
  • Manchester
  • View
  • 17 March 2026
  • Online
  • View
  • 20 March 2026
  • Leeds
  • View
  • 25 March 2026
  • Liverpool
  • View
  • 02 April 2026
  • Birmingham
  • View
  • 08 April 2026
  • Manchester
  • View
  • 21 April 2026
  • Online
  • View
  • 24 April 2026
  • Leeds
  • View
  • 01 May 2026
  • Liverpool
  • View
Enquire about a private course

Course Reviews

Rachel was a great teacher and was able to go through each [Advanced Excel] subject with us explaining in detail and was able to assist where needed with extra questions and help with assigned tasks to make things clear. Thank you

Nicola W
Expert Complete Property Maintenance Ltd

Course Reviews

Rachel was very personable and knowledgeable. I have already started to use some of the functions she demonstrated so I definitely think it will benefit me in my role. Thank you

Samantha S
Outwood Grange Academies Trust

Course Reviews

Excellent [Advanced Excel] training learned a lot from it and course was very well put together and informative.

Julian S
J & J Fire Engineering

Course Reviews

It was perfect and met my needs fully. Rachel was brilliant, a great trainer and very knowledgeable. I would highly recommend Rachel and M Training. I am planning to do more courses with them.

Torquil M
Star Brands Ltd

Course Reviews

Rachel was brilliant and very helpful. The way the [Advanced Excel] course was delivered was very easy to understand and Rachel answered any questions with detailed explanations.

Rebecca S
Tarnwest Ltd

Course Reviews

The team thoroughly enjoyed the [Advanced Excel] training and I have already seen them putting into practice the techniques they were taught on the day, which is fantastic! Edd is a brilliant trainer!

Natasha B
Golden Eagle Luxury Trains

Course Reviews

Louise was very knowledgeable and was great at teaching the different topics. The support provided was really good - there were four of us in the group and the speed which we went through topics was just right. I would be keen to book on to another course which covers different topics too!

Heather G
Cheshire Police

Course Reviews

Just wanted to say the [Advanced Excel] training was fab, Andy, the trainer was brilliant, the right pace and content with the right amount of humour!

Brett S
Dudley Metro Council

Course Reviews

The trainer was professional, non-judgemental on ability & really engaging, very much enjoyed my [Advanced Excel] training with her.

Callan M
Irish Community Care Manchester

Course Reviews

A really good experience from the initial enquiry to the [Intermediate Excel] training course. Would highly recommend. Sue was excellent, she taught in a relaxed way which I found understandable and the day flew by, but I learnt loads. Thank you to everyone.

Lisa D
BCA

Course Reviews

Really useful [Advanced Excel] course to develop my knowledge of excel. Andy gave me confidence that I knew more than I thought and lots of tips and tricks to help me use excel more efficiently. He really took the time to tailor the content of the course to the requirements of the group. Having a small group was hugely beneficial to achieve this as Andy had the time to answer all of our individual questions

Heather K
Taylors of Harrogate

Course Reviews

I just thought I’d drop you an email to say myself, Leva and Astrid were all really impressed with Louise on the [online] Advanced Excel Training yesterday. She was a really engaging trainer who remained enthusiastic even though she was clearly suffering with a cough!

Ella Clarke
Benchmark Estimating

Course Reviews

The [Excel] course was excellent. The trainer [Andy] was very approachable and knowledgeable - Highly recommended.

Paula Gill
Science & Industry museum

Course Reviews

Trainer has an excellent ability to apply Excel scenarios to your work industry. Complex questions answered effectively and good business application. Highly recommended.

Joe Reynolds
Harrison Products

Course Reviews

Even though this course was for Excel Advance it was presented in a way that I was able to understand all aspects of the course, which I will be forwarding on to my colleavues and implementing straight away. The course trainer was very friendly and was able to explain things in laymans terms if you had difficulties in understanding the process.

Karolina Protasiewicz
Complete Building Control

Course Reviews

Excellent Excel knowledge. professional and courteous presentation, I learned a lot, so thank you.

Nick Hincley
MCS

Course Reviews

Just wanted to say a massive thank you for the [Advanced Excel] training yesterday. Louise was a great trainer and I have learned so much from the training day.

Nathan Lumb
The University of Manchester

Course Reviews

Louise was a very accomplished tutor for the excel course and delivered everything that I expected from this. Learnt some new techniques and features that may come in useful in the future.

Susan Wilson
Kingspan

Course Reviews

This course was excellent and delivered really well. Thank you. I undertook the course to help improve my CV when applying for other jobs and on the back of having attended the Word & PowerPoint courses. The content isn't something I currently use in my role but has given me an insight into what can be done with Excel and I can practice with the worksheets sent to me.

Kirsty Long
Nat West Group

Course Reviews

The [Advanced Excel] course was excellent - would definitely recommend.

Jak Poole
Athena

Course Reviews

Excellent course. Covered all the areas where I wasn't feeling confident and have been self-taught. The trainer was clear and concise and went over details again if necessary.

Lauren Hoile

Course Reviews

Just wanted to say how much I enjoyed the online Excel session today. Louise was great, really knowledgeable and she delivered the training in a professional but personable manner. I got a lot of helpful tips and tricks, and got a chance to see functions I’ve not used before. I’m already thinking of how I can implement these to save time and help my team become more efficient.

Claire Murphy
St. Ann's Hospice

Course Reviews

Really enjoyable [Advanced Excel course] excited to apply this at work!

Siobhan Bone
Beever and Struthers

Course Reviews

The [Advanced] Excel course is great for getting to know how to use excel. Taught very well and clearly. Would recommend.

Seb Weston
OBI Property

Course Reviews

Really Enjoyable and Educational. Looking forward to applying to work. Thank You.

Clare Holland
Glancy Fawcett

Course Reviews

Very knowledgeable & understanding trainer. Easy to ask questions and get the right training due to the small groups. Definitely worth doing the [Advanced Excel] course.

Jordan Wood
Dawson Rodgers

Course Reviews

Really friendly and approachable [Advanced Excel] session. Learnt something that's going to save me hours of time in my working life. Thank you.

Demi Mottram
Dawson Rodger

Course Reviews

Very happy with the [Advanced Excel] course content. Will use most of what I've learnt. Very easy to follow, thank you

Andrea Dee
Glancy Fawcett

Course Reviews

I enjoyed the [Advanced Excel] course; Ed was very helpful and answered all my questions.

Yvonne Walsh
UCFB Manchester

Course Reviews

Fantastic [Advanced Excel] course, tailored to what we needed to learn. I have learnt a lot which I can take into my work.

Jill Harrison
British Council

Course Reviews

Everyone found the [Advanced Excel] course to be very useful and have learnt lots of new ways of using Excel.

Claire Hanbury
Long Rake Spar

Course Reviews

I really enjoyed the [Advanced Excel] course and found it most helpful especially with the pivot table section ... but the course helped me and I have put it in to good use already, your trainer was excellent and I would recommend the course to anyone that wanted to further their skills in Excel advanced.

Julie Bradshaw
Thermo Fisher Scientific

FAQs

  • How long is this course

    This is a 1 day course. Running from 9:30 am to 4/4:30 pm. 

  • Will I receive a certificate?

    Yes, all participants receive an M Training certificate of completion. This can be used for CPD records or as evidence of professional development in training skills.

  • Where are the courses held?

    This course is run in Manchester, Leeds, Liverpool, Birmingham and Online.

  • Where in Manchester is this course held?

    All our courses in are run from 9.30 am to 4.00 pm at our head office:

    Manchester Science Park
    Pencroft Way
    Manchester
    M15 6LR

    Public Transport/Parking:

    The closest public park is Manchester Science Park Visitor Car Park or 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. Disabled parking is provided.

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

  • Where in Leeds is this course held?

    Our public courses in Leeds  are usually held at:

    West Village,
    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

  • Where in Liverpool is the course held?

    The course in Liverpool is usually held at:

    The Plaza
    100 Hall Street 
    Liverpool
    L3 9QJ

    (subject to change)

     

    Parking

    There are several public car parks close to The Plaza.

    The closest are:

    St Paul’s Square Car Park: 0.02 Miles ~ 1 Minute Walk 

    NCP Liverpool Pall Mall Car Park: 0.2 Miles ~ 4 Minute Walk

     

    Public Transport

    We encourage all delegates to use public transport where possible.

    The Plaza is a 20 minute walk from Lime Street Station and a 4 minute walk from Moorfields train station.

  • Where in Birmingham is the course is the course held?

    Courses in Birmingham are usually held at:

    Cornwall Buildings
    45 Newhall Street
    Birmingham
    B3 2DF

    (subject to change)

    There are several public car parks close to Cornwall Buildings.

    The closest are:

    Euro Car Parks (Lionel Street): 0.2 Miles ~ 3 Minute Walk

    Snow Hill Station Car Park: 0.2 Miles ~ 4 Minute Walk

    Ludgate Car Park (Lionel Street): 0.2 Miles ~ 5 Minute Walk

     

    Public Transport

    We encourage all delegates to use public transport where possible.

    Cornwall buildings are located close to:

    Birmingham New Street Station: 0.4 Miles ~ 8 Minute Walk

    Birmingham Snow Hill Station: 0.2 Miles ~ 4 Minute Walk

     

    The M Training office in Birmingham is based at:

    Innovation Birmingham Campus,
    Faraday Wharf,
    Holt Street,
    Birmingham,
    B7 4BB

     

  • How do the Online courses work?

    The Online 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 and follow the same course outline as the classroom courses and you will be able to interact with the trainer and group and ask questions.

    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

  • What's the difference between Private & Public Courses?

    Public courses are scheduled and open for anyone to book on to. There is a maximum of 6 delegates on our public course to ensure that everyone receives tailored training.

    Private Courses are courses that are arranged specifically for individuals or groups, no one else can book on to these courses. Private course content can be tailored to suit your requirements

  • How interactive are the courses?

    Our courses are highly interactive. You’ll take part in discussions, group activities, and practical exercises designed to build real-world training skills in a supportive environment.

Other Courses You Might Be Interested In

Intermediate Excel Course

Learn how to use Excel to handle data efficiently, create more advanced formulas, and build professional spreadsheets on this 1-day course

From £195
MORE INFO...

Intro to VBA in Excel

Learn VBA for Excel, build practical macros, and streamline business workflows with this 5 star rated practical VBA Training.

MORE INFO...

Power Query Course

One-day Power Query course to streamline Excel data tasks and improve reporting accuracy.

From £295
MORE INFO...

1 Day Power BI Course: The Essentials

Learn the essential skills needed to create powerful reports and dashboards on this 1 day Power BI Course

£295
MORE INFO...
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
Manchester: 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
Liverpool: The Plaza 100 Old Hall Street Liverpool L3 9QJ
Click here to sign up for offers, advice and industry news Subscribe
Book this course