MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


  • MrExcel 2021 – Unmasking Excel
    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
    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.

  • Continuing Financial Modelling
    Continuing Financial Modelling

    November 2020

    You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.

  • MrExcel 2020 - Seeing Excel Clearly
    MrExcel 2020 - Seeing Excel Clearly

    January 2020

    This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.

  • Excel Dynamic Arrays Straight to the Point 2nd Edition
    Excel Dynamic Arrays Straight to the Point 2nd Edition

    January 2020

    Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.

  • Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel
    Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

    January 2020

    There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.

  • Power Excel With MrExcel - 2019 Edition
    Power Excel With MrExcel - 2019 Edition

    December 2019

    This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

  • Introduction to Financial Modelling
    Introduction to Financial Modelling

    October 2019

    With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.

  • Excel 2019 Business Basics & Beyond
    Excel 2019 Business Basics & Beyond

    September 2019

    Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.