Power Excel with MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis in Excel 2010?2013

Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel'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. Mr. Excel 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.

Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and writes the monthly Excel column for Strategic Finance Magazine. He is the author of 44 books about Excel. He lives in Akron, Ohio.