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


Your Excel Survival Kit

Your Excel Survival Kit »


This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

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.

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.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »


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

Excel Video Medley

Excel Video Medley »


Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

VBA & Macros for Microsoft Excel 2016

VBA & Macros for Microsoft Excel 2016 »


Use this guide to automate virtually any routine 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.

see more products »