Excel Functions are one of the most important features in Excel.

This is must learn Excel formulas to make best out of this best spreadsheet tool on the planet.

This section is purely dedicated to the useful Excel functions.

You can learn these Excel functions with examples & download sample files for your better understanding.

This comprehensive list of 101 Excel functions will help you to drive your Excel skills to the next level. You can learn each of them with real life examples.

I have integrated these formulas in the categories so that you can learn them in the way your want.

## TEXT | |

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

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

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

LOWER | Convert text into lower case. |

UPPER | Convert text into upper case. |

PROPER | Convert text into the proper case. |

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

LEN | Count number of character in a cell. |

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

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

## DATE & TIME | |

DATE | Create a valid date. |

DATEDIF | Calculate interval between two dates. |

DATEVALUE | Create a valid date from text. |

EDATE | Return the same date in future or past. |

DAY | Return day number from a date. |

DAYS | Return number of days between two dates. |

TODAY | Return current date. |

MONTH | Return month’s number from a date. |

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

YEAR | Return year’s number from a date. |

TIME | Create a valid time. |

TIMEVALUE | Create a valid time from text. |

HOUR | Return hours from a time value. |

MINUTE | Return minute from a time value. |

SECOND | Return seconds from a time value. |

NOW | Return current date & time. |

WEEKDAY | Return weekday of a given date. |

WEEKNUM | Return week number of a given date. |

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

NETWORKDAYS.INTL | Return the work days between two dates. |

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

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

LOWER | Convert text into lower case. |

UPPER | Convert text into upper case. |

PROPER | Convert text into the proper case. |

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

LEN | Count number of character in a cell. |

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

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

## LOGICAL | |

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

IFERROR | Evalue a value for error & return a specific value if error occurs. |

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

OR | Test two or more conditions differently. |

AND | Test two or more conditions jointly. |

NOT | Convert TRUE into FALSE & FALSE into TRUE. |

FALSE | Return logical FALSE. |

TRUE | Return logical TRUE. |

## MATHS | |

SUM | Sum numeric values. |

SUMIF | Sum numeric values which meet a condition. |

SUMIFS | Sum numeric values which meet multiple conditions. |

SUMPRODUCT | Multiply & Sum Arrays. |

ABS | Convert a number into an absolute number. |

EVEN | Round a number to the nearest even number. |

INT | Round down a number to the nearest integer. |

MOD | Return remainder after dividing two numbers. |

MROUND | Round to the nearest multiple of a number. |

TRUNC | Remove fractional part of a number. |

RAND | Generate Random Numbers. |

## STATISTICAL | |

COUNT | Return the count cells which have numbers. |

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

COUNTBLANK | Return the count of cells which are blank. |

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

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

AVERAGE | Return average of numbers. |

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

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

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

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

MIN | Return smallest values from a given set of values. |

## LOOKUP | |

ADDRESS | Create a cell address. |

AREAS | Return a number of areas in a reference. |

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

COLUMN | Return the column number of the reference. |

COLUMNS | Return the number of columns in a range. |

FORMULA TEXT | Return formula from a cell as a text. |

HLOOKUP | Lookup for values from a row. |

HYPERLINK | Create an Hyperlink in a cell. |

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

INDIRECT | Create a cell reference from a text. |

LOOKUP | Lookup for a values in a column range. |

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

OFFSET | Create a reference offset from given starting cell. |

ROW | Return the row number of the reference. |

ROWS | Return the number of rows in a range. |

TRANSPOSE | Return the average of numbers. |

VLOOKUP | Lookup for values from a column. |

## FINANCIAL | |

FV | Calculate the future value of an investment. |

PMT | Calculate the periodic payment for a loan. |

PV | Calculate the present value of an investment. |