05589nam 2200709Ia 450 991080863350332120200520144314.01-118-78193-7(CKB)2670000000399766(EBL)1272379(OCoLC)854520444(SSID)ssj0001076292(PQKBManifestationID)11597035(PQKBTitleCode)TC0001076292(PQKBWorkID)11027355(PQKB)10460428(Au-PeEL)EBL1272379(CaPaEBR)ebr10738077(CaONFJC)MIL576341(Au-PeEL)EBL7147376(CaSebORM)9781118780329(MiAaPQ)EBC1272379(MiAaPQ)EBC7147376(OCoLC)862412117(OCoLC)ocn862412117(EXLCZ)99267000000039976620130802d2013 uy 0engur|n|---|||||txtccrExcel data analysis your visual blueprint for analyzing data, charts, and pivotTables /Paul McFedries4th ed.Indianapolis, IN John Wiley & Sonsc20131 online resource (338 p.)Visual BlueprintDescription based upon print version of record.1-118-78032-9 1-118-51714-8 Includes bibliographical references and index.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 ValuesCheck 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 DataCalculate 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 ValueCreate 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 RecordsCreate 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 RangeRemove Conditional Formatting from a WorksheetProfessional-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 tVisual BlueprintIndustrial managementStatistical methodsComputer programsDecision makingComputer programsIndustrial managementStatistical methodsComputer programs.Decision makingComputer programs.005.54McFedries Paul754847MiAaPQMiAaPQMiAaPQBOOK9910808633503321Excel data analysis4201005UNINA