Excel^® 2007 Data Analysis For Dummies^®

by Stephen L. Nelson (Redmond, Washington)

• ISBN13: 9780470136782
• ISBN10: 0470136782
• Format: eBook
• Copyright: 2007-05-01
• Publisher: For Dummies

Summary

Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML Provides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more

Table of Contents

Introduction

Where's the Beef?

Introducing Excel Tables

Grabbing Data from External Sources

Scrub-a-Dub-Dub: Cleaning Data

PivotTables and PivotCharts

Working with PivotTables

Building PivotTable Formulas

Working with PivotCharts

Customizing PivotCharts

Advanced Tools

Using the Database Functions

Using the Statistics Functions

Descriptive Statistics

Inferential Statistics

Optimization Modeling with Solver

The Part of Tens

Almost Ten Things You Ought to Know about Statistics

Almost Ten Tips for Presenting Table Results and Analyzing Data

Ten Tips for Visually Analyzing and Presenting Data

Appendix

Glossary of Data Analysis and Excel Terms

Index

Table of Contents provided by Publisher. All Rights Reserved.