Products
November 2015
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.
VBA & Macros for Microsoft Excel 2016
November 2015
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.
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.
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.
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.
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.
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.