Skip to main content

Microsoft Excel Intermediate Course

Gain the confidence to take on more complicated tasks in Excel and work more efficiently with your data.

Learn new ways to manipulate, analyse and present information.

Gain the confidence to take on more complicated tasks in Excel and work more efficiently with your data. Learn new ways to manipulate, analyse and present information.

2,239 Reviews
9.8/10 Satisfaction
99.6% Recommend
See reviews
Microsoft Excel Intermediate training course

Microsoft Excel Intermediate Course

The Intermediate Excel course is designed to take your Excel skills to the next level.

Learn advanced techniques for data analysis, including powerful formulas and functions to manipulate and analyse data effectively.

Discover the power of conditional formatting to highlight key insights in your spreadsheets and learn how to make light work of managing large amounts of data.

This course equips you with the tools and knowledge to tackle complex data analysis tasks with confidence, helping you make informed decisions and unlock valuable insights from your data.

View course outline

Course Dates

Course Dates Days Location Places RRP Discount You Pay
9th Sep 26 Wed Online Hurry - One Place Left! £349.00 £120.00 £229.00 + VAT
30th Sep 26 Wed London Islington Available £349.00 £100.00 £249.00 + VAT
6th Oct 26 Tue Online Available £349.00 £70.00 £279.00 + VAT
16th Oct 26 Fri Online Hurry - One Place Left! £349.00 £70.00 £279.00 + VAT
5th Nov 26 Thu London Islington Available £349.00 £349.00 + VAT
2nd Dec 26 Wed Online Available £349.00 £349.00 + VAT
13th Jan 27 Wed London Islington Available £349.00 £349.00 + VAT
9th Feb 27 Tue Online Available £349.00 £349.00 + VAT
8th Mar 27 Mon London Islington Available £349.00 £349.00 + VAT
9th Apr 27 Fri Online Available £349.00 £349.00 + VAT
6th May 27 Thu London Islington Available £349.00 £349.00 + VAT
4th Jun 27 Fri Online Available £349.00 £349.00 + VAT
30th Jun 27 Wed London Islington Available £349.00 £349.00 + VAT
26th Jul 27 Mon Online Available £349.00 £349.00 + VAT
No in-person dates available at the moment.
Course Dates Days Location Places RRP Discount You Pay
30th Sep 26 Wed London Islington Available £349.00 £100.00 £249.00 + VAT
5th Nov 26 Thu London Islington Available £349.00 £349.00 + VAT
13th Jan 27 Wed London Islington Available £349.00 £349.00 + VAT
8th Mar 27 Mon London Islington Available £349.00 £349.00 + VAT
6th May 27 Thu London Islington Available £349.00 £349.00 + VAT
30th Jun 27 Wed London Islington Available £349.00 £349.00 + VAT
Course Dates Days Location Places RRP Discount You Pay
9th Sep 26 Wed Online Hurry - One Place Left! £349.00 £120.00 £229.00 + VAT
6th Oct 26 Tue Online Available £349.00 £70.00 £279.00 + VAT
16th Oct 26 Fri Online Hurry - One Place Left! £349.00 £70.00 £279.00 + VAT
2nd Dec 26 Wed Online Available £349.00 £349.00 + VAT
9th Feb 27 Tue Online Available £349.00 £349.00 + VAT
9th Apr 27 Fri Online Available £349.00 £349.00 + VAT
4th Jun 27 Fri Online Available £349.00 £349.00 + VAT
26th Jul 27 Mon Online Available £349.00 £349.00 + VAT

Private & team training

Request a quote for Microsoft Excel Intermediate

Available as private, bespoke or team training at our centre, live online, or at your venue. Customise the outline, train as a group, or book a one-to-one with an expert.

Course dates

Swipe for more dates

9th Sep 26

Wed

Location
Online
Places
Hurry - One Place Left!
RRP
£349.00
Discount
£120.00
You pay
£229.00 + VAT

30th Sep 26

Wed

Location
London Islington
Places
Available
RRP
£349.00
Discount
£100.00
You pay
£249.00 + VAT

6th Oct 26

Tue

Location
Online
Places
Available
RRP
£349.00
Discount
£70.00
You pay
£279.00 + VAT

16th Oct 26

Fri

Location
Online
Places
Hurry - One Place Left!
RRP
£349.00
Discount
£70.00
You pay
£279.00 + VAT

5th Nov 26

Thu

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

2nd Dec 26

Wed

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

13th Jan 27

Wed

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

9th Feb 27

Tue

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

8th Mar 27

Mon

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

9th Apr 27

Fri

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

6th May 27

Thu

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

4th Jun 27

Fri

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

30th Jun 27

Wed

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

26th Jul 27

Mon

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

Course Outline

1

Refresher on basic formulas & functions

Statistical functions (Average, Max, Min, Count and Counta)

Using relative & absolute addressing

Creating, using and editing range names

Locking cells and worksheets

2

Working with worksheets

Grouping worksheets

Setting tab colour

Performing calculations across sheets

3

Taking formulas to the next level

Using SUMIFS & COUNTIFS

The basic IF function

Simple VLOOKUP

4

Highlight data with formatting

Apply Conditional Formatting rules

Use the Conditional Formatting rules manager

Create Conditional Formatting using a formula

Clearing rules

5

Working with lists

Freezing panes

Filtering data

Using the subtotal tool

Formatting as a table

6

Questions and answers

This course is also available as a private course. If you wish we can tailor the content for your team. Please contact us for more details.

2,239 Reviews
9.8/10 Satisfaction
99.6% Recommend

Great Explanations and easy to understand

Chloe – 24th July 26

Talking things through, always asking if we had any questions.

Grace – 24th July 26

Monica was very good. Very engaging, took her take to explain things , and answered all questions. Would recommend

Anell – 21st July 26

Really good explanations, helpful to those who needed assistance with effective support, great examples to work with that we can practice o…

Maahin – 21st July 26

Hands on help with accraute detailed explanation. Super effective

Rory – 26th June 26

Relating each aspect to our own careers.

Henry – 11th June 26

Trainer Lisa was very engaging and demonstrated with exercises various intermediate excel functions, such as, conditional formatting, XLook…

Lucia – 11th June 26

The short cuts were very helpful, as there were so many i did not know and which will be very helpful in the future for me

Marie – 11th June 26

Swipe for more

Read course reviews

Who attends?

Career Progressives icon

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Career Changers icon

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Graduates icon

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Further Reading

8 Tips To Make You An Excel Expert article image

8 Tips To Make You An Excel Expert

Learning Excel is always useful whether you work with data or in finance.

Ways To Make Your PowerPoint Presentation Stand Out article image

Ways To Make Your PowerPoint Presentation Stand Out

Looking to impress your audience with amazing Powerpoint design presentation skills?

Why You Should Learn Microsoft Power BI? article image

Why You Should Learn Microsoft Power BI?

Microsoft Power BI turns raw data into clear, actionable insights.