LEADER 05590nam 2200697Ia 450 001 9910787563703321 005 20230912141914.0 010 $a1-118-78193-7 035 $a(CKB)2670000000399766 035 $a(EBL)1272379 035 $a(OCoLC)854520444 035 $a(SSID)ssj0001076292 035 $a(PQKBManifestationID)11597035 035 $a(PQKBTitleCode)TC0001076292 035 $a(PQKBWorkID)11027355 035 $a(PQKB)10460428 035 $a(Au-PeEL)EBL1272379 035 $a(CaPaEBR)ebr10738077 035 $a(CaONFJC)MIL576341 035 $a(Au-PeEL)EBL7147376 035 $a(CaSebORM)9781118780329 035 $a(MiAaPQ)EBC1272379 035 $a(MiAaPQ)EBC7147376 035 $a(EXLCZ)992670000000399766 100 $a20130802d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel data analysis$b[electronic resource] $eyour visual blueprint for analyzing data, charts, and pivotTables /$fPaul McFedries 205 $a4th ed. 210 $aIndianapolis, IN $cJohn Wiley & Sons$dc2013 215 $a1 online resource (338 p.) 225 1 $aVisual Blueprint 300 $aDescription based upon print version of record. 311 $a1-118-78032-9 311 $a1-118-51714-8 320 $aIncludes bibliographical references and index. 327 $aAbout 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 327 $aCheck 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 327 $aCalculate 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 327 $aCreate 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 327 $aCreate 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 327 $aRemove Conditional Formatting from a Worksheet 330 $aProfessional-level coverage and techniques for Excel power users Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.Demonstrates how to crunch and analyze Excel data t 410 0$aVisual Blueprint 606 $aIndustrial management$xStatistical methods$xComputer programs 606 $aDecision making$xComputer programs 615 0$aIndustrial management$xStatistical methods$xComputer programs. 615 0$aDecision making$xComputer programs. 676 $a005.54 700 $aMcFedries$b Paul$0754847 701 $aEtheridge$b Denise$0886700 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910787563703321 996 $aExcel data analysis$93846561 997 $aUNINA