Nelson, Stephen L., author.
Microsoft Office Excel 2007 data analysis for dummies / by Stephen L. Nelson. - Hoboken, N.J. : Wiley , 2007. - xx, 356 pages : illustrations ; 24 cm. - Excel 2007 data analysis for dummies For dummies .
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.
Provides instructions on using Excel to turn raw data into useful information, covering such topics as Pivot Charts, regression analysis, and database functions.
English text.
9780470045992
Microsoft Excel (Computer file).
Electronic spreadsheets.
CIR HF 5548.4 / N45 2007
CIR 005.1 / N337m 2007
Microsoft Office Excel 2007 data analysis for dummies / by Stephen L. Nelson. - Hoboken, N.J. : Wiley , 2007. - xx, 356 pages : illustrations ; 24 cm. - Excel 2007 data analysis for dummies For dummies .
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.
Provides instructions on using Excel to turn raw data into useful information, covering such topics as Pivot Charts, regression analysis, and database functions.
English text.
9780470045992
Microsoft Excel (Computer file).
Electronic spreadsheets.
CIR HF 5548.4 / N45 2007
CIR 005.1 / N337m 2007