Products



Microsoft Excel 2019 VBA and Macros

November 2018

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.


Excel Dynamic Arrays Straight to the Point

September 2018

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.


Excel JavaScript UDFs Straight to the Point

June 2018

JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.


Supercharge Excel When You Learn to Write DAX For Power Pivot

April 2018

Hands-on book to learn and master the DAX language!


MrExcel LIVe

April 2018

A book for people who use Excel 40+ hours per week. Illustrated in full color.


Excel Subtotals Straight to the Point

February 2018

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.


Supercharge Power BI

February 2018

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.


Power Excel With MrExcel - 2017 Edition

January 2017

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