E. C. Nelson & Stephen L. Nelson 
Excel Data Analysis For Dummies 

Harness the power of Excel to discover what your numbers arehiding

Excel Data Analysis For Dummies, 2nd Editionis the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through thebasic and not-so-basic features of Excel to help you discover thegems hidden in your rough data. From input, to analysis, tovisualization, the book walks you through the steps that lead tosuperior data analysis.

Excel is the number-one spreadsheet application, withever-expanding capabilities. If you’re only using it to balance thebooks, you’re missing out on a host of functions that can benefityour business or personal finances by uncovering trends and otherimportant information hidden within the numbers. Excel Data Analysis For Dummies, 2nd Edition eliminates theneed for advanced statistics or analysis courses by allowing you toharness the full power of Excel to do the heavy lifting for you.This 2nd Edition is fully updated to include informationabout Excel’s latest features, making it a your go-to Excel guidefor data analysis. Topics include:
* Working with external databases
* Pivot Tables and Pivot Charts
* Using Excel for statistical and financial functions
* Solver, Small Business Finance Manager, and more

The book also includes a guide to chart types and formatting, and advice on effective visual data presentation. You already havethe data, so you might as well get something great out of it.Excel Data Analysis For Dummies, 2nd Edition isthe key to discovering what your numbers are hiding.

Зміст

Introduction 1

Part I: Where’s the Beef? 7

Chapter 1: Introducing Excel Tables 9

Chapter 2: Grabbing Data from External Sources 31

Chapter 3: Scrub-a-Dub-Dub: Cleaning Data 57

Part II: Pivot Tables and Pivot Charts 79

Chapter 4: Working with Pivot Tables 81

Chapter 5: Building Pivot Table Formulas 107

Chapter 6: Working with Pivot Charts 127

Chapter 7: Customizing Pivot Charts 141

Part III: Advanced Tools 155

Chapter 8: Using the Database Functions 157

Chapter 9: Using the Statistics Functions 177

Chapter 10: Descriptive Statistics 225

Chapter 11: Inferential Statistics 245

Chapter 12: Optimization Modeling with Solver 263

Part IV: The Part of Tens 287

Chapter 13: Ten Things You Ought to Know about Statistics289

Chapter 14: Almost Ten Tips for Presenting Table Results and Analyzing Data 301

Chapter 15: Ten Tips for Visually Analyzing and Presenting Data307

Appendix: Glossary of Data Analysis and Excel Terms 319

Index 329

Про автора

Stephen L. Nelson is an author and CPA who providesaccounting, business advisory, tax planning, and tax preparationservices to small businesses. He is the author of more than 100books, including Quick Books For Dummies and Quicken For Dummies.