Nelson, Stephen L. <br/><br/>
Microsoft excel data analysis for dummies 

 - 3rd 
 - New Delhi  Wiley India Pvt. Ltd.  2018 
 - xiii, 364 p. 
<br/><br/>Table of content<br/><br/>Introduction  <br/><br/> <br/><br/>Part I: Getting Started with Data Analysis<br/><br/>Chapter 1: Introducing Excel Tables  <br/><br/>Chapter 2: Grabbing Data from External Sources<br/><br/>Chapter 3: Scrub-a-Dub-Dub: Cleaning<br/><br/> <br/><br/>Part II: PivotTables and Pivot Charts<br/><br/>Chapter 4: Working with PivotTables<br/><br/>Chapter 5: Building PivotTable Formulas<br/><br/>Chapter 6: Working with Pivot Charts<br/><br/>Chapter 7: Customizing Pivot Charts<br/><br/> <br/><br/>Part III: Advanced Tools<br/><br/>Chapter 8: Using the Database Functions<br/><br/>Chapter 9: Using the Statistics Functions<br/><br/>Chapter 10: Descriptive Statistics<br/><br/>Chapter 11: Inferential Statistics<br/><br/>Chapter 12: Optimization Modeling with Solver<br/><br/> <br/><br/>Part IV: The Part of Tens<br/><br/>Chapter 13: Ten Things You Ought to Know about Statistics  <br/><br/>Chapter 14: Almost Ten Tips for Presenting Table Results and Analyzing Data<br/><br/>Chapter 15: Ten Tips for Visually Analyzing and Presenting Data<br/><br/> <br/><br/>Appendix: Glossary of Data Analysis and Excel Terms<br/><br/>Index 
<br/><br/> Description<br/>Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by uncovering what is behind all of those mind-numbing numbers. The beauty of Excel lies in its functionality as a powerful data analysis tool. This easy-to-read guide will show you how to use Excel in conjunction with external databases, how to fully leverage PivotTables and PivotCharts, tips and tricks for using Excel's statistical and financial functions, how to visually present your data so it makes sense, and information about the fancier, more advanced tools for those who have mastered the basics! 
<br/><br/><label>ISBN: </label>9788126573455 
<br/><br/><label>Subjects--Topical Terms: </label><br/>Microsoft Excel (Computer file)<br/>Electronic spreadsheets<br/>Electronic spreadsheets--Computer programs<br/>Data mining<br/>Quantitative research<br/>Statistics--Computer programs
<br/><br/><label>Dewey Class. No.: </label>005.54  / NEL