I'd now like to sum up the total cost per course, so I could start typing it in, I press equals, and then sum open parenthesis, and then I select the cells I want to include in my sum close parenthesis press enter. Great, I've got that number. However, there are some really great keyboard shortcuts that would help you out here and speed you up. So I'm going to delete that out and I make sure I don't have the mouse blinking in the formula bar.

I can press alt equals or alt shift equals depending on how your keyboard is set up. They're just for Windows computers. If you are on a Mac, you can press command shift T, and it will do exactly the same thing. I can then click on the handle, click and drag that to the right. I've got my totals for course one and two. However, my boss has just emailed me and said that they'd really like to know the total course leadership costs, the total teaching assistant cost, so let's add a total column.

Again, I could type in equal sum and then select with my mouse.

But again, my shortcuts work. The same ones I could use alt equals or alt shift equals, or command shift T if I'm on a Mac. Then grab that handle, drag it down to the bottom.

Fantastic. We've now found the cost of the entire training course. It's going to be 1,402,000.