Excel Data Analysis For Dummies, 2nd Edition

Learn to:

• Navigate and analyze data
• Work with external databases, PivotTables, and PivotCharts
• Use Excel for statistical and financial functions
• Make the most of the latest features of Excel 2013

Want to analyze data? Let Excel do the heavy lifting!

If you’re like most people, you probably don’t take full advantage of Excel’s data analysis tools. This friendly guide walks you through the features of Excel to help you discover the insights in your rough data. From input, to analysis, to visualization, this book shows you how to use Excel to uncover what’s hidden within the numbers.

• The buck stops here — get straightforward guidance on how to put information into Excel workbooks so that you can begin to analyze it
• You oughta know — find must-know, useful tidbits about statistics, analyzing data, and visually presenting data that will make sense of the stuff you’re digging for
• Behold the power — discover the most powerful data analysis tools that Excel provides, its cross-tabulation capabilities PivotTable and PivotChart
• You’re analyzing data, darling — get to know the more sophisticated tools provided by Excel data analysis add-ons, like t-test, z-test, scatter plot, regression, ANOVA, and Fourier

Open the book and find:

• How to make the most of Excel to analyze data
• Insight into the info you’re already working with
• No-sweat descriptions of how to get things done
• Guidance on creating PivotTables and PivotCharts
• Easy explanations of Excel add-ons
• Useful data analysis tips and facts
• A handy glossary of terms
• Fancier tools for those who have mastered the basics

Stephen L. Nelson is an author and CPA who provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He is the author of more than 100 books, includingQuickBooks For Dummies and Quicken For Dummies.