MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel News


50+ Hours of Excel Training for US $24 With Proceeds to Charity

50+ Hours of Excel Training for US $24 With Proceeds to Charity »


Excel MVP Liam Bastick has organized a 48-hour marathon of Excel training. He enlisted 55 Excel gurus to present for an hour each. Priced at US $24, the marathon starts at 1PM on July 21 2020 (New York time) and continues through 8 PM on July 23.

Walk / Ride / Run #ForSmitty This Week

Walk / Ride / Run #ForSmitty This Week »


Our good friend Chris “Smitty” Smith is in hospice this week, after a three year battle with cancer. I met Smitty when he was in the process of writing 29,536 answers at the MrExcel Message Board. Smitty became a Microsoft MVP for many years. He then actually joined the Excel team, and worked on cleaning up the Excel Help files.

What Is The Difference Between Microsoft Office Classic and Premium

What Is The Difference Between Microsoft Office Classic and Premium »


The retail box for Microsoft Office 2019 Home & Student makes it clear that you are not getting Outlook, Access or Publisher when you buy Excel 2019. But in the feature description for Word, Excel, Power Point and OneNote it says that you are getting “Classic” instead of “Premium”. What does that really mean?

Pandemic Relief Excel Course Features 26 Instructors

Pandemic Relief Excel Course Features 26 Instructors »


Many of us are stuck at home during the CoVid-19 quarantine. For a very limited time, you can enroll in a unique online Excel course called “Excel Tips by the Experts”. Twenty-six Excel experts from around the world each contributed a 10-to-15 minute lesson to the course.

Free Excel Tickmarks Add-in

Free Excel Tickmarks Add-in »


A seminar student of mine recently wrote: “Given our team’s migration to working from home and trying to maintain our effectiveness working remotely, we’ve been researching ways to drive consistent audit / review documentation through use of standard electronic audit tickmarks. Do you have any way that we can add tickmark icons to a cell through the Ribbon?”

Extend Excel Dynamic Arrays With FastExcel SpeedTools Version 4

Extend Excel Dynamic Arrays With FastExcel SpeedTools Version 4 »


Charles Williams is an Excel MVP in England. He is one guy, sitting in an office some 4,695 miles west of Redmond. In what Charles estimates as two- to three- man weeks, Charles built 44 enhancements to Dynamic Arrays. I’ve downloaded the beta of the software and the results are jaw-dropping. Now that I’ve seen them, I am not sure how I would live without them.

Bill Jelen's Sternly Written Policy on Posting Your Worksheet to the MrExcel Message Board

Bill Jelen's Sternly Written Policy on Posting Your Worksheet to the MrExcel Message Board »


Effective January 9, 2020, there are two acceptable ways to post your worksheet to the MrExcel Message Board: (1) Paste a screenshot or (2) post code generated by the official XL2BB.xlam add-in.

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

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


“XLOOKUP is Great, but it Makes this Book Obsolete.” MrExcel Publishing’s Attempt to Document the Constantly Changing Excel Features in Office 365.

Resolve to Learn Power BI in 2020

Resolve to Learn Power BI in 2020 »


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.