In this screencast, I'm going to make reference to a couple of really nice tools that are in some of the more recent versions of Excel, Excel 2016, 2019 and Office 365. In particular, I'm going to be emphasizing the quick analysis tool that is in Excel. I've got this file Practice Numbers.xlsx shown here. You notice that if you make a selection here, some of you may have been wondering what this little tool, this little icon in the lower right is. That's the quick analysis tool and so I can go ahead and click on that. It essentially has all these different suggestions for that set of data. If you hover over with your cursor, it suggests some data bars, a color scale, some icon sets and so on. So this is basically conditional formatting. You can also go in here and it's going to recommend some charts. So maybe you want to put in some bar charts, some line charts and so on, so you can kind of play around with this. It's also got totals. If I go to totals here and I hover over some, it's going to sum the columns. These first ones are column wise so it's going to add a new row with the sums of the columns, the averages of the columns, the counts percent total and so on. If you click to the right, it's got row-wise summing and averaging, counting, percent total and so on. It also recommends tables here. So if you wanted to create a table, then you can. I'll be explaining more about this in week 3 of the course. And then there's these things known as sparklines that I'll quickly cover in week 4. But you can put in sparklines that kind of show the trend of each row. You can make that as a column plots as well. Another way in which Excel is quite smart is if you have a bunch of data on a worksheet. So I'm working here with a file called State data.xlsx that you can go ahead and download and work through with me. If you go up to the Home tab, make sure you're on the Home tab and you go all the way over here to the right. I think you have to make sure that your cursor is somewhere in the data that you're trying to look at. It's got some ideas up here. So if you click on ideas, it brings up this. It's actually is scanning through the data and it is coming up with some suggestions for different plots. It recommends or suggest different types of charts. We can go here to show all 14 results. It's suggesting here a correlation between population and area. So I'm going to go ahead and click on insert chart and it puts that into our worksheet. And you can, if you want, you can kind of look through some more of these. I'm going to go ahead and close the ideas, but it's suggesting that the population and area are highly correlated. And if you want, you could change the name, the title of this. But bottom line if you've got some data in there and you want Excel to kind of look through it for correlations and recommend different plots, then you can. So this is fairly new in the most recent versions of Excel. Another way that Excel is smart that I've already gone over is auto fill and fill series, so you can go ahead and check out that screencast if you'd like. Thanks for watching.