Excel Data Analysis For Dummies. Paul McFedries
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