Excel Functions With Examples

Functions are one of the most important features in Excel and must to learn to make best out of this most popular spreadsheet tool on the planet.

And, for this, I have compiled a list of 101 Excel functions which you can use everyday work to speed up your all the calculations.

This is a comprehensive list in which you will find easy to understand examples and for each example, you can also download sample files to try it yourself.

I have split this list into categories so that you can pick them according to your need.

Text Functions

1. Excel LEFT Function: Get text from the left side of a cell.

2. Excel RIGHT Function: Get text from the right side of a cell.

3. Excel MID Function: ​Get text from a specific position from a text string.

4. Excel LOWER Function: ​Convert a text into lower case.

5. Excel UPPER Function: ​Convert a text into upper case.

6. Excel PROPER Function: ​Convert a text into proper case.

7. Excel REPT Function: ​Repeat a text a number of times.

8. Excel LEN Function: ​Get the numbers of characters in a cell.

9. Excel FIND Function: ​Find a text string from another text string (Case Sensitive).

10. Excel SEARCH Function: ​Search a text string from another text string (Non-Case Sensitive).