Excel Data Analysis for Dummies (Paperback)

Stephen L. Nelson

  • 出版商: For Dummies
  • 出版日期: 2002-08-09
  • 售價: $1,204
  • 貴賓價: 9.5$1,144
  • 語言: 英文
  • 頁數: 384
  • 裝訂: Paperback
  • ISBN: 0764516612
  • ISBN-13: 9780764516610
  • 相關分類: Excel資料科學





Excel Data Analysis For Dummies is for readers who want to move beyond building simple worksheets and want to begin using Excel to gain valuable insight from their data.
Focuses on the features of Excel that are important to businesses and researchers including: working with external databases, PivotTables and Pivot Charts, using Excel for statistical and financial functions, data sharing, working with Solver, and using the Small Business Finance Manager.
Provides detailed step-by-step instructions on the use of Excel to perform statistical analysis.

Table of Contents


Part I: Where's the Beef?

Chapter 1: Introducing Excel Lists.

Chapter 2: Grabbing Data from External Sources.

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

Part II: PivotTables and PivotCharts.

Chapter 4: Working with PivotTables.

Chapter 5: Building PivotTable Formulas.

Chapter 6: Working with PivotCharts.

Chapter 7: Customizing PivotCharts.

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: Almost Ten Things You Ought to Know about Statistics.

Chapter 14: Almost Ten Tips for Presenting List Results and Analyzing Data.

Chapter 15: Ten Tips for Visually Analyzing and Presenting Data.

Part V: Appendix.

Appendix: Glossary of Data Analysis and Excel Terms.