Cargando…
Excel data analysis : your visual blueprint for analyzing data, charts, and PivotTables /
Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
John Wiley & Sons,
©2013.
|
| Edición: | 4th ed. |
| Colección: | Visual blueprint.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocn862412117 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 131108s2013 inua ob 001 0 eng d | ||
| 010 | |a 2013938097 | ||
| 040 | |a UMI |b eng |e pn |c UMI |d E7B |d OCLCO |d YDXCP |d DEBSZ |d OCLCQ |d COO |d TEFOD |d OCLCF |d VT2 |d OCLCQ |d COCUF |d CNNOR |d MOR |d PIFPO |d OCLCQ |d OCLCO |d U3W |d G3B |d STF |d HCO |d WRM |d CEF |d NRAMU |d INT |d AU@ |d OCLCQ |d OCLCO |d WYU |d OCLCQ |d OCLCO |d A6Q |d HS0 |d BOL |d UKCRE |d OCL |d OCLCO |d OCLCQ | ||
| 019 | |a 854851716 |a 857067461 |a 908280164 |a 961649252 |a 962642283 |a 988442988 |a 991964329 |a 1037765789 |a 1038670476 |a 1045483357 |a 1055367686 |a 1058162474 |a 1066011831 |a 1081246555 |a 1083602772 |a 1103263808 |a 1114463888 |a 1153008088 | ||
| 020 | |a 9781118780329 | ||
| 020 | |a 1118780329 | ||
| 020 | |a 1118781937 | ||
| 020 | |a 9781118781937 | ||
| 020 | |z 9781118517147 | ||
| 020 | |z 1118517148 | ||
| 020 | |z 9781118781937 | ||
| 029 | 1 | |a AU@ |b 000052281964 | |
| 029 | 1 | |a AU@ |b 000053041205 | |
| 029 | 1 | |a CHBIS |b 009939606 | |
| 029 | 1 | |a CHVBK |b 302487573 | |
| 029 | 1 | |a DEBBG |b BV041433307 | |
| 029 | 1 | |a DEBSZ |b 398292957 | |
| 029 | 1 | |a NZ1 |b 15493468 | |
| 029 | 1 | |a AU@ |b 000065668253 | |
| 035 | |a (OCoLC)862412117 |z (OCoLC)854851716 |z (OCoLC)857067461 |z (OCoLC)908280164 |z (OCoLC)961649252 |z (OCoLC)962642283 |z (OCoLC)988442988 |z (OCoLC)991964329 |z (OCoLC)1037765789 |z (OCoLC)1038670476 |z (OCoLC)1045483357 |z (OCoLC)1055367686 |z (OCoLC)1058162474 |z (OCoLC)1066011831 |z (OCoLC)1081246555 |z (OCoLC)1083602772 |z (OCoLC)1103263808 |z (OCoLC)1114463888 |z (OCoLC)1153008088 | ||
| 037 | |a CL0500000331 |b Safari Books Online | ||
| 050 | 4 | |a HF5548.4.M523 |b M36 2013 | |
| 082 | 0 | 4 | |a 005.54 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a McFedries, Paul. | |
| 245 | 1 | 0 | |a Excel data analysis : |b your visual blueprint for analyzing data, charts, and PivotTables / |c Paul McFedries. |
| 250 | |a 4th ed. | ||
| 260 | |a Indianapolis, IN : |b John Wiley & Sons, |c ©2013. | ||
| 300 | |a 1 online resource (1 volume) : |b illustrations. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 340 | |g polychrome. |2 rdacc |0 http://rdaregistry.info/termList/RDAColourContent/1003 | ||
| 347 | |a text file |2 rdaft |0 http://rdaregistry.info/termList/fileType/1002 | ||
| 490 | 1 | |a Visual blueprint | |
| 588 | 0 | |a Print version record. | |
| 504 | |a Includes bibliographical references and index. | ||
| 520 | |a Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros. | ||
| 505 | 0 | |a About the Author; Table of Contents; Chapter 1: Building Formulas for Data Analysis; Introducing Data Analysis; Introducing Formulas; Understanding Formula Types; Build a Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; Switc h to Absolute Cell References; Create an Array Formula; Turn On Iterative Calculations; Chapter 2: Troubleshooting Formulas; Understanding Error Values in Excel; Show Formulas Instead of Results; Use a Watch Window to Monitor a Cell Value; Step Through a Formula; Display Text Instead of Error Values | |
| 505 | 8 | |a Check for Formula Errors in a WorksheetAudit a Formula to Locate Errors; Chapter 3: Enhancing Formulas with Functions; Understanding Excel Functions; Understanding Function Types; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve a Column or Row Number; Look Up a Value; Determine the Location of a Value; Return a Cell Value with INDEX; Perform Date and Time Calculations; Chapter 4: Analyzing Financial Data | |
| 505 | 8 | |a Calculate Future ValueCalculate Present Value; Determine the Loan Payments; Calculate the Principal or Interest; Find the Required Interest Rate; Determine the Internal Rate of Return; Calculate Straight-Line Depreciation; Return the Fixed-Declining Balance Depreciation; Determine the Double-Declining Balance Depreciation; Figure the Sum-of-the-Years-Digits Depreciation; Chapter 5: Analyzing Statistical Data; Calculate an Average; Calculate a Conditional Average; Determine the Median or the Mode; Find the Rank; Determine the Nth Largest or Smallest Value | |
| 505 | 8 | |a Create a Grouped Frequency DistributionCalculate the Variance and Standard Deviation; Find the Correlation; Chapter 6: Building Tables for Data Analysis; Understanding Tables; Introducing Table Features; Convert a Range to a Table; Select Table Data; Insert a Table Row; Insert a Table Column; Delete a Table Row; Delete a Table Column; Add a Column Subtotal; Chapter 7: Sorting and Filtering Data; Perform a Simple Sort or Filter; Perform a Multilevel Sort; Create a Custom Sort; Sort by Cell Color, Font Color, or Cell Icon; Using Quick Filters for Complex Sorting; Enter Criteria to Find Records | |
| 505 | 8 | |a Create an Advanced FilterDisplay Unique Records in the Filter Results; Count Filtered Records; Chapter 8: Learning Data Analysis Techniques; Highlight Cells That Meet Some Criteria; Highlight the Top or Bottom Values in a Range; Show Duplicate Values; Show Cells That Are Above or Below Average; Analyze Cell Values with Data Bars; Analyze Cell Values with Color Scales; Analyze Cell Values with Icon Sets; Create a Custom Conditional Formatting Rule; Highlight Cells Based On a Formula; Modify a Conditional Formatting Rule; Remove Conditional Formatting from a Range | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 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 Electronic spreadsheets |x Computer programs. | |
| 650 | 6 | |a Tableurs |x Logiciels. | |
| 650 | 7 | |a Industrial management |x Statistical methods |x Computer programs. |2 fast |0 (OCoLC)fst00971331 | |
| 650 | 7 | |a Decision making |x Computer programs. |2 fast |0 (OCoLC)fst00889038 | |
| 650 | 7 | |a Electronic spreadsheets |x Computer programs. |2 fast |0 (OCoLC)fst00907465 | |
| 776 | 0 | 8 | |i Print version: |a McFedries, Paul. |t Excel data analysis. |b 4th ed. |d Indianapolis, IN : John Wiley & Sons, ©2013 |z 9781118517147 |w (OCoLC)847541982 |
| 830 | 0 | |a Visual blueprint. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781118780329/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a ebrary |b EBRY |n ebr10738077 | ||
| 938 | |a YBP Library Services |b YANK |n 10882284 | ||
| 994 | |a 92 |b IZTAP | ||