Using tables to sort and filter data

Excel has a feature called tables, which adds some nice features to sorting and filtering.…And if you watched the movie on basic sorting and multiple fields sorting,…I think you'll like some of the features that tables add.…Well, to convert this area to a table, we go to the Insert tab.…Now, this is kind of a misnomer, because we're going to click Table under the…Insert tab, but we're not actually inserting anything.…We're simply taking this whole range of data and converting it to a table.…So click anywhere in here.…It doesn't matter which cell you select.…

Click Table and you see Excel correctly guesses what area we have for our table.…And you want to make sure this box is selected because we do have headers there. And click OK.…Now, scroll up a bit and you see Excel puts in these little down arrows so we…can sort and filter.…As long as you have one of these cells selected, you'll be in the Table Tools…section in the Design tab.…So let's do some sorting and filtering before anything.…Maybe let's go over here to State and click State and we can sort from A to Z or…