TY - BOOK AU - Nelson, Stephen L., author. TI - Microsoft Office Excel 2007 data analysis for dummies SN - 9780470045992 AV - CIR HF 5548.4 N45 2007 U1 - CIR 005.1 20 PY - 2007/// CY - Hoboken, N.J. : PB - Wiley KW - Microsoft Excel (Computer file) KW - Electronic spreadsheets. N1 - Includes index; xx, 356 pages : illustrations ; 24 cm. Contents: 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. Part V: Appendix. Glossary of Data Analysis and Excel Terms. Index N2 - Provides instructions on using Excel to turn raw data into useful information, covering such topics as Pivot Charts, regression analysis, and database functions ER -