What are Excel formulas commonly used in analytics?

**Excel formulas** help analysts clean, organize, calculate, and analyze data efficiently. Some of the most commonly used formulas are:

• SUM() — Adds values together. Example: =SUM(A1:A10)
• AVERAGE() — Calculates the average of a range of values. Example: =AVERAGE(A1:A10)
• COUNT() — Counts cells containing numbers. Example: =COUNT(A1:A10)
• COUNTA() — Counts non-empty cells. Example: =COUNTA(A1:A10)
• MAX() — Finds the highest value in a range. Example: =MAX(A1:A10)
• MIN() — Finds the lowest value in a range. Example: =MIN(A1:A10)
• IF() — Performs conditional calculations or returns different results based on a condition. Example: =IF(A1>100,"High","Low")
• SUMIF() — Adds values that meet a specific condition. Example: =SUMIF(A:A,"Sales",B:B)
• COUNTIF() — Counts cells that meet a specific condition. Example: =COUNTIF(A:A,"Completed")
• AVERAGEIF() — Calculates the average of values that meet a condition. Example: =AVERAGEIF(A:A,"North",B:B)
• VLOOKUP() — Looks up data vertically in a table. Example: =VLOOKUP(A2,D:F,2,FALSE)
• XLOOKUP() — A modern and more flexible lookup function. Example: =XLOOKUP(A2,D:D,E:E)
• INDEX() and MATCH() — Used together for advanced and flexible lookups. Example: =INDEX(B:B,MATCH(A2,A:A,0))
• LEFT(), RIGHT(), MID() — Extract specific characters from text. Example: =LEFT(A1,5)
• CONCAT() — Combines text from multiple cells. Example: =CONCAT(A1," ",B1)
• TRIM() — Removes extra spaces from text. Example: =TRIM(A1)
• LEN() — Returns the number of characters in a cell. Example: =LEN(A1)
• TODAY() — Returns the current date. Example: =TODAY()
• DATEDIF() — Calculates the difference between two dates. Example: =DATEDIF(A1,B1,"D")

Key Excel Formulas Every Data Analyst Should Learn

• SUM
• AVERAGE
• IF
• COUNTIF
• SUMIF
• XLOOKUP
• INDEX + MATCH
• CONCAT
• TRIM
• DATEDIF

These formulas are essential for **data cleaning**, reporting, dashboard creation, and business analysis.