Microsoft Excel Intermediate Course
Got the basics? Take your Excel skills to the next level – smarter formulas, faster data, professional results.
5 Star Rated
In-House Training
Public Courses
1 Day Course
Public course places from £250 per person. In-house team training from £1,000 remote or £1,200 per day for your group.
See detailed pricing information below
Trusted By Teams Across the UK
In the private and public sectors, from SMEs to publicly-listed companies, I've delivered training across a wide range of organisation sizes and sectors.
Which Is The Best Excel Course For Me?
If you're already comfortable with the basics of Excel, my Intermediate course might be perfect for you. It builds on your existing knowledge of essential formulas and functions.
To find the best Excel course for you, take my quick 2-minute Excel quiz or just ask me and I'll point you to the right level.
Looking for Excel training your team? Get in touch about in-house Excel training and I can help assess the training needs for your organisation.
Work Smarter with Excel’s Most Useful Tools
Once you’ve mastered the essentials, the next step is learning the Excel tools and functions that make your work faster, more accurate and more professional.
If you've picked Excel up as you've gone along - confident with the basics but never quite sure you're doing things the right way - this is the course that fills the gaps and shows you the faster, cleaner methods the pros use.
My Excel Intermediate Course helps you move beyond simple spreadsheets and start working smarter, faster, and more confidently.
Rather than memorising steps, you’ll learn how Excel thinks, so you can apply your skills to real-world tasks, no matter what your role involves.
In just one day, you’ll discover how to:
-
Use logical functions such as IF to build smarter worksheets.
-
Use conditional formatting and data validation to improve accuracy.
-
Use essential lookup functions such as VLOOKUP and XLOOKUP.
-
Manage and analyse large datasets quickly and accurately.
-
Calculate dates and time in Excel with ease.
-
Create professional charts and dashboards to bring your data to life.
-
Control what data other people can add into your worksheet.
-
Save time and eliminate errors with built-in Excel tools.
You also receive 3 months of personal email support from me for any follow-up questions.
This hands-on course bridges the gap between the Beginner and Advanced courses, giving you the practical tools and confidence to handle real-world Excel challenges. View all Excel courses.
Whether you’re working with reports, budgets, or any other data, you’ll learn techniques to transform the way you use Excel every day.
Why Intermediate Excel Training Matters
Bringing a team up from basic to confident? In-house intermediate Excel training gets everyone working to the same higher standard.
This course is often paired as a perfect follow-up to my beginner training. Once you've got everyone doing the basics well, then you really take their skills to the next level with intermediate Excel.
In-house training is delivered at your workplace or live online, tailored to your team's real work.
Mixed abilities? My free Team Skills Audit helps you see who needs Beginner and who's ready for Intermediate. Get in touch and I can work with you to assess the Excel training needs of your team.
Want Some Extra Tips?
Grab my free Excel Productivity Toolkit to discover features which most people don't know about to save time and make your work easier.
Excel Intermediate Course Content
My Excel courses are very hands-on and practical. You will be using Excel throughout the day to practice everything we cover.
For in-house training the course can be tailored to your specific requirements.
Please Contact Me to discuss in-person or remote training for your team.
Every participant receives:
-
A detailed course workbook with step-by-step explanations for all topics.
-
Hands-on examples for everything to make learning practical and engaging.
-
Post-course exercises to help you keep practising what you’ve learned.
-
Certificate of Completion after the course.
-
Post-course email support - you can email me with questions for 3 months after the course, answered personally.
Statistical Functions and Analysis Tools
Next, we'll explore how Excel can crunch numbers efficiently to reveal trends and insights. This family of functions will help you make better business decisions and analyse data more effectively. ✔ Calculate averages with MEAN, MEDIAN, and the new MODE.SNGL and MODE.MULT. ✔ Round numbers precisely with ROUND, ROUNDUP, and ROUNDDOWN. ✔ Use MROUND, CEILING.MATH, and FLOOR.MATH for advanced custom rounding. ✔ Rank data dynamically with RANK.EQ and RANK.AVG. ✔ Identify top and bottom results with LARGE and SMALL and combine with other functions such as SUM for unique effects. ✔ Summarise filtered lists efficiently using SUBTOTAL.
Excel Logic Fundamentals
Learn how to make Excel think for you. Logical functions allow your spreadsheets to make decisions automatically based on the data they contain - such as entering data or carrying out actions based on the contents of a cell. It's where Excel truly becomes powerful. ✔ Understanding and applying IF statements to speed up tasks, enter data and reduce errors ✔ Creating IF formulas to automate decision-making ✔ Combining IF with comparison operators (greater than, less than, equals) for even more options ✔ Build smarter conditional logic to automate reporting.
Linking and Managing Data in Excel
As your workbooks grow, managing data across multiple sheets becomes essential. This module shows you how to link, group, and summarise data to create easy-to-read reports without the endless copying and pasting or scrolling back and forth. ✔ Link data across worksheets and workbooks for dynamic summaries. ✔ Create formulas which use data from different worksheets. ✔ Use Subtotals and data Grouping for clear summaries. ✔ Keep multi-sheet reports consistent and dynamic.
Excel Lookups and Search Functions
Learn to pull information from different sheets or tables automatically. We cover VLOOKUP initially as you will come across it in existing workbooks, but we then focus on the newer and much better XLOOKUP function which is superior in pretty much every way. Once you master lookups, you’ll never need to manually cross-check data again. ✔ Perform classic lookups with VLOOKUP. ✔ Harness the power of the new XLOOKUP for flexible data retrieval. ✔ Perform exact and approximate matches depending on your data type. ✔ Return multiple columns with one XLOOKUP formula. ✔ Create useful custom error messages with XLOOKUP to gracefully handle problems.
Conditional Formatting and Data Visualisation
Transform dull spreadsheets into visual stories with automated formatting. Conditional formatting highlights important information instantly so patterns and outliers stand out. No more colouring in cells manually all the time. ✔ Review cell styles and formatting options. ✔ Apply highlight cell rules and top/bottom comparisons. ✔ Add data bars, colour scales, and icon sets for at-a-glance insights. ✔ Customise your conditional formatting to create informative worksheets.
Working with Date and Time Functions
Dates are central to business and project planning and are used in financial reporting, but they often cause frustration in Excel. You’ll learn how to manage them with ease and use formulas to calculate timeframes automatically. ✔ Perform date arithmetic to calculate schedules and durations. ✔ Use EDATE and EOMONTH for effortless reporting. ✔ Extract details using DAY, MONTH, YEAR, and TEXT. ✔ Work out deadlines and plan work with WORKDAY and NETWORKDAYS.
Auditing and Troubleshooting Spreadsheets
Every great Excel user needs to know how to find and fix issues - especially when you are using someone else's worksheet. These tools help you understand how your formulas work and keep your data accurate and understand how everything works. ✔ Trace precedents and dependents to understand formula flow. ✔ Display formulas to review calculations. ✔ Use Excel’s Evaluate Formula and Error Checking tools.
Collaboration and Data Control
We complete the Intermediate Excel course by learning how to make your spreadsheets team-friendly and secure. Control who can edit what, validate data entries, and leave feedback for others. ✔ Add and manage comments and notes for collaboration inside your Excel file. ✔ Restrict input with data validation. ✔ Create custom input and error messages to help others add data correctly. ✔ Create drop-down lists for quick and easy data entry. ✔ Protect worksheets and workbooks to maintain accuracy and security. ✔ Advice on setting passwords on Excel files - and its very important security limitations.
Meet Your Trainer
Mark Baglow
Hi, I'm Mark. When you book this course, you get me – not an associate, not a script read off a slide.
I use Excel every day to run my business and when I deliver training. I've seen how Excel is used in the real world by hundreds of people in many different industries. My training is based on what's actually useful in your work - not just theory.
I've spent fifteen years in the world of education, training and development. During my career I learned the thing that still shapes every course I run: people don't remember what you tell them, they remember what they do.
My training is practical, hands-on and refreshingly jargon-free – real tools you'll use on Monday morning, not dry theory you'll have forgotten by lunch.
I'm a certified DISC analyst, and I've designed and delivered leadership, management and communication training across sectors including education, software and financial services.
I'm based in Birmingham – right in the middle of the country – so I can reach you easily for in-person training anywhere in the UK, or even internationally! I also provide live online training if that suits you better.
I keep my business deliberately personal: you deal with me directly, from first enquiry to post-course follow-up, and every session is built around your people and your real-world challenges.
Pricing & Learning Options
Live Online Public Course
Live interactive online training with Mark Baglow via Microsoft Teams.
Small groups with a maximum of 8 participants.
Detailed course notes and resources included.
Questions and comments are welcomed at any time.
3 months of email support for follow-up questions.
£250
per person
Best suited for individuals or if you have 1 - 3 participants
In-House Group Course Live Online
Private group training with Mark Baglow for your organisation live online via Teams.
Tailored to your requirements.
Detailed course notes and resources included.
Recommended group size of up to 10 participants.
Pricing is a day rate for the group - not per person
from £1,000
per day
Works out at £100 per person for a group of 10
In-House Group Course In-Person
Private group training with Mark Baglow in-person at your workplace.
Tailored to your requirements.
Detailed printed course notes and resources included.
Recommended group size up to 12 participants.
Pricing is a day rate for the group - not per person
from £1,200
per day
Works out at £100 per person for a group of 12
Best Value for Teams
Half-day courses for in-house training are available on request.
Your satisfaction, guaranteed. I'm confident you'll find this genuinely valuable. If you attend a public course and don't feel it was worth your time, I'll refund your place. For in-house training, if it doesn't deliver what we agreed, I'll put it right.
The final cost of in-house training depends on delivery format, location (including London), group size and any specialist tailoring; travel and accommodation may apply for in-person sessions. No VAT is currently charged.
How In-House Training Works
Bringing training in-house for your team - whether in-person or online - is simpler than you might think.
Here's the whole journey:
Get in touch: Tell me a bit about your team and what you'd like to achieve.
Fill in the form or book a free 30-minute call.
Free scoping call: We talk through your goals, your team and any specific challenges. No charge, no obligation.
Tailored proposal: I send a clear proposal with tailored content and a price. Tailoring and prep are included as standard - no hidden extras. No VAT is currently charged on top of my prices.
Delivery: I deliver the session at your site or live online, fully tailored to your organisation.
Follow-up: Everyone leaves with a workbook and post-course resources to embed what they've learned.
Want to Learn More?
No VAT currently charged · Free discovery call · Tailoring & prep included
Public Course Dates
Book instantly onto one of my regular public courses below. My online Excel courses are delivered as live instructor-led training via Microsoft Teams at £250 per person.
Looking for Microsoft Excel Intermediate in-person or remote training for your team?
Public courses suit individuals or 1–3 people. For 4+, in-house is more cost-effective per person and I'll tailor it to the way your team uses Excel: your own spreadsheets, reports and workflows.
Please contact me to discuss in-house training options.
- Excel Intermediate - 18/08/2618 Aug 2026, 09:30 – 16:30 BSTLive Online Training
- Excel Intermediate - 20/10/2620 Oct 2026, 09:30 – 16:30 BSTLive Online Training
- Excel Intermediate - 07/12/2607 Dec 2026, 09:30 – 16:30 GMTLive Online Training
In-Person Excel Training for Teams Across the UK
Looking to train a team in Excel, or after a intermediate course near you?
Two options:
Join one of my live online public courses from anywhere in the UK or internationally - no travel needed, and ideal if you're sending one or two people.
Or, for teams, I deliver in-house beginner Excel training either in person at your workplace or live online via Teams.
Just as interactive and hands-on either way, and perfect for remote or spread-out teams.
In-house content is tailored to the spreadsheets your team actually uses, and works out at excellent value per person.
I'm Birmingham-based and travel nationwide. Get in touch for a tailored quote.
Who Is This Excel Intermediate Course For?
My Excel Intermediate training is perfect for anyone who already knows the basics of Excel and wants to move to the next level.
In order to get the most out of this training, you should be comfortable with the topics cover in my Excel Beginner Course.
If you can navigate around a workbook and create simple formulas, but want to boost your efficiency, accuracy, and confidence, this is the ideal next step.
By the end of my Intermediate Excel course, you’ll feel confident handling larger datasets, using more powerful formulas, and creating polished, professional-looking workbooks that you’ll actually enjoy using.
It’s especially valuable for:
-
Professionals in any industry - who want to take their Excel skills from beginner to intermediate level.
-
Office and Admin Professionals – who work with data daily and want to make their spreadsheets faster and more reliable.
-
Supervisors, Team Leaders, and Managers – who need to analyse information, produce reports, and make data-driven decisions.
-
Finance and HR Staff – who handle figures, reports, and datasets that need consistency and accuracy.
-
Students and job-seekers - a good level of Excel knowledge is an incredibly valuable tool in all industries.
-
Anyone self-taught in Excel – who has picked up the basics but wants to fill in the gaps and learn smarter, quicker ways to work.
Not sure which level of Excel training is right for you?
Take my 2-minute Excel quiz to find out or get in touch.
Why Choose Mark Baglow Training
Frequently Asked Questions
For more general questions about booking, pricing, delivery and more, please visit the main FAQ Page
Helpful Excel Articles
If Intermediate seems like a big jump, start with this course to learn the essentials first. Perfect for new users or those without formal training.
Become a power user with advanced logic and lookups, dynamic array functions, Pivot Tables, Power Query, data cleaning and auditing.
Boost your personal and team productivity with Claude, Copilot or ChatGPT. Write effective prompts, use advanced features and more.
I also deliver training in other Microsoft Office apps, Leadership, Personal Effectiveness, Project Management, and more.
If you’re ready to save time, speed up your work, and unlock Excel’s real potential, I'd love to help.
My Intermediate Excel Course is available as a public online session or as a private in-house course for your team.
Tailoring and prep is included in your custom quote. No obligation and no VAT is currently charged.
I also have Beginner and Advanced Excel courses available to cater to all abilities. View all Excel courses.
Just fill in the form to get the conversation started.
You can also book a free 30 minute no-obligation consultation call here
