9th Sep 26
Wed
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 | |
|---|---|---|---|---|---|---|---|
| 9th Sep 26 | Wed | Online | Hurry - One Place Left! | £349.00 | £120.00 | £229.00 + VAT | |
| 30th Sep 26 | Wed | London Islington | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 6th Oct 26 | Tue | Online | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 16th Oct 26 | Fri | Online | Hurry - One Place Left! | £349.00 | £70.00 | £279.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 | ||
| 13th Jan 27 | Wed | 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 | ||
| 30th Jun 27 | Wed | London Islington | Available | £349.00 | £349.00 + VAT | ||
| 26th Jul 27 | Mon | Online | Available | £349.00 | £349.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 30th Sep 26 | Wed | London Islington | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 5th Nov 26 | Thu | London Islington | Available | £349.00 | £349.00 + VAT | ||
| 13th Jan 27 | Wed | 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 | ||
| 30th Jun 27 | Wed | London Islington | Available | £349.00 | £349.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 9th Sep 26 | Wed | Online | Hurry - One Place Left! | £349.00 | £120.00 | £229.00 + VAT | |
| 6th Oct 26 | Tue | Online | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 16th Oct 26 | Fri | Online | Hurry - One Place Left! | £349.00 | £70.00 | £279.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 | ||
| 26th Jul 27 | Mon | Online | Available | £349.00 | £349.00 + 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
Wed
Wed
Tue
Fri
Thu
Wed
Wed
Tue
Mon
Fri
Thu
Fri
Wed
Mon
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.
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
Really good explanations, helpful to those who needed assistance with effective support, great examples to work with that we can practice o…
Hands on help with accraute detailed explanation. Super effective
Relating each aspect to our own careers.
Trainer Lisa was very engaging and demonstrated with exercises various intermediate excel functions, such as, conditional formatting, XLook…
The short cuts were very helpful, as there were so many i did not know and which will be very helpful in the future for me
Swipe for more
Read course reviews
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.
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.