Microsoft Excel - Intermediate
Microsoft Excel is one of the most in-demand skills across industries — from finance and marketing to logistics and research. But if you’re only using it for simple spreadsheets, you’re missing out on its full potential.
This Intermediate Microsoft Excel course is a live, 1-day virtual training session designed to bridge the gap between basic Excel use and powerful, real-world application. You’ll move beyond data entry and dive into the tools that unlock true efficiency, clarity, and analytical impact.
Whether you’re managing reports, working with large datasets, or simply looking to become faster and smarter in your day-to-day tasks, this hands-on session will guide you through the formulas, functions, and features that professionals use every day. Delivered online and led by an experienced instructor, this practical workshop combines expert guidance with real-time exercises — giving you the skills and confidence to work smarter with data right away.
Course Overview
Key Benefits
Master Excel’s Interface and Data Structure - Understand how to confidently navigate Excel, manage workbooks and worksheets, and organise your data for effective analysis.
Build Reliable Formulas and Functions Learn to create essential formulas using functions like SUM, AVERAGE, and COUNT, and understand how to apply absolute and relative cell references correctly.
Import and Integrate External Data Bring data into Excel from various sources and start working with it right away — a key skill for business, research, and reporting tasks.
Use LOOKUP Functions with Confidence Gain hands-on experience with VLOOKUP and HLOOKUP to search, reference, and connect information across tables and sheets.
Clean and Prepare Data for Analysis Learn practical techniques to clean your data — remove duplicates, fill missing values, and format datasets for accurate results.
Sort, Filter, and Format for Insight Use Excel’s sorting, filtering, and conditional formatting tools to isolate patterns, highlight key metrics, and make your data easier to interpret.
Visualise Data with Impactful Charts Create and customise bar, line, and pie charts. Learn how to choose the right chart type to tell a clear, compelling data story.
Learning Objectives
By the end of this course, learners will be able to:
Confidently navigate Excel’s interface, manage workbooks and worksheets, and organise data effectively.
Build reliable formulas using functions such as SUM, AVERAGE, and COUNT, applying absolute and relative cell references correctly.
Import and integrate data from external sources for analysis and reporting.
Use lookup functions (VLOOKUP and HLOOKUP) to search, reference, and connect information across tables and sheets.
Clean and prepare data for analysis by removing duplicates, filling missing values, and formatting datasets accurately.
Sort, filter, and apply conditional formatting to highlight key metrics and trends.
Create and customise charts, including bar, line, and pie charts, to visualise data effectively.
Apply practical Excel skills to manage large datasets, generate insights, and improve day-to-day efficiency in the workplace.
Who is this course for
This course is ideal for professionals who use Excel regularly and want to advance their data analysis skills, small business owners seeking to streamline reporting, and students or recent graduates looking to boost their CVs with practical Excel knowledge. It’s also a great fit for job seekerspreparing for roles in finance, administration, marketing, or data entry. If you already know the basics of Excel and are ready to take the next step, this intermediate course is designed for you.
Recommended System Requirements
Further Progression
Learners can progress their skills by completing the Microsoft Excel - Advanced
Accredited by
Course Cost
£199 +VAT