Microsoft Excel – Intermediate

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.

Course Description

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.

Benefits & Real Life Skills

By taking this course, you will gain practical, real-world Excel skills that improve your productivity, confidence, and professional value — all in just one focused day of training.  Work more efficiently by automating everyday tasks with formulas and functions  Import, clean, and prepare data from external sources for accurate analysis  Use VLOOKUP and HLOOKUP to connect and reference data without manual effort  Create visually clear and professional charts to present your data with impact  Apply filters, sorting, and conditional formatting to uncover insights quickly  Troubleshoot and fix common formula errors like a pro  Save time with smart spreadsheet structuring and formula techniques  Build reports and dashboards that others can understand, use, and trust  Improve decision-making by analysing data confidently and clearly.

Topics Covered

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