[Dummies 01] • Excel Data Analysis For Dummies · 4th Edition, 4 by McFedries, Paul -- Read -- Imperial Library of Trantor

Index

Cover Table of Contents Introduction

About This Book What You Can Safely Ignore Foolish Assumptions Icons Used in This Book Beyond the Book Where to Go from Here

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 It's Sometimes a Raw Deal

Chapter 5: Scrub-a-Dub-Dub: Cleaning Data

Editing Your Imported Workbook Cleaning Data with Text Functions Using Validation to Keep Data Clean

Chapter 6: 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

Part 2: Analyzing Data with PivotTables and PivotCharts

Chapter 7: Creating and Using PivotTables

Understanding PivotTables Exploring PivotTable Features Building a PivotTable from an Excel 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 8: 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 9: Building PivotCharts

Introducing the PivotChart Creating a PivotChart Working with PivotCharts

Part 3: Discovering Advanced Data Analysis Tools

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

Chapter 11: Analyzing Data with 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 with 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 with 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

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

Appendix: Glossary of Data Analysis and Excel Terms Index Author Bio Connect with Dummies End User License Agreement