Using functions


show more Using functions 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 functions

Although we can type functions ourselves into the Formula Editor or Formula Bar, the new Function Browser offers a convenient and helpful way to add a function to a formula. Let's use our Energy Saving Plan spreadsheet. On the Energy Saver sheet we have two tables. The second table titled Count by Yearly Savings is going to count the number of energy savers based on yearly savings amounts. So the first step is to select the cell where we want to enter the formula. In this case, cell C2 of our Count by Yearly Savings table.

Now to insert the function, we'll use the Function Browser. We can access it a number of different ways from the View menu or from the Toolbar, click the Function button and choose Show Function Browser. This opens up the Function Browser in its own window, this window can be moved around. It can be resized to display more or less information. On the left-hand side you will see the different Function categories, you can choose from. And on the right-hand side...

Using functions
Video duration: 4m 15s 3h 53m Beginner

Viewers:

Using functions 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 ...