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 Unsplash.com

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


Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »


Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

Power Excel With MrExcel - 2019 Edition

Power Excel With MrExcel - 2019 Edition »


This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

Microsoft Excel 2019 VBA and Macros

Microsoft Excel 2019 VBA and Macros »


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 Custom Functions Straight to the Point

Excel Custom Functions Straight to the Point »


Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.

Cleaning Excel Data With Power Query Straight To The Point

Cleaning Excel Data With Power Query Straight To The Point »


This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »


Learn Power BI Dashboarding Techniques by Watching A Pro!

see more products »