Excel 2007 Data Analysis For Dummies (with source code)
Author(s) : Stephen L. Nelson
Publisher : Wiley
Year : Feb 2007
ISBN 10 : 047004599X
ISBN 13 : 9780470045992
Language : English
Pages : 356
File type : PDF
Size : 7 MB (book + source code)
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:
http://rapidshare.com/files/132993361/exc27datanfodumm.rar
password: ganelon
Posts
