Intermediate Excel Course

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

Master intermediate Excel skills to handle data efficiently, create advanced formulas, and build professional spreadsheets on this 1-day, highly-rated course with practical exercises

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

Intermediate Excel Course Introduction

Gain the knowledge and skills to handle larger datasets, create advanced formulas and analyse data effectively on this 1 day Intermediate Excel course.

From working with named ranges and 3D calculations to using features like data validation, filters, and conditional formatting.

Along with plenty of shortcuts, tips, and techniques to improve your efficiency and create professional-looking spreadsheets.

These skills will equip you to use Excel more effectively and confidently.

This course is suitable for users of Excel 2010/2013/2016/2019 & 365 (including Excel for Mac) and includes helpful course notes for future reference.

 

Build Your Microsoft Excel Skills

This course is perfect for anybody who uses Excel in their day to day roles but have limited experience in creating more complex formulas or using features to customise their spreadsheets.

You will learn the features and functions, as well as the theory, that will allow you to easily build a spreadsheet that can pull the data you need and display it in a readable way. 

This is also an ideal next step for those who’ve completed our beginner course and would like to gain more insight.

Intermediate Excel Course Outline

  • Quick Recap of Useful Introduction Features

    • Customising the Quick Access Bar
    • Creating and using custom lists
    • Page set up shortcuts
    • Revision of basic formulas such as AutoSum, Min, Max and Average
    • Behaviour of Relative cells v Absolute cells

     

    Sorting and Filtering

    • Applying a Filter to your data
    • Sorting a filtered list

     

    Linked drop-down lists

    • Use the Indirect function to create linked drop-down menus

     

    Conditional Functions

    • Use COUNTIF, AVERAGEIF and SUMIF
    • Use COUNTISF, AVERAGEIFS and SUMIFS
  • Manipulating Workbooks

    • Renaming and deleting worksheets
    • Colouring worksheet tabs
    • Moving and copying worksheets within the workbook & into new or existing workbooks

     

    Subtotals

    • Creating outer sub totals
    • Producing inner sub totals
    • Using the Outlining feature

     

    Linking Workbooks

    • Create external links between books
    • Edit links
    • Break links

     

    3D Calculations

    • Grouping worksheets
    • Using 3D Calculations
  • Excel Tables

    • Benefits of Excel Tables
    • Converting an Excel range (data) into an Excel table
    • Adding and using a Slicer
    • Finding & removing Duplicates
    • Using automatic Freeze Panes
    • Converting back to Excel range

     

    Data Validation

    • Adding validation rules  to cells to limit data input
    • Using data validation to create drop-down lists
    • Managing invalid data
    • Remove data validation

     

    IF and Nested IF Function

    • Creating and performing calculation using a single level IF function
    • Creating calculations using Nested IF function
    • Creating calculations using IFS function

     

    Conditional Formatting

    • Creating a conditional formatting rule
    • Editing the rule
    • Using Icon sets to format reports
    • Amend criteria in Icon sets

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 Is this course for?

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.

This is also the next step for anyone who has attended our Beginners Excel course.

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

 

Intermediate Excel Course Topics

This one day course covers:

  • Using Filters & Sorting Data
  • Linking and Manipulating Workbooks
  • Creating Sub Totals
  • Data Validation
  • Creating Drop Down Lists
  • Working with Tables
  • Conditional Formatting
  • IF & Nested IF
  • 3D Calculations

Download the full course outline

 

Intermediate Excel Course Day Details

Our 5 star rated Intermediate 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 Intermediate Excel Courses

Our scheduled public Intermediate 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 Intermediate Excel Training

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.

Course Reviews

I really enjoyed the [Excel} course as I am self-taught and although I knew some parts, I discovered better/quicker ways of doing them and lots of new tips too. Our trainer was very patient and helpful if any of us needed to ask questions.

Jan Hutson
Irvine Springs

Course Reviews

