Once you have some basic knowledge of Microsoft Excel, the next thing which you must learn is Excel functions.

Now the question is how can you learn any of these functions in the easiest way?

For this my answer is:

**First** of all, you need to know what's the purpose of a function it's syntax. **Next** thing is to learn some important information about it.

And **in the end**, its usage through a simple example so that you can use it in real life.

To help you on this, I have compiled a list of top 100 Excel functions which you can use in your everyday work.

For example, if you want to learn about IF function, you have a quick intro, syntax description, some additional information and then an example.

In the end, you have links to the relevant sources to learn further. And all the functions are structured in the same way.

...without any further ado here's the list.

Content

1. LEFT Function: It returns specified (by you) characters from the left side of a text string. You can extract characters up to the total length of the text string.

2. RIGHT Function: It returns specified (by you) characters from the right side of a text string. You can extract characters up to the total length of the text string.

3. MID Function: It returns specific characters from a specific position in the text string. You can extract text up to the total length of the text string.

4. LOWER Function: It converts a normal text into a lower case text where you have all the letters in small letters and numbers will be unchanged.

5. UPPER Function: It converts a normal text into an upper case text where you have all the letters in capital letters and numbers will be unchanged.

6. PROPER Function: It converts a normal text into a proper case text where you have the first letter of a word in capital letter and rests all in small and numbers will be unchanged.

7. REPT Function: It repeats the text which you specify the number of times. You just need to specify the text and the repetition number. Its biggest benefit is for creating the in-cell chart.

8. LEN Function: It returns the number of total characters a text string has. You can input a text string directly into the function or simply refer to a cell.

9. FIND Function: It helps to find the starting position of a text string (Case Sensitive) from another text string. You just need to specify the text to find and a text from which you want to find.

10. SEARCH Function: It helps to find the starting position of a text string (Non-Case Sensitive) from another text string. You just need to specify the text to find and a text from which you want to find.

11. DATE Function: It creates a valid date according to Excel's date format. You need to provide day, month and year to create a date.

12. DATEDIF Function: It returns the difference between the start date and end date. It has six different ways to show that difference.

13. DATEVALUE Function: It converts a text date into a valid date according to Excel's date format. You can refer to a cell or you can also enter that text directly into the function.

14. EDATE Function: It gives you a date which is a number of months before or after a specified date. In simple words, you'll get the same date in future or past month like the specific date.

15. DAY Function: It returns the day of the month ranging from 1-31 from the date you specified.

16. DAYS Function: It returns the difference between two dates using four different methods which you can specify.

17. TODAY Function: It gives you current date/today's date as per your system settings. This is a volatile function which changes its values when you recalculate your worksheet.

18. MONTH Function: It returns the month number ranging from 1-12 from the date you specified.

19. EOMONTH Function: It gives you the last date of a month which is a number of months before or after a specified date. In simple words, you'll get the last date of a future month or past month.

20. YEAR Function: It returns the year number from the date you have specified (It should be a valid date).

21. WEEKDAY Function: It returns the day number from the date you have specified ranging from 1-7.

22. WEEKNUM Function: It returns the week number of a specific date. For example, the week containing Jan 1 is the first week of the year and is numbered week 1.

23. NETWORKDAYS Function: It returns the number of working days between the start date and end date which exclude weekends and any dates identified in holidays.

24. NETWORKDAYS.INTL Function: It returns the number of workdays between the start date and end date which exclude weekends and any dates identified and specified holidays.

25. TIME Function: If create a valid time according to Excel's time format. You need to provide hour, minutes, and seconds.

26. TIMEVALUE Function: It converts a text time value into a valid time value according to Excel's time format. You can refer to a cell or you can also enter that text directly into the function.

27. HOUR Function: It returns the hour value (ignores minutes and seconds) from a time value ranging from 0-23 hours.

28. MINUTE Function: It returns the minute value (ignores hour and seconds) from a time value ranging from 0-59 minutes.

29. SECOND Function: It returns the seconds' value (ignores hours and minutes) from a time value ranging from 0-59 seconds.

30. NOW Function: It gives you current date and time as per your system settings. This is a volatile function which changes its values when you recalculate your worksheet.

31. IF Function: You can provide a condition to check and it returns a specific value if that condition is TRUE and another value if that condition is FALSE.

32. IFERROR Function: It evaluates a value for an error and returns a specific value if an error occurs.

33. IFNA Function: It evaluates a value for #N/A error and returns a specific value if an error occurs.

34. OR Function: Test two or more conditions differently and return TRUE if any of those conditions is TRUE and FALSE if all those conditions are FALSE.

35. AND Function: Test two or more conditions jointly and return TRUE if all of those conditions is TRUE and FALSE if any of those conditions is FALSE.

36. NOT Function: It converts a TRUE into FALSE and FALSE into TRUE.

37. FALSE Function: It returns the logical value TRUE in the cell where you insert it.

38. TRUE Function: It returns the logical value FALSE in the cell where you insert it.

39. SUM Function: It adds values. It can add individual values, cell references or ranges or a mix of all three.

40. SUMIF Function: It returns the sum of the numeric values of which meet a condition. You need to specify a condition and the range to check that condition.

41. SUMIFS Function: It returns the sum of the numeric values of which meet multiple conditions. You need to specify conditions and range to check those conditions.

42. SUMPRODUCT Function: It multiplies values from corresponding cells in the given arrays, and returns the sum of those products. It can take an array without using Ctrl + Shift + Enter.

43. ABS Function: It converts a number into an absolute number. The absolute value of a number is the number without its sign.

44. EVEN Function: It returns a number by rounding it to the nearest even number.

45. INT Function: It returns a number by rounding it to the nearest to the nearest integer.

