Description
Wiley India Microsoft Excel Data Analysis For Dummies, 3Ed by Stephen L. Nelson, E. C. Nelson
Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by uncovering what is behind all of those mind-numbing numbers. The beauty of Excel lies in its functionality as a powerful data analysis tool. This easy-to-read guide will show you how to use Excel in conjunction with external databases, how to fully leverage PivotTables and PivotCharts, tips and tricks for using Excel's statistical and financial functions, how to visually present your data so it makes sense, and information about the fancier, more advanced tools for those who have mastered the basics!
About the Author
Stephen L. Nelson is an author and CPA. He provides accounting, business advisory, tax planning, and tax preparation services to small businesses such as manufacturers, retailers, professional service firms, and startup technology companies. Steve is the author of more than 100 books, including QuickBooks For Dummies (all editions) and Quicken For Dummies (all editions).
TABLE OF CONTENTS
Introduction
Part I: Getting Started with Data Analysis
Chapter 1: Introducing Excel Tables
Chapter 2: Grabbing Data from External Sources
Chapter 3: Scrub-a-Dub-Dub: Cleaning
Part II: PivotTables and Pivot Charts
Chapter 4: Working with PivotTables
Chapter 5: Building PivotTable Formulas
Chapter 6: Working with Pivot Charts
Chapter 7: Customizing Pivot Charts
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
Index