Work Smarter with Excel’s Most Useful Tools
Once you’ve mastered the basics of Excel, the next step is learning the tools and functions that make your work faster, more accurate and more professional.
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.
-
Manage and analyse large datasets quickly and accurately.
-
Create professional charts and dashboards to bring your data to life.
-
Save time and eliminate errors with built-in Excel tools.
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.
Excel Intermediate Course Content
For in-house training the course can be tailored to your specific requirements
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.
Formulas Fundamentals
Start your Excel Intermediate training by understanding how Excel formulas really work.
You’ll recap key basics and then learn how to write more flexible, dynamic formulas that can handle a wide range of data.
-
Quick recap of key beginner formulas.
-
How Excel functions work and what arguments mean.
-
Understanding absolute and mixed references for reliable formulas.
Statistical Functions and Analysis Tools
Next, we'll explore how Excel can crunch numbers efficiently to reveal trends and insights.
These statistical tools will help you make better business decisions and analyse data more effectively.
-
Calculate averages with MEAN, MEDIAN, and MODE.
-
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.
-
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.
-
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
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.
-
Link data across worksheets and workbooks.
-
Use Subtotals and data Grouping for clear summaries.
-
Keep multi-sheet reports consistent and dynamic.
Lookups and Search Functions
Learn to pull information from different sheets or tables automatically.
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.
-
Handle missing data gracefully using error options.
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.
-
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.
Working with Date and Time Functions
Dates are central to business and project planning.
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 financial reporting.
-
Extract details using DAY, MONTH, YEAR, and TEXT.
-
Work out deadlines with WORKDAY and NETWORKDAYS.
Auditing and Troubleshooting Spreadsheets
Every great Excel user needs to know how to find and fix issues.
These tools help you understand how your formulas work and keep your data accurate.
-
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 drop-down lists for quick and easy data entry.
-
Protect worksheets and workbooks to maintain accuracy and security.
Course Delivery
In-House Training
Private in-house courses are available by contacting me. Delivered in-person at your site or another location of your choice. Training can also take place online via Teams.
In-house sessions allow me to tailor the content to your organisation’s specific goals, culture, and challenges.
Public Courses
Regular public courses available to everyone. Live, online training classes delivered via Microsoft Teams.
Perfect for individuals or a small number of attendees. Interactive and engaging to give you the classroom experience while building your skills and confidence.
Public Course Dates
Book instantly onto one of my regular public courses below. My online Excel training courses are delivered as live instructor-led training via Microsoft Teams.
Looking for Microsoft Excel in-person or remote training for your team?
Please contact me to discuss my in-house training options.
- Excel Intermediate - 21/01/2621 Jan 2026, 09:30 – 16:30 GMTLive Online Training
- Excel Intermediate - 10/03/2610 Mar 2026, 09:30 – 16:30 GMTLive Online Training
- Excel Intermediate - 15/04/2615 Apr 2026, 09:30 – 16:30 BSTLive Online Training
- Excel Intermediate - 10/06/2610 Jun 2026, 09:30 – 16:30 BSTLive Online Training
- Excel Advanced - 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
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 our Excel Intermediate class, 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?
Don't worry - just get in touch and I'll be more than happy to advise.
Why Choose Mark Baglow Training
For more general questions about booking, pricing, delivery and more, please visit the main FAQ Page
If you are brand new to Excel, or have some experience but have never been trained, this course is the perfect place to start.
Become a power user with advanced logic and lookups, dynamic array functions, Pivot Tables, Power Query, data cleaning and auditing.
Learn the latest AI tools to increase your productivity and grow your skills with ChatGPT and Microsoft Copilot courses.
Improve your skills in other Microsoft Office applications - including Power BI, Word, PowerPoint, Outlook 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.
Join one of my Intermediate Excel online courses or contact me to discuss tailored in-house options.
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
