An Introduction to the Excel Formulas and Functions


show more Introducing Excel formulas and functions 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 ...

Introducing Excel formulas and functions

Many Excel commentators, myself included, tend to use the terms function and formula as if they mean the same thing. In fact, functions and formulas are quite distinct. In this lesson, I'll describe the difference between formulas and functions and show you how both workbook elements help you summarize your data. To start out, a formula is a statement you enter into an Excel worksheet's cell that calculates a value. In Excel, you'll always begin a formula by typing an Equal sign. When you do, Excel knows that it should treat the rest of the text you type into the cell as part of a formula.

As an example, if you wanted to type in the formula =1+2 and then press Return, Excel would calculate the value 3. You can also refer to worksheet cells in a formula. In this worksheet, I have values in cells B3 and B4. I'm going to get rid of the formula in cell E2 by pressing the Delete key, and now I'll click in cell B5. If I wanted to find the sum of the two values in B3 and B4, I...

Introducing Excel formulas and functions
Video duration: 3m 17s 6h 32m Beginner

Viewers:

Introducing Excel formulas and functions 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 ...