Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90848 Viewers
80 Video lessons · 138041 Viewers
59 Video lessons · 56823 Viewers
52 Video lessons · 70459 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.