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...
| Main Author: | |
|---|---|
| Corporate Author: | |
| Other Authors: | , , , , |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Sebastopol :
Microsoft Press
2012.
|
| Edition: | 1st edition |
| Series: | Inside Out
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628221706719 |
Table of Contents:
- Introduction; Who This Book Is For; How This Book Is Organized; Features and Conventions Used in This Book; Your Companion eBook; Using the Sample Files; Acknowledgments; Support and Feedback; 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 PercentageApplying Conditional Formatting; Creating Meaningful Charts; Creating a Column Chart; Creating a Pie Chart; Formatting a Chart; Working with PivotTables; Creating a PivotTable; Using 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 NamesSwitching 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 Name; Concatenating 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 NamesDatabase Functions in Practice; Using Cube Functions; Using Financial Math Functions; An Annuity Calculation Example; Calculating Repayment; Calculating Exchange Rates; Investment Appraisal Example; Amortization 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 Cells; Determining 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?
