Learning Basic Data-Analysis Techniques
IN THIS CHAPTER
Learning about data analysis
Analyzing data by applying conditional formatting
Adding subtotals to summarize data
Grouping related data
Combining data from multiple worksheets
You are awash in data. Information multiplies around you so fast that you wonder how to make sense of it all. I know, you say, I can paste the data into Excel. That way, you’ve at least got the data nicely arranged in the worksheet cells, and you 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.
This chapter gets you started down that data-analysis path by exploring ...