| Description |
1 online resource (1045 pages) |
| Bibliography |
Includes bibliographical references and index. |
| Contents |
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. |
| Summary |
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. |
| Subject |
Microsoft Excel (Computer file) -- Handbooks, manuals, etc.
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Business -- Computer programs -- Handbooks, manuals, etc.
|
|
Electronic spreadsheets -- Handbooks, manuals, etc.
|
|
Tableurs -- Guides, manuels, etc. |
|
Business -- Computer programs |
|
Electronic spreadsheets |
|
Commerce. |
|
Business & Economics. |
|
Marketing & Sales. |
| Genre |
Handbooks and manuals
|
| Other Form: |
Print version: Jeschke, Egbert. Microsoft® Excel® 2010 Formulas and Functions Inside Out. Sebastopol : Microsoft Press, ©2012 9780735658028 |
| ISBN |
9780735668973 (electronic bk.) |
|
0735668973 (electronic bk.) |
|
9780735668966 (electronic bk.) |
|
0735668965 (electronic bk.) |
|
0735658021 |
|
9780735658028 |
|
More Resources