Maximize the power of Excel 2013 formulas with this must-haveExcel reference
John Walkenbach, known as "Mr. Spreadsheet," is a master atdeciphering complex technical topics and Excel formulas are noexception. This fully updated book delivers more than 800 pages ofExcel 2013 tips, tricks, and techniques for creating formulas thatcalculate, developing custom worksheet functions with VBA,debugging formulas, and much more.
- Demonstrates how to use all the latest features in Excel2013
- Shows how to create financial formulas and tap into the powerof array formulas
- Serves as a guide to using various lookup formulas, workingwith conditional formatting, and developing custom functions
- Shares proven solutions for handling typical (andnot-so-typical) Excel formula challenges
- Includes links to the "Mr. Spreadsheet" website, which containsall the templates and worksheets used in the book, plus access toJohn Walkenbach's award-winning Power Utility Pak.
From charts to PivotTables and everything in between, Excel2013 Formulas is your formula for Excel success.