Cargando…
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 m...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
Microsoft Press,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | OR_ocn771876170 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 120109s2012 cau obf 001 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d YDXCP |d OCLCQ |d N$T |d ZQP |d TEFOD |d TEFOD |d OCLCQ |d DEBSZ |d OCLCF |d OCLCQ |d UMI |d CUS |d CNSPO |d OCL |d CUS |d OCLCQ |d KYD |d HCO |d NTG |d RDF |d OCLCQ |d OCLCO |d OCLCQ | ||
| 019 | |a 761692549 |a 880748068 | ||
| 020 | |a 9780735668973 |q (electronic bk.) | ||
| 020 | |a 0735668973 |q (electronic bk.) | ||
| 020 | |a 9780735668966 |q (electronic bk.) | ||
| 020 | |a 0735668965 |q (electronic bk.) | ||
| 020 | |a 0735658021 | ||
| 020 | |a 9780735658028 | ||
| 029 | 1 | |a AU@ |b 000050492363 | |
| 029 | 1 | |a AU@ |b 000052893371 | |
| 029 | 1 | |a DEBSZ |b 367963825 | |
| 029 | 1 | |a DEBSZ |b 397220669 | |
| 029 | 1 | |a AU@ |b 000055786498 | |
| 035 | |a (OCoLC)771876170 |z (OCoLC)761692549 |z (OCoLC)880748068 | ||
| 037 | |a CL0500000117 |b Safari Books Online | ||
| 050 | 4 | |a HF5548.4.M523 |b J47 2012eb | |
| 072 | 7 | |a COM |x 054000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.54 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Jeschke, Egbert. | |
| 245 | 1 | 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 1 online resource (1045 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 504 | |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 | 8 | |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. | |
| 505 | 8 | |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 | 8 | |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 | 8 | |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. | |
| 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. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |v Handbooks, manuals, etc. |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |0 (OCoLC)fst01366659 |
| 650 | 0 | |a Business |x Computer programs |v Handbooks, manuals, etc. | |
| 650 | 0 | |a Electronic spreadsheets |v Handbooks, manuals, etc. | |
| 650 | 6 | |a Tableurs |v Guides, manuels, etc. | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Spreadsheets. |2 bisacsh | |
| 650 | 7 | |a Business |x Computer programs. |2 fast |0 (OCoLC)fst00842283 | |
| 650 | 7 | |a Electronic spreadsheets. |2 fast |0 (OCoLC)fst00907463 | |
| 650 | 7 | |a Commerce. |2 hilcc | |
| 650 | 7 | |a Business & Economics. |2 hilcc | |
| 650 | 7 | |a Marketing & Sales. |2 hilcc | |
| 655 | 7 | |a Handbooks and manuals. |2 fast |0 (OCoLC)fst01423877 | |
| 776 | 0 | 8 | |i Print version: |a Jeschke, Egbert. |t Microsoft® Excel® 2010 Formulas and Functions Inside Out. |d Sebastopol : Microsoft Press, ©2012 |z 9780735658028 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780735665064/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a YBP Library Services |b YANK |n 7344571 | ||
| 938 | |a EBSCOhost |b EBSC |n 431888 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL833659 | ||
| 938 | |a YBP Library Services |b YANK |n 18067802 | ||
| 994 | |a 92 |b IZTAP | ||