MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel Publishing’s Attempt to Document the Constantly Changing Excel Features in Office 365

January 13, 2020 - by Bill Jelen

XLOOKUP is Great, but it Makes this Book Obsolete.

It was August 30, 2019. I was doing a seminar in Maitland Florida. People in the audience were excited about the new XLOOKUP function they had just heard about on CNBC. I happily ran through several XLOOKUP functions in the seminar, but then I deadpanned this joke: “XLOOKUP is super exciting, but it makes this brand-new MrExcel LX book already obsolete.”

MrExcel LX
MrExcel LX

Someone suggested... “Why not update the e-book so it does cover XLOOKUP??”

That was a great idea. The MrExcel LX book was only a few months old, but Excel kept constantly evolving. You can’t print 4000 new copies every time a new feature is released.

During December, I updated the PDF of MrExcel LX with XLOOKUP plus other features released to Office 365: (exchange rates, ask a question about your data, Power Query's Data Profiling tools). It is not a new book – there are only 12 new pages. But since I don’t think there is a way to represent 60.1 in Roman Numerals, I started calling this update MrExcel 2020.

Here is my plan:

continue reading »

More Reading

Resolve to Learn Power BI in 2020 »

December 26, 2019 - by Bill Jelen

It’s a new decade. You’ve been saying that you really need to transition your Excel skills to Power BI. If you are looking for a New Years Resolution for 2020, now is the time to get comfortable with Power BI and create a few dashboards.

Excel More Excel Tips. Photo Credit: Sam Truong Dan at

Excel 2019: More Excel Tips »

December 19, 2019 - by Bill Jelen

I published more than 200 ideas since February. While the following ideas did not get much press here, they are self-explanatory in a 140-character tweet.

read more articles »

Supercharge your career with training from MrExcel

Featured Products

Excel Dynamic Arrays Straight to the Point 2nd Edition

Excel Dynamic Arrays Straight to the Point 2nd Edition »

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.

MrExcel 2020 - Seeing Excel Clearly

MrExcel 2020 - Seeing Excel Clearly »

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

Excel Dynamic Arrays Straight to the Point »

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.

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Pivot Table Data Crunching »

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.

Excel 2019 Business Basics & Beyond

Excel 2019 Business Basics & Beyond »

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.

Introduction to Financial Modelling

Introduction to Financial Modelling »

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.

see more products »