Book Details :
LanguageEnglish
Pages363
FormatPDF
Size24.4 MB

# Excel Data Analysis For Dummies 2nd Edition

Excel Data Analysis For Dummies 2nd Edition by Stephen L. Nelson, MBA, CPA and E. C. Nelson | PDF Free Download.

## Excel Data Analysis Contents

• Chapter 1: Introducing Excel Tables
• Chapter 2: Grabbing Data from External Sources
• Chapter 3: Scrub-a-Dub-Dub: Cleaning Data
• Chapter 4: Working with PivotTables
• Chapter 5: Building PivotTable Formulas
• Chapter 6: Working with PivotCharts
• Chapter 7: Customizing PivotCharts
• 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
• 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

## Introduction to Excel Data Analysis For Dummies PDF

So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks and how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But I bet that you sometimes wish that you could do more with Excel.

You sometimes wish, I wager, that you could use Excel to really gain insights into the information, the data, that you work within your job. Using Excel for data analysis is what this book is all about.

This book assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information that you’re already working on within Excel or the information stored electronically in some other format, such as in your accounting system or from your web server’s analytics.

This book isn’t meant to be read cover to cover like a Dan Brown page-turner. Rather, it’s organized into tiny, no-sweat descriptions of how to do the things that must be done.

Hop around and read the chapters that interest you. If you’re the sort of person who, perhaps because of a compulsive bent, needs to read a book cover to cover, that’s fine.

I recommend that you delve into the chapters on inferential statistics, however, only if you’ve taken at least a couple of college-level statistics classes. But that caveat aside feels free. After all, maybe Dancing with the Stars is a rerun tonight.

Part I: Where’s the Beef? In Part I, I discuss how you get data into Excel workbooks so that you can begin to analyze it. This is important stuff, but fortunately, most of it is pretty straightforward.

If you’re new to data analysis and not all that fluent yet in working with Excel, you definitely want to begin in Part I.

Part II: PivotTables and PivotCharts In the second part of this book, I cover what are perhaps the most powerful data analysis tools that Excel provides: its cross-tabulation capabilities using the PivotTable and PivotChart command.

No kidding, I don’t think any Excel data analysis skill is more useful than knowing how to create pivot tables and pivot charts.

If I could, I would give you some sort of guarantee that the time you spent reading how to use these tools is always worth the investment you make. Unfortunately, after consultation with my attorney, I find that this is impossible to do.

Part III: Advanced Tools In Part III, I discuss some of the more sophisticated tools that Excel supplies for doing data analysis. Some of these tools are always available in Excel, such as statistical functions.

(I use a couple of chapters to cover these.) Some of the tools come in the form of Excel add-ins, such as the Data Analysis and the Solver add-ins. I don’t think that these tools are going to be of interest to most readers of this book.

But if you already know how to do all the basic stuff and you have some good statistical and quantitative methods, training, or experience, you ought to peruse these chapters.

Some really useful whistles and bells are available to advanced users of Excel. And it would be a shame if you didn’t at least know what they are and the basic steps that you need to take to use them.

Part IV: The Part of Tens In my mind, perhaps the most clever element that Dan Gookin, the author of the original and first For Dummies book, DOS For Dummies, came up with is the part with chapters that just list information in David Letterman-ish fashion.

These chapters let us authors list useful tidbits, tips, and factoids for you. Excel Data Analysis For Dummies, Second Edition includes three such chapters.

In the first, I provide some basic facts most everybody should know about statistics and statistical analysis. In the second, I suggest ten tips for successfully and effectively analyzing data in Excel.

Finally, in the third chapter, I try to make some useful suggestions about how you can visually analyze information and visually present data analysis results. The Part of Tens chapters isn’t technical. They aren’t complicated. They’re very basic.

You should be able to skim the information provided in these chapters and come away with at least a few nuggets of useful information.

The appendix contains a handy glossary of terms you should understand when working with data in general and Excel specifically. From kurtosis to histograms, these sometimes baffling terms are defined here.