Discover what you can learn about Excel, including tools to manage and extract data. Data analytics is a hot growth area, explore how Excel can help you transform plain data into something to talk about.
(upbeat music) - When you work with large lists in Excel, you need tools to manage your data and extract the most important information from those lists. And Excel has a variety of features, specifically designed for these purposes. I'll start with structuring your data, convert lists into tables, to sort data, view just the info you need with filtering and slicers. To insert subtotals into lists, delete duplicate data, and gather valuable information, using various statistical functions. - Data Analytics is one of the hottest growth areas, in business. And it's a key opportunity, for those looking to develop their career. Our goal is to take this massive data and look at just one variable we care about. Whether spending additional money, on training our sales team, provides additional sales results. This regression, gives us a point estimate, for that investment. We get $1 and 57 cents of additional sales, for every dollar that we spend on training our sales team. This is an example of how we can use the power of regression to make relevant predictions for our firm. - Data is pointless, if we can't understand it and put it to good use. Fortunately, Microsoft Excel can help us take plain old data and analyze it. We're just using the software, to get to the heart of our data. We'll also take a look at how to organize and describe data, while using Excel's functions, graphics and statistical capabilities. Once we're done describing the data, we'll look at how to analyze data and make decisions on what we find. - So I have a rule of thumb that I call the 10 second rule, which basically means, that if a viewer can't interpret the story within 10 seconds it's time to simplify. You may have noticed, that we're plotting average temperatures here, by city, by month and that certain cities follow one pattern, while others follow another. But realistically, 10 seconds is not a lot of time to understand and digest that information. So now what I'm going to do is show you, a different visualization, built from the exact same data set, as you can see here, by applying some database techniques like custom formatting, and using intuitive color scales, and by actually eliminating the wrong data points. We can draw attention to the story at hand, which is the relative trend and pattern that we see at the city level. - Charts and graphs, let you summarize your data visually. A histogram is a column chart, that indicates the number of values, that fall into a number of bins or value ranges. If I want to create a histogram, again, to summarize using columns based on value ranges, I can select any cell and the data range, and then on the Insert tab of the ribbon, go to the charts area and I'll click the Insert Statistic Chart button and in the top section, I have histogram. I will click the one on the left and you can see that I have my chart.