Excel Data Analysis For Dummies. Paul McFedries

Introduction

      The world is bursting at the seams with data. It’s on our computers, it’s in our networks, it’s on the web. Some days, it seems to be in the very air itself, borne on the wind. But here’s the thing: No one actually cares about data. A collection of data — whether it resides on your PC or some giant server somewhere — is really just a bunch of numbers and text, dates and times. No one cares about data because data doesn’t mean anything. Data isn’t cool. You know what’s cool? Knowledge is cool. Insight is cool.

      So how do you turn data into knowledge? How do you tweak data to generate insight? You need to organize that data, and then you need to sort it, filter it, run calculations on it, and summarize it. In a word, you need to analyze the data.

      Now for the good news: If you have (or can get) that data into Excel, you have a giant basket of data-analysis tools at your disposal. Excel really seems to have been made with data analysis in mind, because it offers such a wide variety of features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. If you can get your data into Excel, it will help you turn that data into knowledge and insight.

      This book takes you on a tour of Excel’s data-analysis tools. You learn everything you need to know to make your data spill its secrets and to uncover your data’s hidden-in-plain-sight wisdom. Best of all, if you already know how to perform the basic Excel chores, you don’t need to learn any other fancy-schmancy Excel techniques to get started in data analysis. Sweet? You bet.

About This Book

      This book contains 16 chapters (and a bonus appendix), but that doesn’t mean that you have to, as the King says gravely in Alice’s Adventures in Wonderland, “Begin at the beginning and go on till you come to the end: Then stop.” If you’ve done a bit of data-analysis work in the past, please feel free to dip into the book wherever it strikes your fancy. The chapters all present their data-analysis info and techniques in readily digestible, bite-sized chunks, so you can certainly graze your way through this book.

However, if you’re brand spanking new to data analysis — particularly if you’re not even sure what data analysis even is — no problem: I’m here to help. To get your data-analysis education off to a solid start, I highly recommend reading the book’s first three chapters to get some of the basics down cold. From there, you can travel to more advanced territory, safe in the knowledge that you’ve got some survival skills to fall back on.

What You Can Safely

---

Скачать книгу