MrExcel Publishing
Your One Stop for Excel Tips & Solutions


MrExcel XL =ROMAN(40)

September 2015

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.

More Excel Outside the Box

July 2015

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.

Guerrilla Data Analysis 2nd Edition

May 2015

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.

Excel 2013 VBA

September 2014

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 Tables

September 2014

Inspired by the millions of Excellers who often underestimate the power of Tables, this book aims to increase the knowledge and skill levels of everyday Excel heroes, junkies, and anyone else who uses Excel to make their work and personal life more productive.

Power Excel with MrExcel

September 2014

567 Excel Mysteries Solved. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem.

Dashboarding and Reporting with Power Pivot and Excel

July 2014

Microsoft’s revolutionary Power Pivot is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways using the most-used analytical tool in the world: Excel.

PowerPivot Alchemy: Patterns and Techniques for Excel

June 2014

PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool

Fórmulas DAX Para PowerPivot

April 2014

Microsoft PowerPivot es un complemento gratuito para Excel de Microsoft que permite a los usuarios producir nuevos tipos de informes y análisis que simplemente eran imposibles antes, y este libro es el primero en abordar fórmulas DAX, la capacidad central de PowerPivot, desde la perspectiva de la audiencia de Excel.