Home :: Contact/FAQ/HOW TO BUY :: IT Books :: Science & Engineering Books :: Business Books :: Search Book :: Promotion & Best Sellers :: Free Download:

KuTenk 2000 - ITOT110119-Excel 2007 Data Analysis For Dummies

Advertisements

by Stephen L. Nelson

2007 (386 pages)

ISBN:9780470045992

From grabbing external data to working with PivotCharts, database functions, and regression analysis, this handy guide shows you step-by-step how Excel can turn raw data into intelligible information.

Table of Contents

Excel 2007 Data Analysis For Dummies
Cheat Sheet—Excel 2007 Data Analysis For Dummies
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