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.”
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: