From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using tables to sort and filter data - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.