Power Excel with MrExcel : Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis, 2017 Edition

Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

"This book talks about 617 of the most common and irritating problems in Excel. You will find each of these 617 items (which you have been stumbling over ever since your “5 minutes of training”) followed by the solution or solutions you need to solve that problem. A lot of these topics stem from questions sent my way in seminars I’ve taught. They may not be the coolest tips in the whole world, but if you master even half of these concepts, you will be smarter than 95% of the other Excellers in the world and will certainly save yourself several hours per week.

Despite its size, this book is a quick read. You can probably skim all 617 topics in a couple of hours to get a basic idea of what is in here. When you face a similar situation, you can find the appropriate topic, apply it to your own problem, and you should be all set." - from the "Foreword"