What the book covers: Focuses on the features of Excel that are important to businesses and researchers including working with external databases, PivotTables and Pivot Charts, using Excel for statistical and financial functions, data sharing, working with Solver, using the Small Business Finance Manager, and more.Updated coverage of the new version: A technology update to the existing edition for Excel 2013. This new edition will have approximately 30% new content covering the latest updates and enhancements made to Microsoft Excel.Series features: Information presented in the straightforward but fun language that has defined the "Dummies" series.
Table of contents
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: 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 Appendix: Glossary of Data Analysis and Excel Terms
About The Author
E. C. Nelson
Elizabeth C. Nelson is an accountant for a local public accounting firm in Seattle, Washington and formerly the treasurer of a nonprofit corporation. She publishes two popular high-traffic small business websites and holds a Bachelor of Science in Accounting from Western Governors University.
Stephen L. Nelson
Stephen L. Nelson is the author of more than two dozen best-selling books, including Quicken For Dummies and QuickBooks For Dummies (John Wiley & Sons, Inc.). A certified public accountant, he holds a Masters in Business Administration in Finance from the University of Washington and a Master of Science in Taxation from Golden Gate University.