80-page guide to using Dynamic Arrays in Excel.

This is the expanded and updated 2nd Edition of Rob Collie's DAX Formulas for Power Pivot.

A 50-page guide to cleaning Excel data with Power Query.

This is the fourth edition of Bill's favorite tips. The 2020 update of MrExcel XL, MrExcel LIVe, and MrExcel LX. You can download the e-book in three DRM-free formats.Buy from MrExcel for updates throughout 2020.

How to Excel at being a Lazy (that mean's efficient!) modeller. This 328-page book was originally published in Australia. It was such an informative Excel book, we've reprinted it for the US & UK markets. This is the print edition of the book.

A Microsoft MVP guide to the best parts of Excel

A 47-page guide to cleaning Excel data. This book covers traditional data cleansing methods like Text to Columns, Conditional Formatting, Remove Duplicates and Power Query.

Supercharge Power BI Book by Matt Allington

In the spring of 2019, Microsoft released the Excel Custom Functions feature in production recently. This 41-page primer is designed for Excel users who want to explore the world of Excel Custom Functions.

You'll go bananas as you replace tedious data cleansing with Power Query. This is the print book version of the definitive book on Power Query for Excel. While you are awaiting your shipment to arrive, you can download PDF, ePub, and Mobi editions.