O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Advantages of Excel Functions

Functions are tools you can use to analyze data and get information. In other words, functions help answer your questions so that you can evaluate and examine your business and make projections.

Understanding How Functions Work

Excel uses straightforward formulas to perform simple calculations, such as adding or subtracting, on a number or series of numbers. For example, the formula =SUM(B4:B8) inserts the sum of the numbers contained in the range B4 to B8 into the cell containing the formula. These simple formulas are the foundation of many functions. Other functions combine several formulas or procedures to achieve a desired result.

Functions should be entered in the following basic order:

1.
Start a function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required