Excel Data Analysis for Dummies (Paperback)

Excel Data Analysis For Dummies is for readers who want to move beyond building simple worksheets and want to begin using Excel to gain valuable insight from their data.
Focuses on the features of Excel that are important to businesses and researchers including: working with external databases, PivotTables and Pivot Charts, using Excel for statistical and financial functions, data sharing, working with Solver, and using the Small Business Finance Manager.
Provides detailed step-by-step instructions on the use of Excel to perform statistical analysis.

Table of Contents

Introduction.

Part I: Where's the Beef?

Chapter 1: Introducing Excel Lists.

Chapter 2: Grabbing Data from External Sources.

Chapter 3: Scrub-a-Dub-Dub: Cleaning Data.

Part II: PivotTables and PivotCharts.

Chapter 4: Working with PivotTables.

Chapter 5: Building PivotTable Formulas.

Chapter 6: Working with PivotCharts.

Chapter 7: Customizing PivotCharts.

Part III: Advanced Tools.

Chapter 8: Using the Database Functions.

Chapter 9: Using the Statistics Functions.

Chapter 10: Descriptive Statistics.

Chapter 11: Inferential Statistics.

Chapter 12: Optimization Modeling with Solver.

Part IV: The Part of Tens.

Chapter 13: Almost Ten Things You Ought to Know about Statistics.

Chapter 14: Almost Ten Tips for Presenting List Results and Analyzing Data.

Chapter 15: Ten Tips for Visually Analyzing and Presenting Data.

Part V: Appendix.

Appendix: Glossary of Data Analysis and Excel Terms.

Index.