Navigating Excel

MrExcel 2025

by Bill Jelen

About The Book

Whether you're just starting out or you're the office Excel wizard, MrExcel 2024 Navigating Excel is your all-in-one field guide to mastering Microsoft Excel’s newest and most powerful features.

With over 256 bite-sized tips—each one focused, practical, and battle-tested—this book will change the way you use Excel. Learn faster ways to clean data, build smarter dashboards, analyze with Python, create stunning visualizations, and even collaborate with AI using Microsoft Copilot.

From simple tricks like double-clicking the fill handle to power moves like using GROUPBY and LAMBDA, Bill Jelen walks you through real-world solutions in a way that’s fun, fast, and crystal clear. And yes, there are dozens of bonus tips tucked in along the way!

Highlights include:
How to build perfect pivot tables (and fix what drives you crazy about them)
Clean, analyze, and visualize your data with Python—right inside Excel
Use Copilot to write formulas, summarize YouTube videos, and search the web
Discover dynamic arrays, regex formulas, and new validation tricks
Unlock over 40 tips for working with charts, dashboards, and slicers
Automate tasks with VBA, Office Scripts, and new macro recording improvements
Updated for the latest Excel innovations through June 2025—including everything Copilot, AI, and Python-related.

Whether you're an accountant, analyst, student, or manager, this is your roadmap to Excel mastery. Stop clicking around. Start navigating.

Holy Macro! Books

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.

More Books by Holy Macro! Books

Train Your Own GPT

How to Train ChatGPT to Think Like You

by Bill Jelen

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.

Master Your Data with Power Query in Excel and Power BI

Leveraging Power Query to Get & Transform Your Task Flow

by Ken Puls & Miguel Escobar

The Transformative Magic of M Code in Power Query and Power BI

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

Power Query Beyond The User Interface - Color Edition

Solving Advanced Data Cleaning Problems Using M

by Chandeep Chhabra