Microsoft Excel - Advanced
This 1-day virtual Excel course is designed for professionals who already have a basic understanding of Excel and want to advance their skills. Learners will gain practical, hands-on experience in managing large datasets, building advanced formulas, creating PivotTables and dashboards, and producing professional reports. The course focuses on real-world business applications to enhance efficiency, decision-making, and data analysis capabilities.
Course Overview
The course starts by reviewing Excel’s interface, workbooks, and basic data organisation. Learners then explore essential and advanced formulas, including SUM, AVERAGE, IF, VLOOKUP, and HLOOKUP, while learning how to troubleshoot common errors. The training covers importing and cleaning external data, sorting, filtering, and applying conditional formatting. Participants will learn to visualise data with charts and graphs, build PivotTables and PivotCharts, and integrate these into dynamic, interactive dashboards. Throughout the course, learners will focus on applying these skills to practical business scenarios, enhancing reporting, analysis, and workflow efficiency.
Learning Objectives
By the end of this course, learners will be able to:
Navigate Excel’s interface and manage workbooks and worksheets efficiently.
Create and troubleshoot advanced formulas using functions such as SUM, IF, VLOOKUP, and HLOOKUP.
Import, clean, and organise data from multiple sources.
Apply sorting, filtering, and conditional formatting to analyse large datasets.
Build PivotTables and PivotCharts to summarise and visualise data effectively.
Design interactive dashboards and professional reports for clear data presentation.
Apply Excel skills to enhance productivity, decision-making, and reporting across various industries.
Who is this course for
This course is ideal for professionals who already have basic Excel skills and regularly work with data in roles such as finance, marketing, operations, administration, or logistics. It is suitable for anyone looking to improve efficiency, reporting accuracy, and data-driven decision-making.
Recommended System Requirements
Further Progression
Learners can continue developing their Excel expertise and business skills by completing courses from our business skills catalogue or AI course catalogue.
Accredited by
Course Cost
£249 +VAT