Excel provides rich set of built in functions. The following are the list of categories of functions.
- Financial Functions
- Logical Functions
- Text Functions
- Date and Time Functions
- Lookup & Reference Functions
- Math Functions
- Statistical Functions
- Information Functions
- Web
- Cube
- Trigonometric
Select the Cell
Goto Function Wizard and select the function
Give values / cells for the parameters.
The following are the web resources gives you detailed information and usage of the functions.
- https://www.wallstreetmojo.com/excel-functions/
- https://www.excelfunctions.net/excel-functions-list.html
- https://www.techonthenet.com/excel/formulas/
- https://www.exceldemy.com/microsoft-excel-formulas-functions-cheat-sheet/ (with examples & Sample Worksheet)
No comments:
Post a Comment