Table of Contents
Excel is a popular spreadsheet software that offers a wide range of functions to help users organize, analyze, and manipulate data. These functions include mathematical operations such as addition, subtraction, multiplication, and division, as well as statistical functions like average, median, and standard deviation. Excel also has built-in functions for data manipulation, such as sorting, filtering, and merging. Additionally, it offers functions for financial calculations, such as calculating interest and creating financial projections. Other notable functions include charts and graphs for visual representation of data, data validation to ensure accuracy, and macros for automating tasks. Overall, Excel provides a comprehensive set of functions to assist users in efficiently managing and analyzing their data.
Excel Functions
Functions
Excel has many premade formulas, called functions.
Functions are typed by = and the functions name.
For example =SUM
Once you have typed the function name you need to apply it to a range.
For example =SUM(A1:A5)
The range is always inside of parentheses.
| Function | Description |
|---|---|
| =AND | Returns TRUE or FALSE based on two or more conditions |
| =AVERAGE | Calculates the average (arithmetic mean) |
| =AVERAGEIF | Calculates the average of a range based on a TRUE or FALSE condition |
| =AVERAGEIFS | Calculates the average of a range based on one or more TRUE/FALSE conditions |
| =CONCAT | Links together the content of multiple cells |
| =COUNT | Counts cells with numbers in a range |
| =COUNTA | Counts all cells in a range that has values, both numbers and letters |
| =COUNTBLANK | Counts blank cells in a range |
| =COUNTIF | Counts cells as specified |
| =COUNTIFS | Counts cells in a range based on one or more TRUE or FALSE condition |
| =IF | Returns values based on a TRUE or FALSE condition |
| =IFS | Returns values based on one or more TRUE or FALSE conditions |
| =LEFT | Returns values from the left side of a cell |
| =LOWER | Reformats content to lowercase |
| =MAX | Returns the highest value in a range |
| =MEDIAN | Returns the middle value in the data |
| =MIN | Returns the lowest value in a range |
| =MODE | Finds the number seen most times. The function always returns a single number |
| =NPV | The NPV function is used to calculate the Net Present Value (NPV) |
| =OR | Returns TRUE or FALSE based on two or more conditions |
| =RAND | Generates a random number |
| =RIGHT | Returns values from the right side of a cell |
| =STDEV.P | Calculates the Standard Deviation (Std) for the entire population |
| =STDEV.S | Calculates the Standard Deviation (Std) for a sample |
| =SUM | Adds together numbers in a range |
| =SUMIF | Calculates the sum of values in a range based on a TRUE or FALSE condition |
| =SUMIFS | Calculates the sum of a range based on one or more TRUE or FALSE condition |
| =TRIM | Removes irregular spacing, leaving one space between each value |
| =VLOOKUP | Allows vertical searches for values in a table |
| =XOR | Returns TRUE or FALSE based on two or more conditions |