A beginners guide to mastering the art of Data Metamorphosis to Get Just the Data Structure Needed to Create Insightful Data Analysis Solutions
by Mike “excelisfun” Girvin
Unlock the True Power of Your Data with Power Query and M Code
Are you ready to master the data-shaping language at the heart of Excel and Power BI? In The Transformative Magic of M Code in Power Query and Power BI, award-winning author and Excel MVP Mike Girvin demystifies the deceptively simple, yet incredibly powerful M language—giving beginners a clear path to transforming messy, inconsistent data into clean, structured datasets ready for analysis.
Whether you’re a business analyst, accountant, Excel enthusiast, or Power BI pro, this book walks you through step-by-step how to unleash the full potential of Power Query. From learning the basics of M syntax and values, to building custom functions, performing advanced data transformations, and modeling real-world projects—Mike’s signature teaching style makes it easy to follow along, have fun, and truly get it.
Inside, you’ll discover:
A beginner-friendly guide to mastering M Code in Excel, Power BI Desktop, and Dataflows
How to unpivot, join, append, group, and shape data with ease
Ways to write lookup formulas, use recursion, and create reusable custom functions
Real-world projects to consolidate files, fix bad data structures, and build dynamic solutions
A bonus walkthrough on dynamically connecting to SharePoint file systems
With clear examples, downloadable files, and Mike’s decades of teaching expertise, this book will transform how you think about data—and what’s possible with Power Query.
Because great reports start with great data. And great data starts with M.
Books on Microsoft Excel, Power Query, Power BI, ChatGPT by Excel MVPs.
Holy Macro! Books is a niche publishing company dedicated to empowering Excel users worldwide with expert-level guides on Microsoft Excel, Power Query, Power BI, and more. Founded by Excel legend Bill Jelen, the company features books authored by Microsoft MVPs, former MVPs, and top industry experts who know their way around formulas, pivot tables, and data transformations. Whether you're a beginner or a power user, Holy Macro! delivers practical, straight-to-the-point content that turns spreadsheet struggles into spreadsheet superpowers.
Train Your GPT is a hands-on, no-code guide to creating AI assistants that actually work the way you do. Whether you're a content creator, consultant, or spreadsheet nerd, you'll learn how to train ChatGPT to follow your style, use your files, and save you serious time — all without needing to know a single line of code.
Leveraging Power Query to Get & Transform Your Task Flow
by Ken Puls & Miguel Escobar
Solving Advanced Data Cleaning Problems Using M
by Chandeep Chhabra