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.
Description : | Download Microsoft Excel Functions Full List, free PDF file by westernsydney.edu.au. |
Level : | Beginners |
Created : | September 20, 2017 |
Size : | 136.09 KB |
File type : | |
Pages : | 13 |
Author : | westernsydney.edu.au |
Downloads: | 18386 |
Online skills may be learned related to the Excel Functions Full List
Related Excel Functions Full List eBooks
Formulas & Functions in Microsoft ExcelThe Formulas & Functions in Microsoft Excel is a beginner level PDF e-book tutorial or course with 14 pages. It was added on September 20, 2017 and has been downloaded 9045 times. The file size is 109.44 KB. It was created by Theresa A Scott.
Excel 2016 Basics Math and Functions
The Excel 2016 Basics Math and Functions is a beginner level PDF e-book tutorial or course with 25 pages. It was added on September 18, 2017 and has been downloaded 4609 times. The file size is 802.09 KB. It was created by Pandora Rose Cowart .
Excel 2010: PivotTable, IF & VLookup Functions
The Excel 2010: PivotTable, IF & VLookup Functions is an advanced level PDF e-book tutorial or course with 14 pages. It was added on October 19, 2015 and has been downloaded 11512 times. The file size is 522.6 KB. It was created by Kennesaw State University.
Excel Formula & Functions Quick Reference
The Excel Formula & Functions Quick Reference is an advanced level PDF e-book tutorial or course with 8 pages. It was added on September 21, 2017 and has been downloaded 13402 times. The file size is 251.55 KB. It was created by Faye Brockwell.
Excel 2016 - Advanced Functions & Modifying Spreadsheets
The Excel 2016 - Advanced Functions & Modifying Spreadsheets is an advanced level PDF e-book tutorial or course with 24 pages. It was added on September 1, 2016 and has been downloaded 8740 times. The file size is 751.26 KB. It was created by Kennesaw State University.
Excel 2016 - Intro to Formulas & Basic Functions
The Excel 2016 - Intro to Formulas & Basic Functions is an intermediate level PDF e-book tutorial or course with 15 pages. It was added on September 1, 2016 and has been downloaded 13872 times. The file size is 434.9 KB. It was created by Kennesaw State University.
Excel 2013: Intro to Formulas and Basic Functions
The Excel 2013: Intro to Formulas and Basic Functions is an intermediate level PDF e-book tutorial or course with 16 pages. It was added on October 19, 2015 and has been downloaded 13371 times. The file size is 580.01 KB. It was created by Kennesaw State University.
Excel 2013: Advanced Functions and Modifying Spreadsheets
The Excel 2013: Advanced Functions and Modifying Spreadsheets is an advanced level PDF e-book tutorial or course with 26 pages. It was added on October 20, 2015 and has been downloaded 9505 times. The file size is 665.65 KB. It was created by Kennesaw State University.
All right reserved 2011-2024 copyright © computer-pdf.com v5 +1-620-355-1835 - Courses, corrected exercises, tutorials and practical work in IT.
Partner sites PDF Manuales (Spanish) | Cours PDF (French)