|
|
|
|
| LEADER |
05310nmm a2200565 u 4500 |
| 001 |
EB001934583 |
| 003 |
EBX01000000000000001097485 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 0735658021
|
| 020 |
|
|
|a 9780735668973
|
| 020 |
|
|
|a 0735668973
|
| 020 |
|
|
|a 0735668965
|
| 020 |
|
|
|a 9780735668966
|
| 050 |
|
4 |
|a HF5548.4.M523
|
| 100 |
1 |
|
|a Jeschke, Egbert
|
| 245 |
0 |
0 |
|a Microsoft® Excel® 2010 formulas and functions inside out
|c Egbert Jeschke [and others]
|
| 260 |
|
|
|a Sebastopol, Calif.
|b Microsoft Press
|c 2012
|
| 300 |
|
|
|a 1045 pages
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a Includes bibliographical references and index
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 653 |
|
|
|a Business / Computer programs / fast
|
| 653 |
|
|
|a Microsoft Excel (Computer file) / Handbooks, manuals, etc
|
| 653 |
|
|
|a COMPUTERS / Desktop Applications / Spreadsheets / bisacsh
|
| 653 |
|
|
|a Business & Economics / hilcc
|
| 653 |
|
|
|a Tableurs / Guides, manuels, etc
|
| 653 |
|
|
|a Business / Computer programs / Handbooks, manuals, etc
|
| 653 |
|
|
|a Microsoft Excel (Computer file) / blmlsh
|
| 653 |
|
|
|a Marketing & Sales / hilcc
|
| 653 |
|
|
|a Electronic spreadsheets / Handbooks, manuals, etc
|
| 653 |
|
|
|a Commerce / hilcc
|
| 653 |
|
|
|a Electronic spreadsheets / fast
|
| 653 |
|
|
|a Microsoft Excel (Computer file) / fast
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 776 |
|
|
|z 9780735668973
|
| 776 |
|
|
|z 0735668973
|
| 776 |
|
|
|z 0735668965
|
| 776 |
|
|
|z 9780735668966
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9780735665064/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 658
|
| 082 |
0 |
|
|a 005.54
|
| 082 |
0 |
|
|a 381
|
| 082 |
0 |
|
|a 330
|
| 520 |
|
|
|a 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
|