Excel data analysis for dummies - Stephen L. Nelson

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