I thought the [excel] training was very useful. It’s funny how you can be working with some more advanced features on Excel but yet are not aware of some of the basic work-a rounds that speed things up. The trainer was personable, knowledgeable and professional and the training provided came over well ensuring participants of all skill levels were catered for. Personally I felt the training was worthwhile as I am already using some of the tips I picked up yesterday :)

Andy Batty
Beldam Crossley

Course Reviews

I found [the excel course] very helpful – especially when you think the way you work in excel is the best way but in actual fact there is a quicker easier way to get the same result.

Diane White
Precision Products (UK) Ltd

Course Reviews

Well presented [excel course] in a clear and easy to follow method. Plenty of time given at each stage. For me virtually everything covered on the course was a ‘new feature’ that I can implement – so it was of great benefit. Looking forward to the advanced [excel] course …………..

Steve Johnson
Precision Products (UK) Ltd

Course Reviews

I have just finished the Intermediate Excel course and wow I didn’t realise how much I didn’t know, the Introduction course was very useful and I have used most of the information already, today’s course will save me lots of time with charts, graphs etc and overall I found this course to be excellent, Ben is very thorough and very helpful it was a pleasure to be on the course and look forward to the advanced course in December! :)

Angie Jackson
Ellard

Course Reviews

I definitely found yesterdays [excel] course very helpful and I look forward to completing the Advance course in the near future.

Cherii Carroll
Verplas Ltd

Course Reviews

I very much enjoyed both [excel] training sessions that I attended. Both were delivered perfectly. Ben managed to keep the pace at a level where I still felt engaged and not left behind, always ensuring everyone had understood each example. I would certainly recommend these [beginner and adavanced excel] courses.

Natasha Miller
Adam Equipment

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

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

Paula Gill
Science & Industry museum

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

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

Intermediate Excel Course Dates

Browse all public Intermediate 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
  • 18 December 2025
  • Manchester
  • View
  • 09 January 2026
  • Leeds
  • View
  • 20 January 2026
  • Online
  • View
  • 23 January 2026
  • Birmingham
  • View
  • 23 January 2026
  • Liverpool
  • View
  • 05 February 2026
  • Leeds
  • View
  • 11 February 2026
  • Manchester
  • View
  • 19 February 2026
  • Birmingham
  • View
  • 24 February 2026
  • Online
  • View
  • 05 March 2026
  • Leeds
  • View
  • 05 March 2026
  • Liverpool
  • View
  • 12 March 2026
  • Manchester
  • View
  • 24 March 2026
  • Online
  • View
  • 27 March 2026
  • Birmingham
  • View
  • 02 April 2026
  • Leeds
  • View
  • 08 April 2026
  • Liverpool
  • View
  • 09 April 2026
  • Manchester
  • View
  • 01 May 2026
  • Birmingham
  • View
  • 05 May 2026
  • Online
  • View
Enquire about a private course

FAQs

  • How long is this course

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

  • 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

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

  • Can I pay by invoice / PO?

    Yes. We provide an invoice for every booking. This will be emailed to you once the booking has been made, it contains our bank details, for payment by Bank transfer, along with a link to make payment Online with a credit or debit card.

    If you require to set us up as a supplier, that is fine, just let us know and we can provide you with all the information you need.

  • 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

  • Can I take these courses online?

    Absolutely. We offer live, instructor-led online versions of all courses. You’ll get the same expert guidance, interactive activities, and practical tools as the in-person sessions, just delivered virtually via Zoom or Teams.

Other Courses You Might Be Interested In

Beginners Excel Training Course

This is a one day training course that gives you an introduction to using Microsoft Excel features and shortcuts. It is designed for anyone who only has a little (or no knowledge) of using Excel.

From £195
MORE INFO...

Advanced Excel Course

This is a one day training course that takes you through some of the more advanced features of Excel. It is designed for people who know the basics but want to extend their knowledge/skills in using Excel.

From £195
MORE INFO...

Powerpoint Training Course

Learn how to create a more impressive PowerPoint presentation using the extensive features of PowerPoint.

From £250
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