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,252 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
5 November 2026 Thu London Islington Hurry. One place left. £349 £120 £229 + VAT
2 December 2026 Wed Online Hurry. One place left. £349 £100 £249 + VAT
13 January 2027 Wed London Islington Available £349 £70 £279 + VAT
9 February 2027 Tue Online Available £349 £50 £299 + VAT
8 March 2027 Mon London Islington Available £349 £349 + VAT
9 April 2027 Fri Online Available £349 £349 + VAT
6 May 2027 Thu London Islington Available £349 £349 + VAT
4 June 2027 Fri Online Available £349 £349 + VAT
30 June 2027 Wed London Islington Available £349 £349 + VAT
26 July 2027 Mon Online Available £349 £349 + VAT
24 August 2027 Tue London Islington Available £349 £349 + VAT
23 September 2027 Thu Online Available £349 £349 + VAT
No in-person dates available at the moment.
Course dates Days Location Places RRP Discount You pay
5 November 2026 Thu London Islington Hurry. One place left. £349 £120 £229 + VAT
13 January 2027 Wed London Islington Available £349 £70 £279 + VAT
8 March 2027 Mon London Islington Available £349 £349 + VAT
6 May 2027 Thu London Islington Available £349 £349 + VAT
30 June 2027 Wed London Islington Available £349 £349 + VAT
24 August 2027 Tue London Islington Available £349 £349 + VAT
Course dates Days Location Places RRP Discount You pay
2 December 2026 Wed Online Hurry. One place left. £349 £100 £249 + VAT
9 February 2027 Tue Online Available £349 £50 £299 + VAT
9 April 2027 Fri Online Available £349 £349 + VAT
4 June 2027 Fri Online Available £349 £349 + VAT
26 July 2027 Mon Online Available £349 £349 + VAT
23 September 2027 Thu Online Available £349 £349 + VAT

Private & team training

Get 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

5 November 2026

Thu

Location
London Islington
Places
Hurry. One place left.
RRP
£349
Discount
£120
You pay
£229 + VAT

2 December 2026

Wed

Location
Online
Places
Hurry. One place left.
RRP
£349
Discount
£100
You pay
£249 + VAT

13 January 2027

Wed

Location
London Islington
Places
Available
RRP
£349
Discount
£70
You pay
£279 + VAT

9 February 2027

Tue

Location
Online
Places
Available
RRP
£349
Discount
£50
You pay
£299 + VAT

8 March 2027

Mon

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

9 April 2027

Fri

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + VAT

6 May 2027

Thu

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

4 June 2027

Fri

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + VAT

30 June 2027

Wed

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

26 July 2027

Mon

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + VAT

24 August 2027

Tue

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

23 September 2027

Thu

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + 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,252 Reviews
9.8/10 Satisfaction
99.6% Recommend

Very clear instructions, a lot of excercises to practice the tasks, very detailed course

Magda – 30 September 2026

Good explanation, relevance of subject to my job role, good to go over what we covered last time. Good location for the course.

Karen – 30 September 2026

Clearly explaining and answering questions.

Gary – 9 September 2026

Knowledge base. keeping at a good level for all students while making sure everyone was getting it.

Linda – 9 September 2026

I felt like it was an informative session that felt like an Excel bootcamp. Kevin was very knowledgeable, and if we had any queries, he was…

Hilary – 9 September 2026

Great Explanations and easy to understand

Chloe – 24 July 2026

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

Grace – 24 July 2026

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

Anell – 21 July 2026

Swipe for more

Read course reviews

Who attends?

Getting better at your job icon

Getting better at your job

You need a skill for the role you already have, or your employer is investing in the team.

Changing career icon

Changing career

You're moving into a new field and need the practical skills it asks for.

Just graduated icon

Just graduated

You know the theory. A practical course and a certificate of attendance show employers you can do the work.

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.