Includes bibliographical references and index.

Introduction 1 -- Part 1: Getting Started with Data Analysis -- Chapter 1: Learning Basic Data-Analysis Techniques -- Chapter 2: Working with Data-Analysis Tools -- Chapter 3: Introducing Excel Tables -- Chapter 4: Grabbing Data from External Sources -- Chapter 5: Analyzing Table Data with Functions -- Part 2: Analyzing Data Using Pivot Tables and Pivot Charts -- Chapter 6: Creating and Using PivotTables -- Chapter 7: Performing PivotTable Calculations -- Chapter 8: Building PivotCharts -- Part 3: Discovering Advanced Data-Analysis Tools -- Chapter 9: Dealing with Data Models -- Chapter 10: Tracking Trends and Making Forecasts -- Chapter 11: Analyzing Data Using Statistics -- Chapter 12: Analyzing Data Using Descriptive Statistics -- Chapter 13: Analyzing Data Using Inferential Statistics -- Part 4: The Part of Tens -- Chapter 14: Ten Things You Ought to Know about Statistics -- Chapter 15: Ten Ways to Analyze Financial Data -- Chapter 16: Ten Ways to Raise Your PivotTable Game -- Appendix: Glossary of Data Analysis and Excel Terms -- Index.

Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers Clean up large datasets and identify statistical operations that will answer your questions Perform financial calculations, database operations, and more--without leaving Excel Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.