# Excel Functions (with Live Examples and Videos)

Here you will find a detailed tutorial on 100+ Excel Functions. Each Excel function is covered in detail with Examples and Video.

Excel Functions - Date and Time

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

Excel DATE function can be used when you want to get the date value using the year, month and, day values as the input arguments. | |

Excel DATEVALUE function is best suited for situations when a date is stored as text. This function converts the date from text format to a serial number that Excel recognizes as a date. | |

Excel DAY function can be used when you want to get the day value (ranging between 1 to 31) from a specified date. | |

Excel HOUR function can be used when you want to get the HOUR integer value from a specified time value. | |

Excel MINUTE function can be used when you want to get the MINUTE integer value from a specified time value. | |

Excel NETWORKDAYS function can be used when you want to get the number of working days between two given dates. | |

Excel NETWORKDAYS.INTL function can be used when you want to get the number of working days between two given dates. | |

Excel NOW function can be used to get the current date and time value. | |

Excel SECOND function can be used want to get the integer value of the seconds from a specified time value. | |

Excel TODAY function can be used to get the current date. | |

Excel WEEKDAY function can be used to get the day of the week as a number (between 1 to 7) for the specified date. | |

Excel WORKDAY function can be used when you want to get the date after a given number of working days. | |

Excel WORKDAY.INTL function can be used when you want to get the date after a given number of working days. | |

Excel DATEDIF function can be used when you want to calculate the number of years, months, or days between the two specified dates. A good example would be calculating the age. |

Excel Functions - Logical

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

Excel AND function can be used when you want to check multiple conditions. | |

Excel FALSE function returns the logical value FALSE. It does not take any input arguments. | |

Excel IF Function is best suited for situations where you want to evaluate a condition, and the return a value if it is TRUE and another value if it is FALSE. | |

Excel IFERROR function is best-suited to handle formula that evaluates to an error. | |

Excel NOT function can be used when you want to reverse the value of a logical argument (TRUE/FALSE). | |

Excel OR function can be used when you want to check multiple conditions. | |

Excel TRUE function returns the logical value TRUE. It does not take any input arguments. |

Excel Functions - Lookup & Reference

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

Excel COLUMN function can be used when you want to get the column number of a specified cell. | |

Excel COLUMNS function can be used when you want to get the number of columns in a specified range or array. | |

Excel HLOOKUP function is best suited for situations when you are looking for a matching data point in a row, and when the matching data point is found, you go down that column and fetch a value from a cell which is specified | |

Excel INDEX function can be used when you have the position (row number and column number) of a value in a table, and you want to fetch that value. | |

Excel INDIRECT function can be used when you have the references as text and you want to get the values from those references. | |

Excel MATCH function can be used when you want to get the relative position of a lookup value in a list or an array. | |

Excel OFFSET function can be used when you want to get a reference which offsets specified number of rows and columns from the starting point. | |

Excel ROW Function function can be used when you want to get the row number of a cell reference. | |

Excel ROWS Function can be used when you want to get the number of rows in a specified range or array. | |

Excel VLOOKUP function is best suited for situations when you are looking for a matching data point in a column, and when the matching data point is found, you go to the right in that row and fetch a value from a cell which is a specified number of columns to the right. |

Excel Functions - Math

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

Excel INT Function can be used when you want to get the integer portion of a number. | |

Excel MOD function can be used when you want to get the remainder when one number is divided by another. | |

Excel RAND function can be used when you want to generate evenly distributed random numbers between 0 and 1 | |

Excel RANDBETWEEN function can be used when you want to generate evenly distributed random numbers between a top and bottom range specified by the user. | |

Excel ROUND function can be used when you want to return a number rounded to a specified number of digits. | |

Excel SUM function can be used to add all numbers in a range of cells. | |

Excel SUMIF function can be used when you want to add the values in a range if the specified condition is met. | |

Excel SUMIFS function can be used when you want to add the values in a range if multiple specified criteria are met. | |

Excel SUMPRODUCT function can be used when you want to first multiply two or more sets to arrays and then get its sum |

Excel Functions - Statistics

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

Excel RANK function can be used when you want to rank a number against a list of numbers. | |

Excel AVERAGE function can be used when you want to get the average (arithmetic mean) of the specified arguments. | |

Excel AVERAGEIF function can be used when you want to get the average (arithmetic mean) of all the values in a range of cells that meet a given criteria. | |

Excel AVERAGEIFS function can be used when you want to get the average (arithmetic mean) of all the cells in a range that meets multiple criteria. | |

Excel COUNT function can be used to count the number of cells that contain numbers. | |

Excel COUNTA function can be used when you want to count all the cells in a range that are not empty. | |

Excel COUNTBALNK function can be used when you have to count all the empty cells in a range. | |

Excel COUNTIF function can be used when you want to count the number of cells that meet specified criteria. | |

Excel COUNTIFS function can be used when you want to count the number of cells that meet a single or multiple criteria. | |

Excel LARGE function can be used to get the Kth largest value from a range of cells or array. For example, you can get the 3rd largest value from a range of cells. | |

Excel MAX function can be used when you want to get the largest value from a set of values. | |

Excel MIN function can be used when you want to get the smallest value from a set of values. | |

Excel SMALL function can be used to get the Kth smallest value from a range of cells or array. |

Excel Functions - Text Functions

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

Excel CONCATENATE function can be used when you want to join 2 or more characters or strings. | |

Excel FIND function can be used when you want to locate a text string within another text string and find its position | |

Excel LEFT function can be used to extract text from left of the string. | |

Excel LEN function can be used when you want to get the total number of characters in a specified string. | |

Excel LOWER function can be used when you want to convert all uppercase letter in a text string to lowercase. | |

Excel MID function can be used to extract a specified number of characters from a string. | |

Excel PROPER function can be used when you want to capitalize the first character of every word. | |

Excel REPLACE function can be used when you want to replace a part of the text string with another string. | |

Excel REPT function can be used when you want to repeat a specified text for a certain number of times. | |

RIGHT function can be used to extract text from the right of the string. | |

Excel SEARCH function can be used when you want to locate a text string within another text string and find its position. | |

Excel SUBSTITUTE function can be used when you want to substitute text with new specified text in a string. | |

Excel TEXT function can be used when you want to convert a number to text format and display it in a specified format | |

Excel TRIM function can be used when you want to remove leading, trailing, and double spaces in Excel. | |

Excel UPPER function can be used when you want to convert all lowercase letter in a text string to uppercase. |

Excel Functions - Info

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

Excel IS function returns TRUE when specified condition is TRUE. For example, ISNA would return TRUE if the cell has a #N/A! error. |