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


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.

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.

Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016 »


Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

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.

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.

Learn to Write DAX

Learn to Write DAX »


Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

see more products »