MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


July 9, 2020 - by Bill Jelen

MELBOURNE: 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. If your favorite topic is being presented in the middle of the night, most sessions will be recorded for viewing later.

Sign up at https://excelvirtuallyglobal.com/pricing/.

continue reading »

More Reading


Stock & Exchange Rate History in Excel »

June 29, 2020 - by Bill Jelen


A new STOCKHISTORY function debuted in the beta channel of Excel for Office 365 last week. The function is able to pull historical stock prices and exchange rates at a daily, weekly or monthly interval.

Walk / Ride / Run #ForSmitty This Week »

June 23, 2020 - by Bill Jelen


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.

read more articles »


Supercharge your career with training from MrExcel

Featured Products


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 Insights – A Microsoft MVP Guide to the Best Parts of Excel

Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel »


There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.

MrExcel LX – The Holy Grail of Excel Tips

MrExcel LX – The Holy Grail of Excel Tips »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

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.

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.

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.

see more products »