Adding a formula to a cell


show more Adding a formula to a cell provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Adding a formula to a cell

Excel is a wonderful tool for storing data about your business. What's even better is that you can create formulas to summarize that data and gain insights into your operations. The most straightforward way to create a formula is to type an Equals sign, followed by the formula. So, for example, if I wanted to find the sum of all the values from cell B3 to B10, I can type equal and then sum. Now note, when I type an S, Excel uses what's called formula Auto Complete to display all of the functions that start with the letter S.

SUM appears in my Most Recently Used list, but you'll see here, under Functions, that there are quite a few other ones that start with S as well. If I type a U, the list is reduced substantially. If you want to select a function name from the list, from the formula Auto Complete list, you can use the down arrow key to highlight the function you want, or you can use your mouse pointer to click the one that you want. When you do, Excel creates your function ...

Adding a formula to a cell
Video duration: 4m 0s 6h 32m Beginner

Viewers:

Adding a formula to a cell provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...