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


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.

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.

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.

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.

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.

M is for (DATA) MONKEY

M is for (DATA) MONKEY »


Despite the moniker "data monkey", we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

see more products »