Excel Data Analysis For Dummies, 2nd Edition

Book Description

What the book covers: 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, using the Small Business Finance Manager, and more.Updated coverage of the new version: A technology update to the existing edition for Excel 2013. This new edition will have approximately 30% new content covering the latest updates and enhancements made to Microsoft Excel.Series features: Information presented in the straightforward but fun language that has defined the "Dummies" series.

Table of contents

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

About The Author

E. C. Nelson

Elizabeth C. Nelson is an accountant for a local public accounting firm in Seattle, Washington and formerly the treasurer of a nonprofit corporation. She publishes two popular high-traffic small business websites and holds a Bachelor of Science in Accounting from Western Governors University.

Stephen L. Nelson

Stephen L. Nelson is the author of more than two dozen best-selling books, including Quicken For Dummies and QuickBooks For Dummies (John Wiley & Sons, Inc.). A certified public accountant, he holds a Masters in Business Administration in Finance from the University of Washington and a Master of Science in Taxation from Golden Gate University.