Nelson Steven. Excel 2007 Data Analysis for dummies

Indiana, Wiley Publishing, Inc, 2007. — 381 p.So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks and how to print stuff. And you can even, with just a little bit of fiddling, reate cool-looking charts. But I bet that you sometimes wish that you could do more with Excel. You sometimes wish, I wager, that you could use Excel to really gain insights into
the information, the data, that you work with in your job. Using Excel for data analysis is what this book is all about. This book assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information that you’re already working with in Excel — or the information stored electronically in some other format, such as in your accounting system.About This BookWhat You Can Safely Ignore
What You Shouldn’t Ignore (Unless You’re a Masochist)
Three Foolish Assumptions
How This Book Is Organized
Where’s the Beef?
PivotTables and PivotCharts
Advanced Tools
The Part of Tens
Appendix
Special Icons
Where to Next?
Part I: Where’s the Beef?
Chapter 1: Introducing Excel Tables
What Is a Table and Why Do I Care?
Building Tables
Exporting from a database
Building a table the hard way
Building a table the semi-hard way
Analyzing Table Information
Simple statistics
Sorting table records
Using AutoFilter on a table
Undoing a filter
Turning off filter
Using the custom AutoFilter
Filtering a filtered table
Using advanced filtering