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.
Financial Modelling in Power BI
The only book to produce all three financial statements in Power BI.
Power BI for the Excel Data Analyst
A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.
Microsoft 365 Excel: The Only App That Matters
Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!
Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition
Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.
Programming PowerPoint with VBA
This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!