MS Excel for Data Analysis

🚀🔥𝗚𝗢𝗢𝗚𝗟𝗘 𝗖𝗟𝗢𝗨𝗗 – 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! ☁️📊

Learn *Data Analytics, BigQuery, Data Engineering & Looker* for FREE!

✅ Beginner-Friendly Learning
✅ Build In-Demand Tech Skills
✅ Boost Your Resume & Career Opportunities

🎯 Perfect for Students, Freshers & Job Seekers!

🔗 𝗟𝗶𝗻𝗸 :- 👇

https://pdlink.in/4AttkUb

📲 Save & Share with your friends! 🔥

USEFUL MICROSOFT EXCEL FORMULAS

Microsoft Excel offers hundreds of built-in formulas that help you perform calculations, analyze data, clean information, manage dates, and automate everyday tasks.

Here are 40 useful Excel formulas everyone should know.

1. Basic Mathematical Formulas

1. SUM() – Adds numbers.
   Example: =SUM(A1:A10)

2. AVERAGE() – Calculates the average.
   Example: =AVERAGE(A1:A10)

3. MIN() – Returns the smallest value.
   Example: =MIN(A1:A10)

4. MAX() – Returns the largest value.
   Example: =MAX(A1:A10)

5. COUNT() – Counts cells containing numbers.
   Example: =COUNT(A1:A10)

6. COUNTA() – Counts non-empty cells.
   Example: =COUNTA(A1:A10)

7. COUNTBLANK() – Counts empty cells.
   Example: =COUNTBLANK(A1:A10)

8. PRODUCT() – Multiplies numbers.
   Example: =PRODUCT(A1:A5)

9. ABS() – Returns the absolute value.
   Example: =ABS(-25)

10. ROUND() – Rounds a number to specified decimal places.
    Example: =ROUND(12.567,2)

2. Logical Formulas

11. IF() – Checks a condition and returns different results.
    Example: =IF(A2>=40,"Pass","Fail")

12. IFS() – Checks multiple conditions.
    Example: =IFS(A2>=90,"A",A2>=75,"B",TRUE,"C")

13. AND() – Returns TRUE if all conditions are true.
    Example: =AND(A2>50,B2<100)

14. OR() – Returns TRUE if at least one condition is true.
    Example: =OR(A2>50,B2<100)

15. NOT() – Reverses a logical result.
    Example: =NOT(A2>50)

16. IFERROR() – Returns a custom result if a formula produces an error.
    Example: =IFERROR(A2/B2,0)

17. IFNA() – Handles #N/A errors.
    Example: =IFNA(VLOOKUP(E2,A2:B10,2,FALSE),"Not Found")

18. SWITCH() – Compares a value against multiple options.
    Example: =SWITCH(A2,1,"One",2,"Two","Other")

19. XOR() – Returns TRUE when an odd number of conditions are true.
    Example: =XOR(A2>10,B2>20)

20. TRUE() – Returns the logical value TRUE.
    Example: =TRUE()

3. Text Formulas

21. LEFT() – Extracts characters from the left side of text.
    Example: =LEFT(A2,5)

22. RIGHT() – Extracts characters from the right side of text.
    Example: =RIGHT(A2,5)

23. MID() – Extracts characters from the middle of text.
    Example: =MID(A2,2,4)

24. LEN() – Counts the number of characters.
    Example: =LEN(A2)

25. TRIM() – Removes extra spaces from text.
    Example: =TRIM(A2)

26. UPPER() – Converts text into uppercase.
    Example: =UPPER(A2)

27. LOWER() – Converts text into lowercase.
    Example: =LOWER(A2)

28. PROPER() – Capitalizes the first letter of each word.
    Example: =PROPER(A2)

29. CONCAT() – Combines text from multiple cells.
    Example: =CONCAT(A2,B2)

30. TEXTJOIN() – Combines text using a specified delimiter.
    Example: =TEXTJOIN(", ",TRUE,A2:A10)

4. Lookup and Reference Formulas

31. VLOOKUP() – Searches vertically in a table.
    Example: =VLOOKUP(E2,A2:C10,2,FALSE)

32. HLOOKUP() – Searches horizontally in a table.
    Example: =HLOOKUP(B1,A1:F3,2,FALSE)

33. XLOOKUP() – Searches for a value and returns a matching result.
    Example: =XLOOKUP(E2,A2:A10,B2:B10,"Not Found")

34. INDEX() – Returns a value from a specified position.
    Example: =INDEX(A2:C10,2,3)

35. MATCH() – Finds the position of a value in a range.
    Example: =MATCH(E2,A2:A10,0)

36. XMATCH() – Finds the relative position of a value.
    Example: =XMATCH(E2,A2:A10)

37. CHOOSE() – Returns a value based on its position.
    Example: =CHOOSE(2,"Red","Blue","Green")

38. OFFSET() – Returns a reference shifted from a starting cell.
    Example: =OFFSET(A1,2,1)

39. INDIRECT() – Converts text into a cell reference.
    Example: =INDIRECT("A1")

40. TRANSPOSE() – Converts rows into columns and vice versa.
    Example: =TRANSPOSE(A1:C3)

Double Tap ❤️ For More

🎓 𝟰 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀

Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies

📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/45vk5ph

💫 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 :- https://pdlink.in/3SuUeuD

☁️ 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 :- :- https://pdlink.in/48kyZjt

🛡️ 𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 :- :- https://pdlink.in/4fWJVID

🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates!