Microsoft excel data analysis for dummies

By:

Nelson, Stephen L

Contributor(s):

Nelson, Elizabeth C

Material type: Text

TextPublication details: Wiley India Pvt. Ltd. New Delhi 2018Edition: 3rdDescription: xiii, 364 pISBN:

9788126573455

Subject(s):

DDC classification:

005.54 NEL

Summary: Description 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!

List(s) this item appears in: IT & Decision Sciences | Non Fiction

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Copy number	Status	Date due	Barcode
Book	Indian Institute of Management LRC General Stacks	IT & Decisions Sciences	005.54 NEL (Browse shelf(Opens below))	1	Available		001707

Browsing Indian Institute of Management LRC shelves, Shelving location: General Stacks, Collection: IT & Decisions Sciences Close shelf browser (Hides shelf browser)

Previous								Next
Previous	005.54 HYM Microsoft power BI for dummies	005.54 LIO From data to stories:	005.54 NAR Basic computational techniques for data analysis:	005.54 NEL Microsoft excel data analysis for dummies	005.54 QUI Excel 2019 for marketing statistics: a guide to solving practical problems	005.54 SAL Excel statistics: a quick guide	005.54 SHM Data mining for business analytics: concepts, techniques and applications in R	Next

Table 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

Description
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!

There are no comments on this title.

to post a comment.