Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Win a Trip to New York City to see Monty Python's SPAMALOT!
Excel 2007 Data Analysis For Dummies

Excel 2007 Data Analysis For Dummies


By Stephen L. Nelson, CPA, MBA, MS

ISBN: 978-0-470-04599-2
Format: Paper
Pages: 356 Pages
Pub. Date: February 2007

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Related Websites
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
Bonus Material
Introduction.

Part I: Where’s the Beef?

Chapter 1: Introducing Excel Tables.

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 Table Results and Analyzing Data.

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

Part V: Appendix.

Glossary of Data Analysis and Excel Terms.

Index.

Related Articles
Using Columns and Bars to Compare Items in Excel Charts
Placing Charts in Excel
Rotating a 3-D Excel Chart
Creating a Visual Report in Microsoft Project 2007
Adding an Excel Chart to a Word 2007 Document
Related Titles
Office 2007 For Dummies
Microsoft Office Live For Dummies
Crystal Xcelsius For Dummies
More Microsoft Office 2000 for Windows For Dummies
Excel Charts For Dummies