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 · 74977 Viewers
80 Video lessons · 129943 Viewers
52 Video lessons · 64126 Viewers
59 Video lessons · 49912 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.