Using Power Query, Power Pivot, and More for Enhanced Data Analytics
If you’re still manually cleaning spreadsheets or spending hours fixing broken formulas, it’s time to leave outdated workflows behind. Modern Excel is more than rows and columns. It’s a powerful set of tools that can automate, analyze, and transform your data work for good.
Advancing with Modern Excel by George Mount of Stringfest Analytics is your practical guide to unlocking the full potential of today’s Excel. Designed for analysts, business professionals, and anyone who wants to do more with data, this book helps you build workflows that are clean, repeatable, and scalable.
You’ll learn how to automate time-consuming tasks with Power Query, build relational models with Power Pivot, and replace clunky formulas with dynamic arrays. If you’re curious about Excel’s AI features or how to integrate Python, this book gives you both the how and the why, without the jargon.
What You’ll Learn:
- Build reliable, automated data cleaning processes using Power Query
- Create powerful data models and custom measures with Power Pivot
- Use dynamic arrays to simplify lookups and extract data in smarter ways
- Identify patterns and trends using Excel’s built-in AI insights
- Combine Excel and Python to level up your analytics using code
Whether you’re buried in dashboards or trying to stop fighting with VLOOKUP, this book shows you how to make Excel work harder, so you don’t have to.
Who It’s For:
- Business analysts ready to modernize their workflows
- Self-taught Excel users looking for next-level skills
- Data professionals curious about how Excel fits into today’s analytics landscape
Modern Excel is no longer just about spreadsheets. It is a full-featured analytics engine, and this book shows you how to use it with confidence and clarity.