000 02654nam a22002777a 4500
999 _c1785
_d1785
005 20220208132600.0
008 220208b ||||| |||| 00| 0 eng d
020 _a9788126573455
082 _a005.54
_bNEL
100 _aNelson, Stephen L.
_94701
245 _aMicrosoft excel data analysis for dummies
250 _a3rd
260 _bWiley India Pvt. Ltd.
_aNew Delhi
_c2018
300 _axiii, 364 p.
365 _aINR
_b599.00
504 _aTable of content Introduction Part I: Getting Started with Data Analysis Chapter 1: Introducing Excel Tables Chapter 2: Grabbing Data from External Sources Chapter 3: Scrub-a-Dub-Dub: Cleaning Part II: PivotTables and Pivot Charts Chapter 4: Working with PivotTables Chapter 5: Building PivotTable Formulas Chapter 6: Working with Pivot Charts Chapter 7: Customizing Pivot Charts 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 Index
520 _aDescription 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!
650 _aMicrosoft Excel (Computer file)
_9850
650 _aElectronic spreadsheets
_91039
650 _aElectronic spreadsheets--Computer programs
_91613
650 _aData mining
_9365
650 _aQuantitative research
_95213
650 _aStatistics--Computer programs
_91514
700 _aNelson, Elizabeth C.
_95214
942 _2ddc
_cBK