Читать книгу Excel Data Analysis For Dummies - Paul McFedries - Страница 3
Excel® Data Analysis For Dummies® To view this book's Cheat Sheet, simply go to www.dummies.com and search for “Excel Data Analysis For Dummies Cheat Sheet” in the Search box. Table of Contents
Оглавление1 Cover
4 Introduction About This Book What You Can Safely Ignore Foolish Assumptions Icons Used in This Book Beyond the Book Where to Go from Here
5 Part 1: Getting Started with Data Analysis Chapter 1: Learning Basic Data-Analysis Techniques What Is Data Analysis, Anyway? Analyzing Data with Conditional Formatting Summarizing Data with Subtotals Grouping Related Data Consolidating Data from Multiple Worksheets Chapter 2: Working with Data-Analysis Tools Working with Data Tables Analyzing Data with Goal Seek Analyzing Data with Scenarios Optimizing Data with Solver Chapter 3: Introducing Excel Tables What Is a Table and Why Should I Care? Building a Table Analyzing Table Information Chapter 4: Grabbing Data from External Sources What’s All This about External Data? Exporting Data from Other Programs Importing External Data into Excel Querying External Databases Chapter 5: Analyzing Table Data with Functions The Database Functions: Some General Remarks Retrieving a Value from a Table Summing a Column's Values Counting a Column’s Values Averaging a Column's Values Determining a Column’s Maximum and Minimum Values Multiplying a Column’s Values Deriving a Column’s Standard Deviation Calculating a Column’s Variance
6 Part 2: Analyzing Data Using PivotTables and PivotCharts Chapter 6: Creating and Using PivotTables Understanding PivotTables Exploring PivotTable Features Building a PivotTable from an Excel Range or Table Creating a PivotTable from External Data Refreshing PivotTable Data Adding Multiple Fields to a PivotTable Area Pivoting a Field to a Different Area Grouping PivotTable Values Filtering PivotTable Values Chapter 7: Performing PivotTable Calculations Messing around with PivotTable Summary Calculations Working with PivotTable Subtotals Introducing Custom Calculations Inserting a Custom Calculated Field Inserting a Custom Calculated Item Editing a Custom Calculation Deleting a Custom Calculation Chapter 8: Building PivotCharts Introducing the PivotChart Creating a PivotChart Working with PivotCharts
7 Part 3: Discovering Advanced Data-Analysis Tools Chapter 9: Dealing with Data Models Understanding Excel Data Models Managing a Data Model with Power Pivot Transforming Data Creating a PivotTable or PivotChart from Your Data Model Chapter 10: Tracking Trends and Making Forecasts Plotting a Best-Fit Trend Line Calculating Best-Fit Values Plotting Forecasted Values Extending a Linear Trend Calculating Forecasted Linear Values Plotting an Exponential Trend Line Calculating Exponential Trend Values Plotting a Logarithmic Trend Line Plotting a Power Trend Line Plotting a Polynomial Trend Line Creating a Forecast Sheet Chapter 11: Analyzing Data Using Statistics Counting Things Averaging Things Finding the Rank Determining the Nth Largest or Smallest Value Creating a Grouped Frequency Distribution Calculating the Variance Calculating the Standard Deviation Finding the Correlation Chapter 12: Analyzing Data Using Descriptive Statistics Loading the Analysis ToolPak Generating Descriptive Statistics Calculating a Moving Average Determining Rank and Percentile Generating Random Numbers Creating a Frequency Distribution Chapter 13: Analyzing Data Using Inferential Statistics Sampling Data Using the t-Test Tools Performing a z-Test Determining the Regression Calculating the Correlation Calculating the Covariance Using the Anova Tools Performing an f-Test
8 Part 4: The Part of Tens Chapter 14: Ten Things You Ought to Know about Statistics Descriptive Statistics Are Straightforward Averages Aren’t So Simple Sometimes Standard Deviations Describe Dispersion An Observation Is an Observation A Sample Is a Subset of Values Inferential Statistics Are Cool But Complicated Probability Distributions Aren't Always Confusing Parameters Aren't So Complicated Skewness and Kurtosis Describe a Probability Distribution’s Shape Confidence Intervals Seem Complicated at First But Are Useful Chapter 15: Ten Ways to Analyze Financial Data Calculating Future Value Calculating Present Value Determining Loan Payments Calculating a Loan Payment's Principal and Interest Calculating Cumulative Loan Principal and Interest Finding the Required Interest Rate Determining the Internal Rate of Return Calculating Straight-Line Depreciation Returning the Fixed-Declining Balance Depreciation Determining the Double-Declining Balance Depreciation Chapter 16: Ten Ways to Raise Your PivotTable Game Turn the PivotTable Fields Task Pane On and Off Change the PivotTable Fields Task Pane Layout Display the Details Behind PivotTable Data Apply a PivotTable Style Create a Custom PivotTable Style Preserve PivotTable Formatting Rename the PivotTable Turn Off Grand Totals Reduce the Size of PivotTable Workbooks Use a PivotTable Value in a Formula
9 Appendix: Glossary of Data Analysis and Excel Terms
10 Index
11 Author Bio
