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

Advanced Excel Techniques - Online Course

January 2022

Understanding data is crucial, and the easiest place to start is with Microsoft Excel. In this guide, I've compiled advanced skills and formulas in Excel that you should know to analyze and understand your data easier and faster.

Saving Time with Excel - Online Course

January 2022

Be more efficient in Excel with these time-saving techniques in Excel.

Ace Your Job Interview Where You Have to Know Excel - Online Course

January 2022

You have a job interview this afternoon where you have to know Excel? This short video course will teach you enough Excel skills to get through the interview.

Analyzing Data With Pivot Tables in Excel - Online Course

January 2022

Bill Jelen has rolled all of his favorite Excel Pivot Table tips and techniques into a new guide on the Retrieve platform.

Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.

MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.