Excel 2007 data analysis your visual blueprint for creating and 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.
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. :
Wiley
c2007.
|
| Edición: | 1st edition |
| Colección: | Visual read less, learn more.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627378106719 |
Tabla de Contenidos:
- 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 Ranges
- Define 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 Interest
- Calculate 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 Percentile
- Calculate 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 PivotTable
- Sort 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 Seek
- Solve a Formula with a Data Table
