Excel Data Analysis For Dummies, 2nd Edition (2014)

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