Excel Data Analysis for Dummies

Stephen L. Nelson

382 pages, parution le 06/01/2003

Ajouter à une liste

Indisponible

Résumé

Excel spreadsheets are a fact of life. But if you're like most people, you probably don't take full advantage of Excel's data analysis tools. That's where this book comes in. 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.

Contents

Part I : Where's the Beef?

Introducing Excel Lists
Grabbing Data from External Sources
Scrub-a-Dub-Dub: Cleaning Data

Part II : Pitfotfabtes and PivotCharts

Working with PivotTables
Building PivotTable Formulas
Working with PivotCharts
Customizing PivotCharts

Part III : Advanced foots

Using the Database Functions
Using the Statistics Functions
Descriptive Statistics
Inferential Statistics
Optimization Modeling with Solver

Part IV: The Part of Tens

Almost Ten Things You Ought to Know about Statistics
Almost Ten Tips for Presenting List Results and Analyzing Data
Ten Tips for Visually Analyzing and Presenting Data

Part V: Appendix

Appendix: Glossary of Data Analysis and Excel Terms

L'auteur - Stephen L. Nelson

Stephen L. Nelson

is the author of numerous book from Microsoft Press, including the popular Field Guide series and numerous titles in the At Glance series. He has also written several best-selling books on Quicken, in addition to books on Microsoft Money, Microsoft Excel, and other spreadsheet and accounting packages. Steve is a consultant, CPA, and businessman extraordinaire.

Autres livres de Stephen L. Nelson

Analyse de données avec Excel pour les nuls

Découvrir tous les livres de Stephen L. Nelson

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Stephen L. Nelson
Parution	06/01/2003
Nb. de pages	382
Format	18,7 x 23,5
Couverture	Broché
Poids	587g
Intérieur	Noir et Blanc
EAN13	9780764516610
ISBN13	978-0-7645-1661-0