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

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

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

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

Run by an experienced Microsoft trainer and consultant

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

Our courses are rated 5 stars by delegates, through post-course feedback forms, on Google and Facebook.
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
This one day course covers:
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.
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.
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 :)
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.
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 …………..
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! :)
I definitely found yesterdays [excel] course very helpful and I look forward to completing the Advance course in the near future.
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.
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.
The [Excel] course was excellent. The trainer [Andy] was very approachable and knowledgeable - Highly recommended.
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
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.
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.
This is a 1 day course. Running from 9:30 am to 4/4:30 pm.
This course is run in Manchester, Leeds, Liverpool, Birmingham and Online.
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
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
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
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
The course in Liverpool is usually held at:
The Plaza
100 Hall Street
Liverpool
L3 9QJ
(subject to change)
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
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.
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
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
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
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.
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.
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
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.
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.
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.
Learn how to create a more impressive PowerPoint presentation using the extensive features of PowerPoint.
Learn the essential skills needed to create powerful reports and dashboards on this 1 day Power BI Course