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!
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.
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.