5 November 2026
Thu
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.
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.
| 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 |
| 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
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.
Swipe for more dates
Thu
Wed
Wed
Tue
Mon
Fri
Thu
Fri
Wed
Mon
Tue
Thu
Private & team training
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.
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
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.
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.
Very clear instructions, a lot of excercises to practice the tasks, very detailed course
Good explanation, relevance of subject to my job role, good to go over what we covered last time. Good location for the course.
Clearly explaining and answering questions.
Knowledge base. keeping at a good level for all students while making sure everyone was getting it.
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…
Great Explanations and easy to understand
Talking things through, always asking if we had any questions.
Monica was very good. Very engaging, took her take to explain things , and answered all questions. Would recommend
Swipe for more
Read course reviews
You need a skill for the role you already have, or your employer is investing in the team.
You're moving into a new field and need the practical skills it asks for.
You know the theory. A practical course and a certificate of attendance show employers you can do the work.
Learning Excel is always useful whether you work with data or in finance.
Looking to impress your audience with amazing Powerpoint design presentation skills?
Microsoft Power BI turns raw data into clear, actionable insights.