Modern Data Analytics in Excel

If you haven’t modernized your data cleaning & reporting processes in Microsoft Excel, you’re missing out on big productivity gains. And if you’re looking to conduct rigorous data analysis, more can be done in Excel than you think. This Masterclass serves as an introduction to the “Modern Excel” suite of features, along with other powerful tools for analytics.

First, you’ll learn how to build repeatable data cleaning workflows with Power Query. Next, you’ll build relational data models and dashboards straight from Excel with Power Pivot. Finally, you’ll look at new Excel features like dynamic array functions, artificial intelligence-powered insights, and Python integration to accomplish even more with your data.

‍

What you’ll learn?

• Data profiling with Power Query
• Power Query as Excel's extract, transform, load (ERL) tool
• Data analysis and reporting with Power Pivot
• Building a relational data model in Power Pivot
• Introduction to DAX measures
• Efficient data analysis with dynamic array functions
• Introduction to generative AI in Excel with Analyze Data
• Using Python in Excel to conduct analysis and visualization otherwise difficult in Excel

‍

This Masterclass will be delivered by Microsoft MVP George Mount on 15 & 16 September 2025 as an online-only course.

‍