Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
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.
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.