top of page

MC03: Excel Masterclass

Our Excel Masterclass is a hands-on workshop designed to transform how you use Excel for data analysis and reporting. Covering everything from advanced formulas to dynamic dashboards, this session will equip you with the skills to automate workflows, uncover insights, and present data effectively.

Advanced Formulas and Function

  • Master key formulas, including INDEX-MATCH, XLOOKUP, and nested IF statements.
  • Use logical, text, and lookup functions to clean and organise data.
  • Hands-on exercises: Automating calculations and solving common business problems.

Data Cleaning and Transformation

  • Use advanced tools like Power Query to clean and reshape messy datasets. ​
  • Eliminate duplicates, handle errors, and apply transformations at scale.
  • Practice session: Preparing raw data for analysis.

Data Visualisation and Charting

  • Learn best practices for creating clear, impactful charts.

  • Learn to choose charts with business context and justifications.

  • Build a dashboard: Create a visually engaging, interactive report

Next

Pivot Tables and Data Analysis

  • Master PivotTables and PivotCharts for summarising large datasets.

  • Use calculated fields and slicers for dynamic reporting.

  • Real-world application: Analysing sales or operational data.

Real-World Application Project

  • Apply all concepts to create a linked, automated multi-sheet workbook.

  • Receive instructor feedback and best-practice guidance for refining your Excel workflow.

Get In Touch

Thanks for submitting!

Email Us:
info@datatrainingacademy.co.uk

bottom of page