Excel Functions Full List Tutorial in PDF
This is a complete alphabetical list of all the Functions in Excel with a description. To see the syntax and a more in depth description, the function is a link to the Microsoft Excel site.
Learning the Excel Functions Full List
Microsoft Excel has various built-in functions that can be used for multiple purposes, such as mathematical calculations, text manipulation, date and time calculations, and many more. Here is a list of some of the most commonly used functions in Excel:
- SUM - calculates the sum of a range of cells
- AVERAGE - calculates the average of a range of cells
- COUNT - counts the number of cells in a range that contain numbers
- MAX - returns the most considerable value in a range of cells
- MIN - returns the smallest value in a range of cells
- IF - performs a logical test and returns a value based on the test's outcome
- VLOOKUP - looks up a value in a table and returns a corresponding value from a different column
- INDEX - returns a value from a table based on a specified row and column number
- MATCH - returns the position of a value in a range of cells
- CONCATENATE - joins two or more text strings together
- ROUND - rounds a number to a specified number of digits
- ROUNDUP - rounds a number up to a limited number of digits
- ROUNDDOWN - rounds a number down to a limited number of digits
- NOW - returns the current date and time
- TODAY - returns the current date
- LEN - returns the number of characters in a text string
- LEFT - returns a specified number of characters from the beginning of a text string
- RIGHT - returns a specified number of characters from the end of a text string
- MID - returns a specified number of characters from a text string, starting at a fixed position
- SUBSTITUTE - replaces a specific text string with another text string
- TRIM - removes spaces from a text string
- UPPER - converts a text string to uppercase
- LOWER - converts a text string to lowercase
- PROPER - capitalize the first letter of each word in a text string
- COS - returns the cosine of an angle
- SIN - returns the sine of an angle
- TAN - returns the tangent of an angle
- PI - returns the value of pi
- SQRT - returns the square root of a number
- MOD - returns the remainder of a division operation
These are just some examples of the many functions that Excel has. Many more functions are available, including advanced financial, statistical, and engineering functions, which can work with data in tables, dates, and times.
| Level : | Beginners |
| Created : | September 20, 2017 |
| Size : | 136.09 KB |
| File type : | |
| Pages : | 13 |
| Author : | westernsydney.edu.au |
| Downloads : | 18407 |
More eBooks
Formulas & Functions in Microsoft Excel
Excel 2016 Basics Math and Functions
Excel 2010: PivotTable, IF & VLookup Functions
Excel Formula & Functions Quick Reference
Excel 2016 - Advanced Functions & Modifying Spreadsheets
Excel 2016 - Intro to Formulas & Basic Functions
