Excel Data Analysis For Dummies, 3rd Edition
By Stephen L. Nelson, E. B. Nelson
Publisher: Wiley / For Dummies
Final Release Date: November 2015
Pages: 384

Learn to:

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

Put the power of Excel to work and excel at data analysis!

Most businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this book shows you how to use it and become a data deciphering expert. You'll learn to organize data in workbooks, create powerful magic with PivotTables and PivotCharts, and explore advanced statistical tools that take you to the next level.

  • Table your data — learn to export data from a database, build a table, get data from external sources, and query databases
  • Keep it clean — delete unnecessary columns and rows in an imported workbook and clean your data with text functions
  • This way and that — see how to view your data from different angles using PivotTables
  • Fine-tune with formulas — build PivotTable formulas to create custom calculations and retrieve data from a PivotTable
  • Chart your course — create and customize PivotCharts to display data in various ways, even in a 3D chart
  • Dive deeper — check out a dozen database functions you can use for more detailed analysis
  • Statistically speaking — explore Excel's statistics functions for finding percentiles and standard deviations, doing regression analysis, and more

Open the book and find:

  • Ways to use filters with tables
  • All about exporting and importing data
  • Essential text functions for cleaning data
  • How to use the PivotTable and PivotChart wizards
  • Tips on customizing a PivotTable
  • When to use Chart Commands
  • Different types of PivotCharts
  • What you can do with descriptive statistics
Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook:  $29.99
Formats:  ePub, Mobi, PDF