46. MOD Function: It returns remainder after dividing two numbers, not the result of the division of two numbers.

47. MROUND Function: It rounds a number to the nearest multiple of a number without considering that number is greater or lower than the original number.

48. TRUNC Function: It truncates a number to an integer by removing the fractional part of the number. In simple word, it returns on integer part from a value.

49. RAND Function: It returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.

50. COUNT Function: It counts the number of cells which contain numbers, and counts the numbers which are specified in the arguments.

51. COUNTA Function: It counts all the cells which are not empty. It doesn't matter which type of value is there in a cell, it counts all the cell with values in it.

52. COUNTBLANK Function: It counts all the cells which are empty/blank, but if a cell has a blank space it will not count it.

53. COUNTIF Function: It counts the number of cells which meet a criterion. You need to specify a criterion and a range of cell to check that criterion.

54. COUNTIFS Function: It counts the number of cells which meet criteria. You need to specify criteria and ranges to check those criteria.

55. AVERAGE Function: It returns the average (arithmetic mean) of the arguments. You can refer to a range of cells or insert numbers inside the function.

56. AVERAGEA Function: It returns the average (arithmetic mean) of a group of numbers and text. You can refer to a range of cells or insert numbers inside the function.

57. AVERAGEIF Function: It averages the number of cells which meet a criterion. You need to specify a criterion and a range of cell to check that criterion.

58. AVERAGEIFS Function: It averages the number of cells which meet criteria. You need to specify criteria and ranges to check those criteria.

59. MAX Function: It returns the largest value in a set of values. You can refer to a range or insert values directly into the function as well.

60. MIN Function: It returns the smallest value in a set of values. You can refer to a range or insert values directly into the function as well.

61. ADDRESS Function: It returns the address of a cell in a worksheet, given specified row and column numbers.

62. AREAS Function: It returns the number of areas in a given reference. An area can be a range of contiguous cells or a single cell.

63. CHOOSE Function: It returns a value from a list based on position given.

64. COLUMN Function: It returns the column number of the given reference.

65. COLUMNS Function: It returns the number of columns included in the given reference.

66. FORMULATEXT Function: It returns a formula as a string from the referred cell.

67. HLOOKUP Function: It searches for a value in the top row of a table or an array of values, and returns a value in the same column from a row you specify.

68. HYPERLINK Function: It creates a hyperlink that opens a document stored on a network server, an intranet, or the Internet.

69.INDEX Function: It returns a value from a column or a row based on the position of that value in the column or row.

70. INDIRECT Function: It returns the reference specified by a text string. You need to mention the text and reference style.

71. LOOKUP Function: It helps to lookup for a value from a single column or row.

72. MATCH Function: It returns a number representing the position of a cell in an array. In simple words, you get the position of a cell in from a column or row.

73. OFFSET Function: It creates a reference offset from given starting cell using height and width.

74. ROW Function: It returns the row number of the given reference.

75. ROWS Function: It returns the number of rows included in the given reference.

76. TRANSPOSE Function: It switches row into column and column into rows using Ctrl + Shift + Enter.

77. VLOOKUP Function: It looks up for a value in a column and returns the value from the right of the value that you have found.

78. FV Function: It calculates the future value of an investment which is based on periodic and constant payments and on a constant rate of interest.

79. PMT Function: It calculates loan payment based on fixed monthly payments and constant rate of interest.

80. PV Function: It helps you to determine that an investment is profitable or not. For using PV function, you need a constant interest rate, constant periodic payments.

81. CELL Function: It returns some specific information about a cell. You need to refer to a cell and type of information you need.

82. ERROR.TYPE Function: It returns a number if the referred cell has an error. For each type of error, there is a different number it returns.

83. INFO Function: It returns information about the current operating environment. You can select the type of information you need from the function.

84. ISBLANK Function: It verifies a cell and return TRUE if that cell is blank (no value) and FALSE if that cell is not blank.

85. ISERR Function: It verifies a cell and return TRUE if that cell has an error other than #N/A and FALSE if that cell has any other value.

86. ISERROR Function: It verifies a cell and return TRUE if that cell has an error, otherwise it returns a FALSE.

87. ISEVEN Function: It verifies a cell and return TRUE if that cell has an ever, otherwise it returns a FALSE.

88. ISFORMULA Function: It verifies a cell and return TRUE if that cell has a formula, otherwise it returns a FALSE.

89. ISLOGICAL Function: It verifies a cell and return TRUE if that cell has a logical value, otherwise it returns a FALSE.

90. ISNA Function: It verifies a cell and returns TRUE if that cell has and #N/A error, otherwise it returns a FALSE.

91. ISNONTEXT Function: It verifies a cell and return TRUE if that cell has a non-text value, otherwise it returns a FALSE.

92. ISNUMBER Function: It verifies a cell and return TRUE if that cell has a numeric value, otherwise it returns a FALSE.

93. ISODD Function: It verifies a cell and return TRUE if that cell has an odd number, otherwise it returns a FALSE.

94. ISREF Function: It verifies a cell and return TRUE if that cell has a reference, otherwise it returns a FALSE.

95. ISTEXT Function: It verifies a cell and return TRUE if that cell has a text value, otherwise it returns a FALSE.

96. N Function: It converts a logical value into a number. 1 for TRUE and 0 for FALSE.

85. ISERR Function: It verifies a cell and return TRUE if that cell has an error other than #N/A and FALSE if that cell has any other value.

97. NA Function: It returns an #N/A in the cell where you enter it.

98. SHEET Function: It returns the worksheet number of the reference.

99. SHEETS Function: It returns the number of sheets in a reference.

100. TYPE Function: It returns a number representing a value type. When you refer a cell in this function, it verifies the value and returns a number to present it.