Excel Data Analysis For Dummies, 2nd Edition (2014)
Part I. Where's the Beef?
Chapter 1. Introducing Excel Tables
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. Ten Things You Ought to Know about Statistics
Chapter 14. Almost Ten Tips for Presenting Table Results and Analyzing Data
Chapter 15. Ten Tips for Visually Analyzing and Presenting Data
Appendix. Glossary of Data Analysis and Excel Terms