Products


About These Products

The books, CDs, and DVDs here are published by QUE or Holy Macro! Books. Written by Bill MrExcel Jelen and other Microsoft MVPs, they cover every aspect of Excel, including Power Query, Power Pivot, and Excel. If you use Excel 40 hours per week, you will find these titles concise and useful.


If you shopped at the MrExcel Store before February 2021 and have orders for downloadable products, you can still access those items by using your login and password in the following page.

MrExcel Legacy Store Login



Power Query Beyond the User Interface

February 2025

You've already transformed your data (along with your life) by learning Power Query. This book will take that transformation a lot further by teaching you the M language that sits behind Power Query's User Interface.


Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

January 2025

Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you’ve never created a pivot table before, this book will help you leverage their flexibility and analytical power and includes exploration of new array functions and Copilot capabilities in analysis creation.


Financial Modelling Using Dynamic Arrays

December 2024

This book tries hard to raze a laugh (yes, that' s what was meant... ). Instead, through numerous examples and case studies, it details the impact of the ecosystem introduced by dynamic arrays in Excel, injecting life into the jaded, stale world of financial modelling.


Financial Modelling for Project Finance

December 2024

If you have a beginner’s grasp in accounting, finance and Excel, you might be tempted to explore the quantitative, decision-centric world of Project Finance, ring-fencing funding for profitable projects. This book seeks to demystify the area and show how the basic principles of financial modelling.


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

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution


MrExcel 2024 Igniting Excel

February 2024

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.