MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Products


Power Excel With MrExcel - 2019 Edition

December 2019

This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

Introduction to Financial Modelling

October 2019

With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.

Excel 2019 Business Basics & Beyond

September 2019

Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.

Excel Data Cleansing Straight To The Point

July 2019

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.

Excel Custom Functions Straight to the Point

July 2019

Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.

The Absolute Guide to Dashboarding & Reporting with Power BI

March 2019

Learn Power BI Dashboarding Techniques by Watching A Pro!

Cleaning Excel Data With Power Query Straight To The Point

March 2019

This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

MrExcel LX – The Holy Grail of Excel Tips

February 2019

A book for people who use Excel 40+ hours per week. Illustrated in full color.

Microsoft Excel 2019 Pivot Table Data Crunching

January 2019

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.