MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel Joins Kindle Unlimited Program


February 18, 2018 - by Bill Jelen

MrExcel Joins Kindle Unlimited Program

MrExcel and Holy Macro! Books have joined the Kindle Unlimited program for two dozen select backlist titles in our catalog. Subscribers in the program can access any of these titles on their Kindle for free:


Bill Jelen, publisher of MrExcel noted:

I love browsing books on my Kindle, particularly when I am flying or I can not be on the computer. The Kindle Unlimited program allows readers to experience our books. We hope to gain fans who will purchase our newer books in the future.

Bill Jelen, MrExcel

The complete list of titles available include:

continue reading »

More Reading


When It Makes Sense to Use Option Explicit

When It Makes Sense to Use Option Explicit »

February 17, 2018 - by Bill Jelen


It seems that I have caused some angst over the years because of my controversial stance that Option Explicit is not useful in VBA. I was reminded of this recently when I did a Skype session at Excel Weekend of Brazil. I've written a book on Excel VBA for QUE. That book has been translated to Portuguese for the Brazil market. So, apparently, I've taught the fine people of Brasil about Excel VBA for 15 years. Now that I am 15 years older and wiser, I will concede that there might be good reasons to use Option Explicit.

What Characters are Legal in a Worksheet Name

What Characters are Legal in a Worksheet Name »

February 16, 2018 - by Bill Jelen


Worksheet names can be changed to almost anything. It is the *almost* part that is fuzzy for me. There are a few characters that aren't allowed in a worksheet tab. But how do you figure out which characters they are? Today, I will show you how.

read more news »

Featured Products


Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

MrExcel XL =ROMAN(40)

MrExcel XL =ROMAN(40) »


Fun Excel book in full color. Includes Bill's favorite 40 Excel tips, plus Excel jokes, Excel Tweets, and Excel cocktails. Bonus section includes 40 keyboard shortcuts and more.

Excel 2013 VBA

Excel 2013 VBA »


The "Excel 2013 VBA" CD-ROM is not only an excellent learning tool to master VBA, but also a gold mine for very powerful and useful macros.

Excel 2016 in Depth

Excel 2016 in Depth »


Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.

100 Excel Simulations

100 Excel Simulations »


Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

More Excel Outside the Box

More Excel Outside the Box »


A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems.

see more products »