Home

 

100+ Important functions you should Learn

Select a function below and see a mimimum of 10 examples see data and formulas in action.  if you want to see more added leave a comment.

Mathematical Functions

1. SUM
2. AVERAGE
3. Count
4. COUNTA
5. COUNTIF
6. COUNTIFS
7. SUMIF
8. SUMIFS
9. MIN
10. MAX
11. ABS
12. ROUND
13. ROUNDDOWN
14. ROUNDUP
15. INT
16. MOD
17. SQRT
18. POWER
19. RANDBETWEEN

Statistical Functions

20. MEDIAN
21. MODE
22. STDEV
23. STDEVP
24. VAR
25. VARP
26. QUARTILE
27. PERCENTILE
28. FREQUENCY

Text Functions

29. CONCATENATE (or TEXTJOIN in newer versions)
30. LEFT
31. RIGHT
32. MID
33. LEN
34. TRIM
35. UPPER
36. LOWER
37. PROPER
38. FIND
39. SEARCH
40. SUBSTITUTE
41. TEXT
42. VALUE
43. TEXTSPLIT

Date and Time Functions

44. TODAY
45. NOW
46. DATE
47. TIME
48. YEAR
49. MONTH
50. DAY
51. WEEKDAY
52. EDATE
53. EOMONTH
54. DATEDIF
55. DAYS

Lookup and Reference Functions

56. VLOOKUP
57. HLOOKUP
58. INDEX
59. MATCH
60. OFFSET
61. CHOOSE
62. XLOOKUP 
63. FILTER
64. UNIQUE
65. SORT

Logical Functions

66. IF
67. AND
68. OR
69. NOT
70. IFERROR
71. IFS

Financial Functions

72. PMT
73. FV
74. PV
75. NPV
76. IRR
77. MIRR
78. NPER
79. RATE

Information Functions

80. ISBLANK
81. ISERROR
82. ISTEXT
83. ISNUMBER
84. ISLOGICAL
85. ERROR.TYPE

Array Functions

86. TRANSPOSE
87. SEQUENCE
88. SPILL (Dynamic array)

Engineering Functions

89. CONVERT
90. BIN2DEC
91. DEC2BIN
92. ROMAN

Miscellaneous Functions

93. CHAR
94. CODE
95. N
96. TYPE
97. HYPERLINK
98. ADDRESS
99. CELL
100. INDIRECT
     
     Database Functions
     
     
101. DAVERAGE
102. DCOUNT
103. DCOUNTA
104. DGET
105. DMAX
106. DMIN
107. DPRODUCT
108. DSTDEV
109. DSTDEVP
110. DSUM
111. DVAR
112. DVARP

Extra Learning

SUBTOTAL 

SUMPRODUCT 

SEQUENCE

PRODUCT 

POWER 

ODD 

MROUND 

INT 

FLOOR 

FLOOR.MATH

EVEN 

CEILING 

LET 

CEILING.MATH

TRUNC 

AGGREGATE 

AVERAGE

AVERAGEA
AVERAGEIF

AVERAGEIFS

LARGE

weeknum

yearfrac

datevalue

days360

weekday