Microsoft Excel Intermediate

Gain the confidence to take on more complicated tasks in Excel.

Learn new ways to manipulate data, analyse information, and automate tasks.

1205

Reviews

9.8

Satisfaction

99.5%

Recommend
Communal3

Microsoft Excel Intermediate

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.

Duration icon

One Day

Timings icon

10:00 - 16:30 GMT

  • icon Using more advanced formulas
  • icon Working with conditional formatting
  • icon Efficient worksheet management
  • icon Improved data analysis
  • icon Streamlined data organisation

You'll need to have attended our Excel Intro course or have equivalent working knowledge before joining this class.

Our Expert Team
Expert Trainers

Course leader is an experienced industry expert

Course Dates Days Location Places RRP Discount You Pay Action
11th Jun 25 Wed London Bridge Hurry - Two Places Left! £299.00 £100.00 £199.00 + VAT
8th Jul 25 Tue London Bridge Available £299.00 £70.00 £229.00 + VAT
5th Aug 25 Tue London Bridge Available £299.00 £50.00 £249.00 + VAT
5th Sep 25 Fri London Bridge Available £299.00 £20.00 £279.00 + VAT
1st Oct 25 Wed London Bridge Available £299.00 £299.00 + VAT
28th Oct 25 Tue London Bridge Available £299.00 £299.00 + VAT
25th Nov 25 Tue London Bridge Available £299.00 £299.00 + VAT
19th Dec 25 Fri London Bridge Available £299.00 £299.00 + VAT
21st Jan 26 Wed London Bridge Available £299.00 £299.00 + VAT
17th Feb 26 Tue London Bridge Available £299.00 £299.00 + VAT
17th Mar 26 Tue London Bridge Available £299.00 £299.00 + VAT
17th Apr 26 Fri London Bridge Available £299.00 £299.00 + VAT
13th May 26 Wed London Bridge Available £299.00 £299.00 + VAT
Course Dates Days Location Places RRP Discount You Pay Action
30th May 25 Fri Online Available £299.00 £120.00 £179.00 + VAT
26th Jun 25 Thu Online Available £299.00 £100.00 £199.00 + VAT
23rd Jul 25 Wed Online Available £299.00 £70.00 £229.00 + VAT
22nd Aug 25 Fri Online Available £299.00 £50.00 £249.00 + VAT
19th Sep 25 Fri Online Available £299.00 £20.00 £279.00 + VAT
16th Oct 25 Thu Online Available £299.00 £299.00 + VAT
12th Nov 25 Wed Online Available £299.00 £299.00 + VAT
12th Dec 25 Fri Online Available £299.00 £299.00 + VAT
9th Jan 26 Fri Online Available £299.00 £299.00 + VAT
5th Feb 26 Thu Online Available £299.00 £299.00 + VAT
4th Mar 26 Wed Online Available £299.00 £299.00 + VAT
3rd Apr 26 Fri Online Available £299.00 £299.00 + VAT
1st May 26 Fri Online Available £299.00 £299.00 + VAT
Media Training

Request a quote for Microsoft Excel : Intermediate

All our courses are available as private, bespoke or team training.

You can customise the outline, have a group where it's just your team or enjoy a one to one session with an expert.

We can deliver the course at our centre, live online or at your choice of venue.

Fill in the form below and our team will get in touch with pricing and helpful advice to get the conversation started.

Course Dates

30th May 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount: £120.00

You Pay: £179.00 + VAT
11th Jun 25 (Wed)

Location:London Bridge

Places: Hurry - Two Places Left!

RRP: £299.00

Discount: £100.00

You Pay: £199.00 + VAT
26th Jun 25 (Thu)

Location:Online

Places: Available

RRP: £299.00

Discount: £100.00

You Pay: £199.00 + VAT
8th Jul 25 (Tue)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £70.00

You Pay: £229.00 + VAT
23rd Jul 25 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount: £70.00

You Pay: £229.00 + VAT
5th Aug 25 (Tue)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £50.00

You Pay: £249.00 + VAT
22nd Aug 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount: £50.00

You Pay: £249.00 + VAT
5th Sep 25 (Fri)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £20.00

You Pay: £279.00 + VAT
19th Sep 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount: £20.00

You Pay: £279.00 + VAT
1st Oct 25 (Wed)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
16th Oct 25 (Thu)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
28th Oct 25 (Tue)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
12th Nov 25 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
25th Nov 25 (Tue)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
12th Dec 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
19th Dec 25 (Fri)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
9th Jan 26 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
21st Jan 26 (Wed)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
5th Feb 26 (Thu)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
17th Feb 26 (Tue)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
4th Mar 26 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
17th Mar 26 (Tue)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
3rd Apr 26 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
17th Apr 26 (Fri)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
1st May 26 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
13th May 26 (Wed)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.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

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.

Learn Your Way

Face to Face

Face To Face

Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.

Live Online

Live Online

Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.

Team Training

Team Training

Upskill your team together. Build your team and develop consistency, and collective confidence.

Three Steps To Success

1

Identify Your Path

Define your direction with purpose, aligning your learning journey to personal and career goals.

2

Learn With Experts

Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.

3

Earn Certification

Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.