Using formulas


show more Using formulas provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Using formulas

A spreadsheet application like Numbers '09 is all about performing calculations. So let's explore some of the shortcut techniques for adding formulas that perform simple calculations. We will use our Running Club Data spreadsheet. And we'll start with something called instant calculations. Let's say we want to total up the kilometers for each of the members in our Running Club and display them in the Total Distance row at the bottom of the table. First we need to select the cells to be used in the calculation. Let's start with Emily. We'll click-and-drag across those values. And now as we glance through the bottom left corner of our window under the Styles pane, we see some quick calculations are being performed. One of them is the Sum or Total, which is 626.

If you want to use one of these calculations in your table, you simply drag it from the bottom left corner to the cell where you want to display the answer, in this case B11, and release. And there is our fo...

Using formulas
Video duration: 3m 47s 3h 53m Beginner

Viewers:

Using formulas provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...