Products



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.


100 Excel Simulations

November 2016

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.


Your Excel Survival Kit

June 2016

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.