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.
Using more advanced formulas
Working with conditional formatting
Efficient worksheet management
Improved data analysis
Streamlined data organisationYou'll need to have attended our Excel Intro course or have equivalent working knowledge before joining this class.
Course leader is an experienced industry expert
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 5th Aug 25 | Tue | London Bridge | Available | £299.00 | £120.00 | £179.00 + VAT | |
| 5th Sep 25 | Fri | London Bridge | Available | £299.00 | £100.00 | £199.00 + VAT | |
| 1st Oct 25 | Wed | London Bridge | Available | £299.00 | £70.00 | £229.00 + VAT | |
| 28th Oct 25 | Tue | London Bridge | Available | £299.00 | £50.00 | £249.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 | ||
| 9th Jun 26 | Tue | London Bridge | Available | £299.00 | £299.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 25 | Thu | Online | Available | £299.00 | £150.00 | £149.00 + VAT | |
| 23rd Jul 25 | Wed | Online | Available | £299.00 | £120.00 | £179.00 + VAT | |
| 22nd Aug 25 | Fri | Online | Available | £299.00 | £100.00 | £199.00 + VAT | |
| 19th Sep 25 | Fri | Online | Available | £299.00 | £70.00 | £229.00 + VAT | |
| 16th Oct 25 | Thu | Online | Available | £299.00 | £50.00 | £249.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 | ||
| 28th May 26 | Thu | Online | Available | £299.00 | £299.00 + VAT |
Statistical functions (Average, Max, Min, Count and Counta)
Using relative & absolute addressing
Creating, using and editing range names
Locking cells and worksheets
Grouping worksheets
Setting tab colour
Performing calculations across sheets
Using SUMIFS & COUNTIFS
The basic IF function
Simple VLOOKUP
Apply Conditional Formatting rules
Use the Conditional Formatting rules manager
Create Conditional Formatting using a formula
Clearing rules
Freezing panes
Filtering data
Using the subtotal tool
Formatting as a table
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Upskill your team together. Build your team and develop consistency, and collective confidence.
Define your direction with purpose, aligning your learning journey to personal and career goals.
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
From £599 + VAT
From £179 + VAT
From £179 + VAT
