LEADER 05319nam 2200661 a 450 001 9910139202003321 005 20200930113623.0 010 $a1-118-03623-9 010 $a1-118-98393-9 010 $a1-62198-432-X 010 $a1-282-68507-4 010 $a9786612685071 010 $a0-470-90172-1 035 $a(CKB)2560000000011787 035 $a(EBL)540089 035 $a(OCoLC)645097162 035 $a(SSID)ssj0000400238 035 $a(PQKBManifestationID)12108244 035 $a(PQKBTitleCode)TC0000400238 035 $a(PQKBWorkID)10404566 035 $a(PQKB)10062215 035 $a(MiAaPQ)EBC540089 035 $a(CaSebORM)9780470591604 035 $a(PPN)170223132 035 $a(EXLCZ)992560000000011787 100 $a20100706d2010 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 creating and analyzing data, charts and PivotTables /$fby Denise Etheridge 205 $a3rd ed. 210 $aIndianapolis, Ind. $cWiley$d2010 215 $a1 online resource (371 p.) 225 1 $aVisual Blueprint 300 $aIncludes index. 311 $a0-470-59160-9 327 $aExcelŽ Data Analysis: Your visual blueprintTM for creating and analyzing data, charts, and PivotTables, 3rd Edition; TABLE OF CONTENTS; Chapter 1: Getting Started; Introducing Data Analysis with Excel; Tour the Excel Window; Explore the Ribbon; Using the Mini Toolbar and Context Menu; Select Options on the Status Bar; Take a Look at Backstage View; Upload a File to Excel's Web-based Application; Create a File Using Excel's Web-based Application; Enter Data; Select Cells; Chapter 2: Formatting a Worksheet; Using the Ribbon to Format Numbers; Using the Format Cells Dialog Box 327 $aUnderstanding Dates and TimesFormat Percentages; Format Fractions; Format in Scientific Notation; Format as Text; Add a Border; Change the Font or Font Size; Add a Background Color; Change the Font Color; Bold, Underline, or Italicize; Align Data; Rotate Data; Wrap Text; Merge and Center; Apply a Style; Using Format Painter; Clear Formats; Chapter 3: Structuring Your Workbook; Cut, Copy, and Paste Cells; Using Live Preview with Paste; Paste from the Office Clipboard; Insert or Delete; Find and Replace Information; Change the Name of a Worksheet; Change Column Widths or Row Heights 327 $aHide Columns or RowsHide a Worksheet; Move or Copy a Worksheet; Freeze Worksheet Titles; Hide Gridlines, Headings, or the Formula Bar; Chapter 4: Creating Formulas; Understanding Formulas; Calculate with an Operator; Calculate Using a Function and Cell Addresses; Create an Array Formula; Using the Sum, Average, Count, Min, and Max Functions; Create a Formula that Refers to Another Worksheet; Understanding Relative and Absolute Cell Addresses; Edit Formulas; Name Cells and Ranges; Define and Display Constants; Create Formulas That Include Names; Check Formulas for Errors 327 $aTrace Precedents and DependentsChapter 5: Using Functions; Understanding the Function Wizard; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve Column or Row Numbers; Using VLOOKUP; Determine the Location of a Value; Using INDEX; Perform Date and Time Calculations; Chapter 6: Using Financial Functions; Calculate Future Value; Calculate Present Value; Calculate Loan Payments; Calculate Principal or Interest; Calculate the Interest Rate; Calculate the Internal Rate of Return 327 $aCalculate Straight-Line DepreciationCalculate Declining Balance Depreciation; Calculate Double-Declining Balance Depreciation; Calculate Sum-of-the-Years-Digits Depreciation; Chapter 7: Using Statistical Functions and Tools; Calculate an Average; Calculate a Conditional Average; Calculate the Median or the Mode; Calculate Rank; Determine the Nth Largest Value; Calculate Frequency; Calculate Variance and Standard Deviation; Find the Correlation; Install Excel Add-Ins; Calculate a Moving Average; Compare Variances; Using the Data Analysis Toolpak to Determine Rank and Percentile 327 $aCalculate Descriptive Statistics 330 $aAdvanced techniques for Excel power users Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, 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.Provides a clear look at power-using Excel, the world's l 410 0$aVisual Blueprint 606 $aElectronic spreadsheets$xComputer programs 615 0$aElectronic spreadsheets$xComputer programs. 676 $a005.54 700 $aEtheridge$b Denise$0886700 701 $aSimon$b Jinjer L.$f1966-$0886701 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910139202003321 996 $aExcel data analysis$91980113 997 $aUNINA