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


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.

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.

Guerrilla Data Analysis 2nd Edition

Guerrilla Data Analysis 2nd Edition »


This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and "MrExcel" himself, Bill Jelen.

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.

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 »