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 · 64741 Viewers
80 Video lessons · 124337 Viewers
52 Video lessons · 60269 Viewers
59 Video lessons · 46100 Viewers