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. This is available as a single course or as part of our Premium Online Global Excel Summit ticket.
Who is it for?
This Masterclass is perfect for professionals who want to make the most of their data using next-generation features. Typical job titles who could particularly benefit include:
- Data analysts
- Financial analysts
- Marketing coordinators
- Accountants
- Controllers
- Operations analysts
Download Event Brochure
What's included?
-min.png)
-min.png)
✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data
✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
✔︎ What is Power Query?
✔︎ Basic data loading
✔︎ Power Query editor overview
✔︎ Type of values
✔︎ Exploring queries and steps
✔︎ Basic data cleaning and transformation (removing columns & rows, filtering data, sorting, etc.)
✔︎ Practical example
✔︎ Removing duplicates and handling nulls
✔︎ Text transformation
✔︎ Date and time values
✔︎ Query load
✔︎ Practical example
✔︎ Data aggregation
✔︎ Merging and appending queries basics
✔︎ Different options for adding columns
✔︎ Pivoting and unpivoting data
✔︎ Practical example
✔︎ Key takeaways
✔︎ Addressing frequently asked questions
✔︎ Interactive Q&A session
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Training requirements
Participants should be familiar with intermediate Excel topics such as PivotTables or lookup functions such as VLOOKUP() or XLOOKUP().
There is no coding experience required to attend this course.
About the trainer
George Mount
George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specialising in analytics education and upskilling. He has worked with leading bootcamps, learning platforms and practice organisations to help individuals excel at analytics. George regularly blogs and speaks on data analysis, data education and workforce development and is the author of Advancing into Analytics: From Excel to Python and R (O'Reilly Media, 2021).
What people think of
George Mount
★★★★★
★★★★★
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
Check out the introductory keynotes from Microsoft and world-renowned MVP Leila Gharani. Software developers showcase add-ins that transcend Excel's limitations, plus robust panel discussions and expert insights complete the Tech & Innovation Track!
✔︎ Keynote by Microsoft: Transforming Excel through research and AI
✔︎ Keynote by Leila Gharani
✔︎ Actionable Data Storytelling in Excel with Zebra AI
✔︎ AI: Sorting fact from fiction
✔︎ Python in Excel: First Steps
✔︎ Teaching Excel with AI
✔︎ Is AI taking over the role of the data analyst?
✔︎ How to build re-usable Excel automations with AI
✔︎ Empowering learners to Excel with digital skills certifications
✔︎ Kids meet spreadsheets
✔︎ Corporate charts inspired by social media
✔︎ ChatGPT: Match Made in Heaven or Hell..?
✔ Turn Excel models into Web apps: features, sharing, monetization
✔ Panel discussion: The future of Excel in an AI world
✔ Panel discussion: Does being Excel-certified matter?
Harness the power of Excel and Power BI for budgeting, forecasting, and modelling. You'll master dashboards, P&L statements, and learn to build bullet-proof models that won't disintegrate!
✔ Client's perspectives on quality — lessons from a career in financial modelling and what that means for the future
✔ Dynamic Arrays - A financial modelling game changer
✔Upgrading financial modelling — how, who, and why?
✔ Fivecasting: One Better than Forecasting
✔ A bank’s perspective on Excel and AI
Showcase your data with insightful visuals and learn the secrets of presenting it for effective communication. You'll also create custom charts, intuitive analytic experiences, and write DAX expressions for true flexibility!
✔ Is this an Excel chart?!? - 5 ways to take your boring charts to the NEXT Level
✔ Interactive Data Visualisation for decision support using Excel
✔ How to create an intuitive analytic experience in Excel using Script Labs
✔ Dynamic dashboard creation for KPI reporting using Power BI
Expand your understanding of Power Query, Power Pivot, Power BI, and Power Automate. You'll arm yourself with the latest time-saving functionalities, powerful visualisations & expert techniques.
✔ Why use Power Query to solve practical data cleaning problems?
✔ 5 Things every Excel user should know about Power BI
✔ Using Git in Power BI for effective teamwork and version control
✔ Overcoming real-world problems with Power BI
✔ Power Query on Excel for Mac
Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!
✔ Optimising the Monetisation of Spreadsheets
✔ LAMBDA - There is no stopping you
✔The *NEVER SEEN* Tips & Tricks by Bob Umlas
✔ Converting spreadsheets into web apps; 3 apps in fifteen minutes
✔ 5 ways for analysts to leverage 'Analyze Data’ in Excel
✔Combine Data in Excel Like A Pro
✔ Why VLOOKUP when there is Power Query?
Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!
✔ Excel Analytics 2.0 with George Mount
✔ Designing and Building Interactive Dashboards in Excel with Ann K. Emery
✔ Advanced Data Cleaning Using M in Power Query with Chandeep Chhabra
Get Product
-min.png){kind=logo}
2026 Blind Tickets almost sold out!
In-person Blind tickets for the upcoming Global Excel Summit 2026 conference are now sold out. Only a few more ONLINE ones remaining! Secure 40% OFF discount today.