Ebook: Microsoft Excel 2010 Formulas and Functions Inside Out

Conquer Microsoft® Excel® formulas and functions--from the 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 using Excel 2003, 2007, or 2010--and challenge yourself to new levels of mastery. Customize Excel formulas using 350+ built-in functionsCreate reusable formulas for common calculationsLearn smarter ways to calculate date and t.;Introduction; Solving Problems with Functions; Introducing the New Functions in Excel 2010; Scenario and Goals; The New Way to Work with Data, Formulas, and Functions; Creating the Month Data Series; Creating an Individual Data Series; Entering Test Data Fast; Converting Formula Results into Fixed Values; Formatting Numeric Values; Calculating Profit Margin; Formatting Data as a Table; Calculating Profit Margin as a Percentage; Applying Conditional Formatting; Creating Meaningful Charts; Creating a Column Chart; Creating a Pie Chart; Formatting a Chart; Working with PivotTables.