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 Modules
-
Introduction to Excel for Data Analysis:
• Overview of Excel’s interface and essential tools
• Working with workbooks, worksheets, and structured data -
Essential Functions and Formulas:
• Core formulas: SUM, AVERAGE, COUNT, and more
• Understanding and using absolute vs. relative cell references
• Basic error-checking in formulas -
Importing and Cleaning Data:
• Importing data from external files (CSV, text, databases)
• Removing duplicates and handling missing values
• Preparing raw data for analysis -
LOOKUP Functions:
• Using VLOOKUP and HLOOKUP for referencing data
• Common use cases and troubleshooting LOOKUP errors -
Sorting, Filtering, and Conditional Formatting:
• Organising and sorting datasets
• Applying filters to isolate key data
• Highlighting insights using conditional formatting rules -
Data Visualisation with Charts and Graphs:
• Creating bar, line, and pie charts
• Customising chart elements (titles, labels, legends)
• Choosing the right chart type for your data
