Power Excel 2019 with MrExcel Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

Updating the previous edition's tips to include features in Office 365 and Excel 2019, 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 up users, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

Bill Jelen is the host of www.MrExcel.com, Microsoft MVP, and he writes the monthly Excel column for Strategic Finance Magazine. He is the author of 54 books about Excel.