Excel  Data Analysis

Excel  Data Analysis

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.

You are awash in data. Information multiplies around you so fast that you wonder how to make sense of it all. You think, “I know what to do. I’ll paste the data into Excel. That way, at least the data will be nicely arranged in the worksheet cells, and I can add a little formatting to make things somewhat palatable.” That’s a fine start, but you’re often called upon to do more with your data than make it merely presentable. Your boss, your customer, or perhaps just your curiosity requires you to divine some inner meaning from the jumble of numbers and text that litter your workbooks. In other words, you need to analyze your data to see what nuggets of understanding you can unearth.


No comments
Post a Comment

    Reading Mode :
    Font Size
    lines height