Microsoft Excel Intermediate 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.
Key Learning Points
Key Learning Points
- Write more advanced formulas with confidence
- Apply conditional formatting to highlight data
- Manage multiple worksheets efficiently
- Use VLOOKUP, SUMIFS and IF to interrogate data
- Organise large data sets without losing control
If attending an online course you must have a licensed copy of any software required and access to a suitable computer.
You'll need to have attended our Excel Intro course or have equivalent working knowledge before joining this class.
Who is this course for?
For Excel users who know the basics and want to develop more confidence with formulas, functions and data analysis. Requires our Excel Introduction course or equivalent working knowledge.
Expert Trainers
Course leader is an experienced industry expert
Course Dates
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 26 | Fri | London Islington | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 24th Jul 26 | Fri | Online | SOLD OUT | £349.00 | £349.00 + VAT | ||
| 21st Aug 26 | Fri | London Islington | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 9th Sep 26 | Wed | Online | Available | £349.00 | £50.00 | £299.00 + VAT | |
| 30th Sep 26 | Wed | London Islington | Available | £349.00 | £20.00 | £329.00 + VAT | |
| 16th Oct 26 | Fri | Online | Available | £349.00 | £349.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 | ||
| 22nd Jan 27 | Fri | 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 |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 26 | Fri | London Islington | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 21st Aug 26 | Fri | London Islington | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 30th Sep 26 | Wed | London Islington | Available | £349.00 | £20.00 | £329.00 + VAT | |
| 5th Nov 26 | Thu | London Islington | Available | £349.00 | £349.00 + VAT | ||
| 22nd Jan 27 | Fri | 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 |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 24th Jul 26 | Fri | Online | SOLD OUT | £349.00 | £349.00 + VAT | ||
| 9th Sep 26 | Wed | Online | Available | £349.00 | £50.00 | £299.00 + VAT | |
| 16th Oct 26 | Fri | Online | Available | £349.00 | £349.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 |
Course Dates
26th Jun 26 (Fri)
24th Jul 26 (Fri)
21st Aug 26 (Fri)
9th Sep 26 (Wed)
30th Sep 26 (Wed)
16th Oct 26 (Fri)
5th Nov 26 (Thu)
2nd Dec 26 (Wed)
22nd Jan 27 (Fri)
9th Feb 27 (Tue)
8th Mar 27 (Mon)
9th Apr 27 (Fri)
6th May 27 (Thu)
4th Jun 27 (Fri)
Course Outline
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
Working with worksheets
Grouping worksheets
Setting tab colour
Performing calculations across sheets
Taking formulas to the next level
Using SUMIFS & COUNTIFS
The basic IF function
Simple VLOOKUP
Highlight data with formatting
Apply Conditional Formatting rules
Use the Conditional Formatting rules manager
Create Conditional Formatting using a formula
Clearing rules
Working with lists
Freezing panes
Filtering data
Using the subtotal tool
Formatting as a table
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.
Career paths
Roles this course supports
People training on Microsoft Excel Intermediate often work in the careers below.
Who attends?
Career Progressives
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
Career Changers
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
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
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Live Online
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Team Training
Upskill your team together. Build your team and develop consistency, and collective confidence.
Three Steps To Success
Identify Your Path
Define your direction with purpose, aligning your learning journey to personal and career goals.
Learn With Experts
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Earn Certification
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
Further Reading
8 Tips To Make You An Excel Expert
Learning Excel is always useful whether you work with data or in finance. Here are 8 tips to help you master…
Why You Should Learn Microsoft Power BI?
Microsoft Power BI turns raw data into clear, actionable insights. Find out what it can do, how businesses use it and…
How Learning Power BI can help your Career
Power BI is one of the most in-demand data skills in business. Find out what it can do, who uses it and how learning…