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.
In the previous movie, we created a summary report. By using the Group and Subtotal commands on each individual item category that we found in our table. I also promised you that I would show you how to do that with two clicks. here's how we're going to do that. If you'd like to follow along, please open the EatCake Inventory list3 spreadsheet. This particular spreadsheet has already been sorted under Item Category. Once your spreadsheet is open, select the table by clicking in the table area. You'll then go over to the Subtotal command in your outline group and click it once.
This window is going to be very familiar to us when we were using the Subtotal options in the previous example. And we're going to just confirm that this is the information that we want to subtotal. So we're going to Subtotal at each item category, we're going use the Sum function, we're going to Sum the Final Cost column and we're going to provide subtotals under each of the category's final costs. We're going to replace any current subtotals that we see, and we're going to create a summary at the very end of our table.
By clicking OK, we automatically group the information as well as provide the sum, subtotal columns. So see, it was only two clicks to get exactly where we went to before.
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.