Excel Data Analysis for Dummies

By Stephen L. Nelson and E.C. Nelson

Book Overview

Want to take the guesswork out of analyzing data? Let Excel do all the work for you 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 Once you're up to speed, you can stop worrying about how to make use of all that data you have on your hands and get down to the business of discovering meaningful, actionable insights for your business or organization. Excel is the most popular business intelligence tool in the world, and the newest update - Microsoft Excel 2016 - features even more powerful features for data analysis and visualization. Users can slice and dice their data and create visual presentations that turn otherwise indecipherable reports into easy-to-digest presentations that can quickly and effectively illustrate the key insights you are seeking. Fully updated to cover the latest updates and features of Excel 2016 Learn useful details about statistics, analysis, and visual presentations for your data Features coverage of database and statistics functions, descriptive statistics, inferential statistics, and optimization modeling with Solver Helps anyone who needs insight into how to get things done with data that is unwieldy and difficult to understand With Excel Data Analysis For Dummies, 3rd Edition , you'll soon be quickly and easily performing key analyses that can drive organizational decisions and create competitive advantages.

• Format: Paperback
• Language: English
• ISBN: 1119077206
• ISBN13: 9781119077206
• Release Date: December 2015
• Publisher: For Dummies
• Length: 384 Pages
• Weight: 1.40 lbs.
• Dimensions: 0.7" x 7.3" x 9.2"

Customer Reviews

Excel is a great tool for many applications - Great resource for library to develop skills

Added to Library with other books to help communicate ideas and thoughts to kids. Variety in communicating is a great way to see other angles to help kids figure out how things work. I Love Math - Great Help for kids to learn how to apply them selves in Excel

Excelling at Analysis

The world of mathematical analysis is changing, and for the people involved, doing so at ever younger ages. As a Physics teacher, much of the mathematical modeling or problem solving strategies that come first to a student is something that I might say as a "brute force" method. While not an elegant method sometimes, the computer in general, or graphing calculators in particular are able to handle the demands of a student's "brute force" method of problem attack. While the elegance of some mathematics takes considerable practice, and perhaps intuition, it has been this feature that has kept many people from the "hard sciences", and engineering. Or, so I would suggest having taught both in secondary and post-secondary. Technology has changed all of this, but it would seem that the full impact of this will take some time to be felt by everyone. This book sees to much of the analysis possible with the Excel spreadsheet. There are enormous sections that are easily understood by High School students, and with a little coaching can be used to work with experimental data. The laboratory work that many students are able to produce is of exceptional quality, and gratifying to experience. On the flip side of this same coin is the ability of teachers to quickly check results, and look at the quality of data used. Material is easily understood, and with functions explained in layperson terminology, the book accomplishes not simply the how, but the why as well. I would recommend that this book is purchased by anyone who can help students learn how to use a spreadsheet. Currently, I am considering the other Excel spreadsheet books on closely allied areas, and hope that they are as well written, and organized as this book.

New tricks for an old dog

I've been using Excel for years, but I've always been frustrated by the more advanced stuff in Excel. Things like pivot tables and pivot charts, or the super-powerful but mega-confusing VLOOKUP function. Sometimes I'd get lucky and figure out how to get one of these things to work, but most times I'd have to ask a co-worker to figure it out for me.Now, I'm starting to be the guy that folks are coming to for help with advanced Excel stuff. This book is fantastic, and for the first time I'm starting to really use Excel for something more advanced than the Sum button!Here's the table of contents from my copy of the book. Some of the chapters might sound intimidating, but believe me, this book is fun and easy to read:Part I: Where's the Beef? Chapter 1: Introducing Excel Lists. 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 List Results and Analyzing Data. Chapter 15: Ten Tips for Visually Analyzing and Presenting Data. Part V: Appendix. Appendix: Glossary of Data Analysis and Excel Terms.