Microsoft Excel 2010 Formulas and Functions Inside Out

Description

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. 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. Creating a PivotTableUsing a PivotTable Using PivotCharts: Graphical Pivot Creating a PivotChart Changing the Original Data Using Functions and PowerPivot Using Date and Time Functions The Excel Date System Date and Time Number Formats Leap Years Analysis Functions Date and Time Functions in Practice Using Text and Data Functions Separating Text Strings Such as ZIP Code and Location Separating First and Last Names Switching the First and Last Names Resolving the IBAN Calculating the Frequency of a Character in a String Removing All Spaces Correcting the Position of Signs. Displaying the File and Worksheet NameConcatenating the Content of Cells Breaking Lines in Concatenated Text Visualizing Data Using Logical Functions Calculating Profitability Using Search and Reference Functions Searching Through a Cross Table Using Information Functions Using Statistical Fu, nctions Overview Statistical Functions in Practice Using Database Functions Dynamic Database Names Database Functions in Practice Using Cube Functions Using Financial Math Functions An Annuity Calculation Example Calculating Repayment Calculating Exchange Rates. Investment Appraisal ExampleAmortization Calculation Example Using Math and Trigonometry Functions Generating Random Test Data PowerPivot Using PowerPivot in Excel 2010 From Numbers to Formulas Entering Formulas Operators Arithmetic Operators Comparison Operators The & Text Operator Reference Operators References in Formulas Relative References Absolute References Mixed References What Is a Circular Reference? Array Formulas Tips and Tricks Turning the Formula View On and Off Entering Formulas in Several Cells Entering Formulas in Several Worksheets. Selecting Formula CellsDetermining Which Cells Are Referenced in a Formula Copying and Moving Formulas Moving Formula Cells Copying Formula Cells Converting Formula Results into Fixed Values Converting Existing Values Protecting Formulas Hiding Formulas Specifying the Formula Calculation Type Analyzing Formulas Troubleshooting: Example 1 Troubleshooting: Example 2 Formulas and Functions What Is a Worksheet Function? The Syntax of a Function Arguments as Arithmetic Data in a Function Options for Passing Arguments Including Calculations in a Function Entering Functions.