Excel Functions

Excel Functions

Excel Functions

# Excel Functions | Microsoft Excel XP

Learn all about Excel functions with step-by-step on how to use a function, enter functions manually and how to modify them.

 What's on this page... Using Functions in your Formulas Entering Functions Manually Modifying a range reference used in a function Using the Insert Function command

#### Using Functions In Your Formulas

Excel provides more than 300 built-in functions that can make your formulas perform powerful feats and save you a great deal of time.

## Excel Functions can do the following:

 ♦ Simplify your formulas ♦ Allow formulas to perform calculations that are otherwise impossible. ♦ Allow conditional execution of formulas given them some rudimentary decision-making capability.

The following table shows you a list of some of the most popular functions.

Why not all?

Remember that Excel has more than 300 ready-made functions for all purposes, from math to engineering, from financial to statistical (and more). Take a look at the Help files in Excel for an explanation of all the functions.

(Did you know that COSH returns the hyperbolic cosine of a number? Most humans don't need to do that, whatever it is but someone, somewhere is very happy that Excel can handle hyperbolic cosines!)

 Function Action =SUM() The sum of the values. Used in simple mathematics. =COUNT() The number of non-blank cells in a range. =COUNTBLANK() The number of blank cells in a range. =AVERAGE() The average of the values in a range. =MAX() The largest value in a range of cells. =MIN() The smallest value in a range of cells. =PRODUCT() The product of the values in a range of cells. =STDDEV() An estimate of the standard deviation of a population, where the sample is all the data to be summarized. =STDDEVP() The standard deviation of a population, where the population is all the data to be summarized. =VAR() An estimate of the variance of a population, where the sample is all the data to be summarized. =VARP() The variance of a population, where the population is all the data to be summarized.
###### Excel XP Topics
- Tips
- Excel Screen Layout
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Sorting
- AutoFilter