Excel Functions
 |
 |
 |
 |
 |
 |
 |
Excel Functions
Additional Resources
Excel Functions
Excel Functions | Microsoft Excel XP |
 |
 |
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 Editing Formulas and Functions |
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. |
| Back to Top |
| see also... Enter Functions Manually |
| Modify a Range Reference used in a function |
| Using the Insert Function command | Editing Formulas & Functions |
| Return to Excel XP from Excel Functions |
Excel XP Topics
- Tips- Excel Screen Layout
- Navigational Techniques
- 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
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter