Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you've been looking for the list feature in Excel 2007, you can stop. It's not available any more. It's been replaced by a new feature called Excel Tables. Let's see how this works. In order to do this we need some information to work with. I've opened the EatCake Inventories List spreadsheet included, included in your Exercise Files. If you'd like to follow along and do that, please open that file now. You'll see this is a basic list of information, but I'd like to use the table functionality in Excel to really be able to enhance the information that I'm looking at. To do that, you select a cell within the area of the table and go to Insert tab.
In the first group, you'll see the Table grouping of commands, and the Create Table button. By selecting the Create Table button, it's going to automatically default to the information that you have on your spreadsheet. In the dialogue box that pops up, it's going to confirm that we are actually looking at all of the information that's going to be included in your table. You can also see it visually by the rotating neon indicator around the information that's included in your spreadsheet. You'll also want to tell the Create Table command that your table has headers, by making sure that you have the check box selected in the area that I'm pointing to here.
Once you've set that up, you click OK, and your table is created. It's default to the last table style that we were working with, which is blue. If you take a look at the ribbon now, you'll see that we have a new Table Tools tab available for us to look at. This Table Tools tab gives us easy access to some commands that we've already explored, such as removing duplicates, and playing with the table styles. It also allows as to define our own table style options, work with external data so that we could import this information and make it real time, as well as doing simple things like re-naming your table. I'm going to rename this table to be InventoryQ1, so that this is distinct from any other tables that we may be working with.
In working with this table, you'll notice that I might have AutoFilter options in all of the column headers in the top row of my table. And if I wanted to sort on it, I can simply click on the downward pointing arrow, select the area that I'm interested in taking a look at, for example Flour-Pastry, and it will sort the information, and just present the information to me that I'm looking at and interested in at the time. If I want to remove that sorting option, I simply click on the sort filter, select all of my options, click OK, and my table is restored.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64848 Viewers
80 Video lessons · 124392 Viewers
52 Video lessons · 60319 Viewers
59 Video lessons · 46142 Viewers