30/10/2025
â
MS Excel āĻļāĻŋāĻāϤ⧠āĻāĻžāĻāϞ⧠āύāĻŋāĻā§āϰ ⧍ā§ĻāĻāĻŋ āĻā§āϰā§āϤā§āĻŦāĻĒā§āϰā§āĻŖ āĻĢāϰā§āĻŽā§āϞāĻž āĻ
āĻŦāĻļā§āϝāĻ āĻāĻžāύāĻž āĻāĻāĻŋāϤ
1. SUM â āϝā§āĻāĻĢāϞ āĻŦā§āϰ āĻāϰāĻžāϰ āĻāύā§āϝ
=SUM(A1:A10)
2. AVERAGE â āĻā§ āύāĻŋāϰā§āĻŖā§ā§āϰ āĻāύā§āϝ
=AVERAGE(A1:A10)
3. COUNT â āϏāĻāĻā§āϝāĻžāϝā§āĻā§āϤ āϏā§āϞ āĻāĻŖāύāĻžāϰ āĻāύā§āϝ
=COUNT(A1:A10)
4. COUNTA â āĻāĻžāϞāĻŋ āύ⧠āĻāĻŽāύ āϏā§āϞ āĻāĻŖāύāĻžāϰ āĻāύā§āϝ
=COUNTA(A1:A10)
5. IF â āĻļāϰā§āϤ āĻ
āύā§āϝāĻžā§ā§ āĻĢāϞāĻžāĻĢāϞ āĻĒā§āϰāĻĻāϰā§āĻļāύā§āϰ āĻāύā§āϝ
=IF(B2>50,"Pass","Fail")
6. SUMIF â āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻļāϰā§āϤ⧠āϝā§āĻāĻĢāϞ āĻŦā§āϰ āĻāϰāĻžāϰ āĻāύā§āϝ
=SUMIF(A1:A10,">50")
7. COUNTIF â āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻļāϰā§āϤ⧠āϏā§āϞ āĻāĻŖāύāĻžāϰ āĻāύā§āϝ
=COUNTIF(A1:A10,">50")
8. VLOOKUP â āĻā§āĻŦāĻŋāϞ āĻĨā§āĻā§ āĻĄā§āĻāĻž āĻā§āĻāĻāĻžāϰ āĻāύā§āϝ
=VLOOKUP(B2, A1:D10, 3, FALSE)
9. XLOOKUP â āĻāϧā§āύāĻŋāĻ āĻ āĻāύā§āύāϤ Lookup āĻĢāĻžāĻāĻļāύ
=XLOOKUP(B2, A1:A10, B1:B10)
10. INDEX â āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻ
āĻŦāϏā§āĻĨāĻžāύ āĻĨā§āĻā§ āĻŽāĻžāύ āĻāύāĻžāϰ āĻāύā§āϝ
=INDEX(A1:C10, 2, 3)
11. MATCH â āĻā§āύ āĻŽāĻžāύāĻāĻŋ āĻā§āĻŦāĻŋāϞā§āϰ āĻā§āĻĨāĻžā§ āĻāĻā§ āϤāĻž āĻā§āĻāĻā§ āĻŦā§āϰ āĻāϰāϤā§
=MATCH(B2, A1:A10, 0)
12. CONCAT â āĻā§āĻā§āϏāĻ āĻāĻāϤā§āϰ āĻāϰāĻžāϰ āĻāύā§āϝ
=CONCAT(A1, " ", B1)
13. TEXTJOIN â āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻĄā§āϞāĻŋāĻŽāĻŋāĻāĻžāϰ āĻĻāĻŋā§ā§ āĻā§āĻā§āϏāĻ āϝā§āĻā§āϤ āĻāϰāϤā§
=TEXTJOIN("-", TRUE, A1:A3)
14. TRIM â āĻ
āϤāĻŋāϰāĻŋāĻā§āϤ āϏā§āĻĒā§āϏ āϏāϰāĻžāύā§āϰ āĻāύā§āϝ
=TRIM(A1)
15. PROPER â āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻļāĻŦā§āĻĻā§āϰ āĻĒā§āϰāĻĨāĻŽ āĻ
āĻā§āώāϰ āĻā§āϝāĻžāĻĒāĻŋāĻāĻžāϞ āĻāϰāϤā§
=PROPER(A1)
16. UPPER â āĻā§āĻā§āϏāĻāĻā§ āĻŦā§ āĻšāĻžāϤā§āϰ āĻ
āĻā§āώāϰ⧠āϰā§āĻĒāĻžāύā§āϤāϰ āĻāϰāϤā§
=UPPER(A1)
17. LOWER â āĻā§āĻā§āϏāĻāĻā§ āĻā§āĻ āĻšāĻžāϤā§āϰ āĻ
āĻā§āώāϰ⧠āϰā§āĻĒāĻžāύā§āϤāϰ āĻāϰāϤā§
=LOWER(A1)
18. ROUND â āϏāĻāĻā§āϝāĻž āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻĻāĻļāĻŽāĻŋāĻ āĻĒāϰā§āϝāύā§āϤ āϰāĻžāĻāύā§āĻĄ āĻāϰāϤā§
=ROUND(A1,2)
19. NOW â āĻŦāϰā§āϤāĻŽāĻžāύ āϤāĻžāϰāĻŋāĻ āĻ āϏāĻŽā§ āĻĻā§āĻāĻžāύā§āϰ āĻāύā§āϝ
=NOW()
20. TODAY â āĻŦāϰā§āϤāĻŽāĻžāύ āϤāĻžāϰāĻŋāĻ āĻĻā§āĻāĻžāύā§āϰ āĻāύā§āϝ
=TODAY()
Post make
ChatGPT said:
đ¯ MS Excel āĻļāĻŋāĻāϤ⧠āĻāĻžāύ? āϤāĻžāĻšāϞ⧠āĻāĻ ā§¨ā§ĻāĻāĻŋ āĻā§āϰā§āϤā§āĻŦāĻĒā§āϰā§āĻŖ āĻĢāϰā§āĻŽā§āϞāĻž āĻ
āĻŦāĻļā§āϝāĻ āĻāĻžāύāĻž āĻāĻāĻŋāϤ! đģđ
Excel āĻļā§āĻāĻžāϰ āĻļā§āϰ⧠āĻšā§āĻ āϏāĻŦāĻā§ā§ā§ āĻĻāϰāĻāĻžāϰāĻŋ āĻĢāϰā§āĻŽā§āϞāĻžāĻā§āϞ⧠āĻĻāĻŋā§ā§đ
1ī¸âŖ SUM â āϝā§āĻāĻĢāϞ āĻŦā§āϰ āĻāϰāĻžāϰ āĻāύā§āϝ
=SUM(A1:A10)
2ī¸âŖ AVERAGE â āĻā§ āύāĻŋāϰā§āĻŖā§ā§āϰ āĻāύā§āϝ
=AVERAGE(A1:A10)
3ī¸âŖ COUNT â āϏāĻāĻā§āϝāĻžāϝā§āĻā§āϤ āϏā§āϞ āĻāĻŖāύāĻžāϰ āĻāύā§āϝ
=COUNT(A1:A10)
4ī¸âŖ COUNTA â āĻāĻžāϞāĻŋ āύ⧠āĻāĻŽāύ āϏā§āϞ āĻāĻŖāύāĻžāϰ āĻāύā§āϝ
=COUNTA(A1:A10)
5ī¸âŖ IF â āĻļāϰā§āϤ āĻ
āύā§āϝāĻžā§ā§ āĻĢāϞāĻžāĻĢāϞ āĻĻā§āĻāĻžāύā§āϰ āĻāύā§āϝ
=IF(B2>50,"Pass","Fail")
6ī¸âŖ SUMIF â āĻļāϰā§āϤ āĻ
āύā§āϝāĻžā§ā§ āϝā§āĻāĻĢāϞ āĻŦā§āϰ āĻāϰāϤā§
=SUMIF(A1:A10,">50")
7ī¸âŖ COUNTIF â āĻļāϰā§āϤ āĻ
āύā§āϝāĻžā§ā§ āϏā§āϞ āĻāĻŖāύāĻž
=COUNTIF(A1:A10,">50")
8ī¸âŖ VLOOKUP â āĻā§āĻŦāĻŋāϞ āĻĨā§āĻā§ āĻĄā§āĻāĻž āĻā§āĻāĻāĻžāϰ āĻāύā§āϝ
=VLOOKUP(B2, A1:D10, 3, FALSE)
9ī¸âŖ XLOOKUP â āĻāϧā§āύāĻŋāĻ āĻ āĻāύā§āύāϤ Lookup āĻĢāĻžāĻāĻļāύ
=XLOOKUP(B2, A1:A10, B1:B10)
đ INDEX â āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻ
āĻŦāϏā§āĻĨāĻžāύ āĻĨā§āĻā§ āĻŽāĻžāύ āĻāύāĻžāϰ āĻāύā§āϝ
=INDEX(A1:C10, 2, 3)
1ī¸âŖ1ī¸âŖ MATCH â āĻŽāĻžāύāĻāĻŋ āĻā§āĻĨāĻžā§ āĻāĻā§ āϤāĻž āĻā§āĻāĻāϤā§
=MATCH(B2, A1:A10, 0)
1ī¸âŖ2ī¸âŖ CONCAT â āĻā§āĻā§āϏāĻ āĻāĻāϤā§āϰ āĻāϰāĻžāϰ āĻāύā§āϝ
=CONCAT(A1, " ", B1)
1ī¸âŖ3ī¸âŖ TEXTJOIN â āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āϏāĻŋāĻŽā§āĻŦāϞ/āĻĄā§āϞāĻŋāĻŽāĻŋāĻāĻžāϰ āĻĻāĻŋā§ā§ āĻā§āĻā§āϏāĻ āϝā§āĻā§āϤ āĻāϰāϤā§
=TEXTJOIN("-", TRUE, A1:A3)
1ī¸âŖ4ī¸âŖ TRIM â āĻ
āϤāĻŋāϰāĻŋāĻā§āϤ āϏā§āĻĒā§āϏ āϏāϰāĻžāϤā§
=TRIM(A1)
1ī¸âŖ5ī¸âŖ PROPER â āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻļāĻŦā§āĻĻā§āϰ āĻĒā§āϰāĻĨāĻŽ āĻ
āĻā§āώāϰ āĻŦā§ āĻāϰāϤā§
=PROPER(A1)
1ī¸âŖ6ī¸âŖ UPPER â āϏāĻŦ āĻā§āĻā§āϏāĻ āĻŦā§ āĻšāĻžāϤā§āϰ āĻ
āĻā§āώāϰā§
=UPPER(A1)
1ī¸âŖ7ī¸âŖ LOWER â āϏāĻŦ āĻā§āĻā§āϏāĻ āĻā§āĻ āĻšāĻžāϤā§āϰ āĻ
āĻā§āώāϰā§
=LOWER(A1)
1ī¸âŖ8ī¸âŖ ROUND â āϏāĻāĻā§āϝāĻž āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻĻāĻļāĻŽāĻŋāĻ āĻĒāϰā§āϝāύā§āϤ āϰāĻžāĻāύā§āĻĄ āĻāϰāϤā§
=ROUND(A1,2)
1ī¸âŖ9ī¸âŖ NOW â āĻŦāϰā§āϤāĻŽāĻžāύ āϤāĻžāϰāĻŋāĻ āĻ āϏāĻŽā§
=NOW()
2ī¸âŖ0ī¸âŖ TODAY â āĻļā§āϧā§āĻŽāĻžāϤā§āϰ āĻŦāϰā§āϤāĻŽāĻžāύ āϤāĻžāϰāĻŋāĻ
=TODAY()
đ Excel āĻļāĻŋāĻāϤ⧠āĻāĻžāĻāϞ⧠āĻāĻ āĻĢāϰā§āĻŽā§āϞāĻžāĻā§āϞ⧠āĻĒā§āϰāϤāĻŋāĻĻāĻŋāύ āĻāĻāĻā§ āĻāĻāĻā§ āĻāϰ⧠āĻĒā§āϰā§āϝāĻžāĻāĻāĻŋāϏ āĻāϰā§āύāĨ¤
đ āĻļā§ā§āĻžāϰ āĻāϰā§āύ, āϝāĻžāϤ⧠āĻ
āύā§āϝāϰāĻžāĻ āĻļāĻŋāĻāϤ⧠āĻĒāĻžāϰā§! đĄ