📊 Included! 100 Excel Recipes to Know

It's practical in ✨. Save it. 💚

📊 Basic Math

1. = SUM (A1: A10) Total Number Sum

2. = AVERAGE (A1: A10) Average

3. = MIN (A1: A10) Find the minimum value

4. = MAX (A1: A10) Find the maximum value

5. = COUNT (A1: A10) numerical cell count

6. = COUNTA (A1: A10) Count busy cells

7. = COUNTBLANK (A1: A10) CLOSE COLLECTION

8. = ROUND (A1,2) rounded to a given number of digits

9. = ROUNDUP (A1,0) Always round up

10. = ROUNDDOWN (A1,0) Always swipe down.

🔍 Conditions Category (Logical)

11. = IF (A1 > 50, "" Pass, "" Not Pass ") Set a condition. If true, display a value A. If false, display a value B.

12. = IFS (A1 > = 80, "A," A1 > = 70, "B") Multiple conditions in one formula

13. = AND (A1 > 50, B1 > 50) All conditions must be true.

14. = OR (A1 > 50, B1 > 50) At least 1 condition is true.

15. = NOT (A1 > 50) REVERSE TRUE TO FALSE

16. = IFERROR (A1 / B1, "Error") If an Error occurs, show the given value.

17. = IFNA (A1 / B1, "Not found") if# N/ A Show the given value.

18. = SWITCH (A1,1, "One," 2, "Two") Select the value according to the given choice.

19. = XOR (A1 > 0, B1 > 0) is true when only one condition is true.

20. = ISBLANK (A1) Check if the cell is empty.

🔢. The platoon counts conditionally.

21. = COUNTIF (A1: A10, "Yes") Count by 1 Condition

22. = COUNTIFS (A1: A10, "Yes," B1: B10, "> 50") Count multiple conditions

23. = SUMIF (A1: A10, "Yes," B1: B10) Includes according to 1 condition.

24. = SUMIFS (B1: B10, A1: A10, "Yes") Includes multiple conditions.

25. = AVERAGEIF (A1: A10, "Yes," B1: B10) Average by 1 Condition

26. = AVERAGEIFS (B1: B10, A1: A10, "Yes") Multi-Condition Average

27. = SUMPRODUCT (A1: A10, B1: B10) multiply and then sum (use advanced analysis).

28. = SUBTOTAL (9, A1: A10) Includes filtered data.

29. = AGGREGATE (9,5, A1: A10) Combine advanced cross error.

30. = COUNTIF (A: A, "* text *") Count text with some words.

🔎 Search for Information (Lookup)

31. = VLOOKUP (A1, A1: B10,2, FALSE) Vertical Search

32. = HLOOKUP (A1, A1: B10,2, FALSE) Search Horizontal

33. = XLOOKUP (A1, A1: A10, B1: B10) Advanced Search (instead of the new version of VLOOKUP)

34. = INDEX (A1: B10,2,1) Retrieves the value from the given position.

35. = MATCH (A1, A1: A10,0) Find the location of the data.

36. = INDEX (A1: A10, MATCH (A1, B1: B10,0)) more flexible search VLOOKUP

37. = LOOKUP (A1, A1: A10, B1: B10) Basic Search

38. = FILTER (A1: B10, A1: A10 = "Yes") Filter Conditional Data

39. = SORT (A1: B10,1,1) Sort data

40. = UNIQUE (A1: A10) Remove Unique Data

📝 Text category

41. = LEFT (A1,4) Left text pull

42. = RIGHT (A1,2) Retrieve the message on the right.

43. = MIDs (A1,1,3) pull text in the middle

44. = LEN (A1) count number of letters

45. = TRIM (A1) Delete the excess gap.

46. = UPPER (A1) uppercase

47. = LOWER (A1) Lowercase

48. = PROPER (A1) First capital letter.

49. = CONCAT (A1, B1) Includes text.

50. = TEXTJOIN ("," TRUE, A1: A5) Includes multi-cell text.

📅 Date and time category

51. = TODAY () Today's date

52. = NOW () Current date and time.

53. = DATE (2026,2,26) Create date

54. = DAY (A1) pull date

55. = MONTH (A1) pull month

56. = YEAR (A1) pull year

57. = DATEDIF (A1, B1, "Y") Find the difference in days / years.

58. = EOMONTH (A1,1) End of month

59. = WORKDAY (A1,5) NEXT WORKING DAYS

60. = NETWORKDAYS (A1, B1) Work Day Count

📊 Financial category

61. = PMT (rate, nper, pv) Calculate installments

62. = FV (rate, nper, pv) future value.

63. = PV (rate, nper, pmt) present value

64. = NPV (rate, value 1, value 2) net present value.

65. = IRR (A1: A10) Yield

66. = RATE (nper, pmt, pv) interest rate

67. = SLN (cost, salvage, life) linear depreciation.

68. = DB (cost, salvage, life, period) decreasing depreciation.

69. = CUMIPMT (rate, nper, pv, 1,12,0) Cumulative interest.

70. = CUMPRINC (rate, nper, pv, 1,12,0) Cumulative principal

🧮 Advanced category

71. = OFFSET (A1,1,1) Promoted Reference

72. = INDIRECT ("A1") Cites from text.

73. = TRANSPOSE (A1: A10) Toggle rows to columns.

74. = CHOOSE (1, "A," "B") Choose the value in order.

75. = SEQUENCE (10) Create a numerical sequence.

76. = RAND () random decimal number

77. = RANDBETWEEN (1,100) Random Numbers Nominal Range

78. = ABS (A1) Absolute value

79. = MOD (A1,2) takes the remainder from division.

80. = POWER (A1,2) to the power.

📈 Statistics category

81. = MEDIAN (A1: A10) MEDIUM

82. = MODE.SNGL (A1: A10) Most repeated value

83. = STDEV.S (A1: A10) Standard deviation

84. = VAR.S (A1: A10) variance

85. = PERCENTILE (A1: A10,0.9) percentile

86. = QUARTILE (A1: A10,1) QUARTILE

87. = CORREL (A1: A10, B1: B10) Relationship between data sets.

88. = RANK (A1, A1: A10) Rated

89. = FREQUENCY (A1: A10, B1: B5) Distributed frequency

90. = FORECAST (A1, B1: B10, C1: C10) Forecast Value

🏢 Recipes are often used in the office.

91. = TEXT (A1, "dd / mm / yyyy") Transform numbers into text format.

92. = REPLACE (A1,1,3, "XXX") replaces some text.

93. = SUBSTITUTE (A1, "old," "new") Change words in text.

94. = CLEAN (A1) Remove strange characters.

95. = EXACT (A1, B1) Compare straight letters.

96. = ISNUMBER (A1) Check it as a number.

97. = ISTEXT (A1) Verify that it is a message.

98. = ISERROR (A1) detect an error.

99. = HYPERLINK ("http://example.com," "Click") Create a link.

100. = CELL ("filename") Retrieve Cell Properties