05078nam 2200673 a 450 991045119500332120200520144314.01-281-23789-297866112378990-470-37749-6(CKB)1000000000406327(EBL)333786(OCoLC)808678717(SSID)ssj0000151680(PQKBManifestationID)11153274(PQKBTitleCode)TC0000151680(PQKBWorkID)10337690(PQKB)11756338(MiAaPQ)EBC333786(CaSebORM)9780470132296(Au-PeEL)EBL333786(CaPaEBR)ebr10226865(CaONFJC)MIL123789(EXLCZ)99100000000040632720070330d2007 uy 0engurunu|||||txtccrExcel 2007 data analysis[electronic resource] your visual blueprint for creating and analyzing data, charts and PivotTables /by Denise Etheridge1st editionHoboken, N.J. Wileyc20071 online resource (305 p.)Read less-learn moreIncludes index.0-470-13229-9 Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and Pivot Tables; Credits; About the Author; Author's Acknowledgments; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Chapter 1: Getting Started; Introduction to Data Analysis with Excel; Understanding the Excel Window; Enter Data; Format Numbers; Format Cells; Select Data; Copy, Cut, and Paste Cells; Copy with the Office Clipboard; Insert and Delete Cells; Find and Replace; Find and Replace Formats; Chapter 2: Creating Formulas; Understanding Formulas; Create Formulas; Edit Formulas; Name Cells and RangesDefine and Display Constants Create Formulas that Include Names; Check Formulas for Errors; Trace Precedents and Dependents; Chapter 3: Creating and Using Functions; Understanding the Function Wizard; Round a Number; Determine the Nth Largest Value; Create a Conditional Formula; Calculate a Conditional Sum; Calculate Products and Square Roots; Look Up Information; Determine the Location of a Value; Perform Time Calculations; Perform Date Calculations; Chapter 4: Using Financial Functions; Calculate Future Value; Calculate Present Value; Calculate Loan Payments; Calculate Principal or InterestCalculate the Interest Rate Calculate the Internal Rate of Return; Calculate Straight-Line Depreciation; Calculate Declining Balance Depreciation; Calculate Double-Declining Balance Depreciation; Calculate Sum-of-the-Years-Digits Depreciation; Chapter 5: Using Statistical Functions and Tools; Calculate an Average; Calculate the Median or the Mode; Calculate Rank; 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 PercentileCalculate Descriptive Statistics Chapter 6: Organizing Worksheet Data; Enter Data with a Form; Filter Duplicate Records; Perform Simple Sorts and Filters; Perform Complex Sorts; Sort by Cell Color, Font Color, or Icon; Perform Complex Filters; Enter Criteria to Find Records; Filter by Multiple Criteria; Subtotal Sorted Data; Count Filtered Records; Define Data as a Table; Modify a Table Style; Chapter 7: Working with PivotTables; Create a PivotTable; Modify PivotTable Data and Layout; Compute Subtotals and Grand Totals; Create a Pivot Table Calculated Field; Hide Rows or Columns in a PivotTableSort a PivotTable Retrieve Values from a PivotTable; Chapter 8: Charting Data; Create a Chart; Add Chart Details; Change the Chart Type; Add a Trendline; Add and Remove Chart Data; Add Error Bars; Create a Histogram; Chart Filtered Data; Create a PivotChart; Create a Combination Chart; Chapter 9: Working with External Data; Paste Link into Word; Embed a Worksheet; Hyperlink a Worksheet; Query a Web Site; Import a Text File; Import an Access Database; Query an Access Database; Chapter 10: Useful Data Analysis Tools and Techniques; Perform What-If Analysis; Optimize a Result with Goal SeekSolve a Formula with a Data TableProvides 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.Visual read less, learn more.BusinessComputer softwaresearsSpreadsheet softwaresearsElectronic books.BusinessComputer software.Spreadsheet software.005.54Etheridge Denise886700MiAaPQMiAaPQMiAaPQBOOK9910451195003321Excel 2007 data analysis2106427UNINA