Excel Functions are one of the most important features in Excel. And, this is must to learn them 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 download a sample file to try it yourself.

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

Function | Description |
---|---|

Get text from the left side of a cell. | |

Get text from the right side of a cell. | |

Get text from a specific position from a text string. | |

Convert text into lower case. | |

Convert text into upper case. | |

Convert text into the proper case. | |

Repeat a specific text for a specific number of times. | |

Count number of character in a cell. | |

Find case sensitive text from an another text string. | |

Search non-case sensitive text from an another text string. |

Function | Description |
---|---|

Create a valid date. | |

Calculate interval between two dates. | |

Create a valid date from text. | |

Return the same date in future or past. | |

Return day number from a date. | |

Return number of days between two dates. | |

Return current date. | |

Return month’s number from a date. | |

Return the last date of month in future or past. | |

Return year’s number from a date. |

Function | Description |
---|---|

Create a valid time. | |

Create a valid time from text. | |

Return hours from a time value. | |

Return minute from a time value. | |

Return seconds from a time value. | |

Return current date & time. | |

Return weekday of a given date. | |

Return week number of a given date. | |

Return the number of working days between two date. | |

Return the work days between two dates. |

Function | Description |
---|---|

Perform a specific task if a condition is true or false. | |

Evaluate a value for error & return a specific value if error occurs. | |

Evalueate value for #N/A error & return a specific value if error occurs. | |

Test two or more conditions differently. | |

Test two or more conditions jointly. | |

Convert TRUE into FALSE & FALSE into TRUE. | |

Return logical FALSE. | |

Return logical TRUE. |

Function | Descrription |
---|---|

Sum numeric values. | |

Sum numeric values which meet a condition. | |

Sum numeric values which meet multiple conditions. | |

Multiply and sum arrays. | |

Convert a number into an absolute number. | |

Round a number to the nearest even number. | |

Round down a number to the nearest integer. | |

Return remainder after dividing two numbers. | |

Round to the nearest multiple of a number. | |

Remove fractional part of a number. | |

Generate random numbers. |

Function | Description |
---|---|

Return the count cells which have numbers. | |

Return the count of cells which are non-blank. | |

Return the count of cells which are blank. | |

Return the count of cells which meet criteria. | |

Return the count of cells which meet multiple criteria. | |

Return average of numbers. | |

Return the average of a group of numbers and text. | |

Return the average of numbers which meet criteria. | |

Return the average of numbers which meet multiple criteria. | |

Return largest values from a given set of values. | |

Return smallest values from a given set of values. |

Functions | Header 1 / 2 |
---|---|

Return a number of areas in a reference. | |

Return a number of areas in a reference. | |

Return a value from a list based on position. | |

Return the column number of the reference. | |

Return the number of columns in a range. | |

Return formula from a cell as a text. | |

Lookup for values from a row. | |

Create an Hyperlink in a cell. | |

Return a value from a list or table based on location. | |

Create a cell reference from a text. | |

Lookup for a values in a column range. | |

Return a number representing the position of a cell in an array. | |

Create a reference offset from given starting cell. | |

Return the row number of the reference. | |

Return the number of rows in a range. | |

Return the average of numbers. | |

Lookup for values from a column. |

Function | Description |
---|---|

Calculate the future value of an investment. | |

Calculate the periodic payment for a loan. | |

Calculate the present value of an investment. |

Function | Description |
---|---|

Get cell information | |

Return a number for every error. | |

Return information about current operating environment. | |

Check if a cell is blank. | |

Check if there is any error in the cell other than #N/A. | |

Check if a cell has an error. | |

Check if a cell has a even number. | |

Check if a cell has a has a formula. | |

Check if a cell has a has a logical value. | |

Check if a cell has a has a #N/A value. | |

Check if a cell has a has a non text value. | |

Check if a cell has a has a number. | |

Check if a cell has a has a odd number. | |

Check if a cell has a has a reference. | |

Check if a cell has a has a text value. | |

Convert a logical value into a number. | |

Generate a #N/A error value. | |

Get the sheet number of a worksheet. | |

Get number of sheets in a reference. | |

Get check the type of value from a cell. |

- Inet Kemp
- Puneet Gogia

- Rohit Sharma
- Puneet Gogia

- Gautam Bhardwaj
- Puneet Gogia

- Eanna
- Puneet Gogia

- Torstein S Johnsen
- Puneet Gogia

- Brenda G
- Puneet Gogia

- Diana
- Puneet Gogia

- Srinivasan Venkatraman
- Puneet Gogia

- Angel Gonzalez
- Puneet Gogia

- Asif Hafeez
- Puneet Gogia

- Peter Wilson
- Puneet Gogia

- iyke
- Puneet Gogia

- iyke
- Puneet Gogia
- iyke

- Mohammed Mubin Sayyed
- Puneet Gogia

- Dan Kordelski
- Puneet Gogia

- Heather
- Puneet Gogia

- Bj Sutton
- Puneet Gogia

- rathanak
- ratanak
- Binaya Karmacharya