Excel 2007 Data Analysis For Dummies

This handy guide helps you analyze the information you work with in your job to make better decisions. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

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.

This book isn’t meant to be read cover to cover like a Dan Brown page-turner. Rather, it’s organized into tiny, no-sweat descriptions of how to do the things that must be done. Hop around and read the chapters that interest you.

TABLE OF CONTENT:
Chapter 01 - Introducing Excel Tables
Chapter 02 - Grabbing Data from External Sources
Chapter 03 - Scrub-a-Dub-Dub
Chapter 04 - Working with PivotTables
Chapter 05 - Building PivotTable Formulas
Chapter 06 - Working with PivotCharts
Chapter 07 - Customizing PivotCharts
Chapter 08 - Using the Database Functions
Chapter 09 - Using the Statistics Functions
Chapter 10 - Descriptive Statistics
Chapter 11 - Inferential Statistics
Chapter 12 - Optimization Modeling with Solver
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

Download here

Password:knowfree.net