About the Course
Whether you’re working in finance, marketing, operations, or administration, Excel is a critical tool that can unlock powerful insights and streamline your workflow. This course is built for professionals who already know the basics and are ready to dig deeper into data analysis, automation, and professional-level reporting. You’ll go beyond formulas and charts—learning how to build dashboards, automate calculations, and work confidently with large, complex datasets. The training is highly practical, hands-on, and focused on real business scenarios, so you can apply your new skills immediately.
What does the Microsoft Excel - Advanced online course cover?
Join our 1-day virtual Excel class and take your spreadsheet skills to the next level with expert-led training designed for real-world data challenges.
Key Benefits
Master Excel’s Interface and Navigation: Understand how to confidently navigate Excel’s ribbons, menus, and core features to improve your workflow and efficiency from the very first click.
Create and Troubleshoot Advanced Formulas: Learn how to build accurate formulas using essential functions like SUM, IF, VLOOKUP, and HLOOKUP, and understand how to fix common formula errors with ease.
Import and Clean External Data: Gain the ability to bring data in from external sources and clean it effectively by removing duplicates, handling blanks, and preparing it for analysis.
Organise and Analyse Large Datasets: Use tools like sorting, filtering, and conditional formatting to manage large volumes of data and uncover the most relevant insights quickly.
Use Cell References for Dynamic Formulas: Understand the difference between absolute and relative cell references to build flexible, reusable formulas across spreadsheets.
Build and Customise PivotTables & PivotCharts: Create powerful PivotTables to summarise data and visualise trends with PivotCharts. Explore grouping, slicers, and calculated fields for deeper analysis.
Design Interactive Dashboards: Learn how to combine charts, slicers, and PivotTables into dynamic dashboards that are both visually appealing and easy to use.
Present Data with Clear Visualisations: Choose the right charts (bar, line, pie, etc.) for your data, customise their elements, and present insights that make an impact.
Course Modules
Introduction to Excel for Data Analysis
Basic Excel Functions and Formulas
Data Import, LOOKUP, and Cleaning
Sorting, Formatting, and Filtering Data
Data Visualisation with Charts and Graphs
PivotTables and PivotCharts
Dashboard Building and Design
Required percentage to pass the course