Microsoft Excel 2010 Formulas And Functions Inside Out

You're beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts increase their data analysis capabilities with Excel - and challenge yourself to new levels of mastery. * Create and debug financial formulas, and maximize the power of array formulas * Apply functions in conditional formatting and data validation * Work with range objects and control program flow * Develop custom worksheet functions with Microsoft Visual Basic(R) for Applications * Use error handling to make your VBA scripts more resilient