How to Use Tables to Sort and Filter Data


show more Using tables to sort and filter data provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 fi...

Using tables to sort and filter data
Video duration: 4m 31s 6h 21m Beginner

Viewers:

Using tables to sort and filter data provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...