Basic Data Processing Functions (SUM, AVERAGE, COUNT, etc.)

1. SUM Function: Summing Data

• Problem: Need to sum monthly sales data.
• Usage: =SUM(A1:A10)
• Tip: Use filters to sum only selected values.

2. AVERAGE Function: Calculating Averages

• Problem: Need to calculate the average working hours of team members.
• Usage: =AVERAGE(B1:B10)
• Tip: If there are empty cells, filter the data before calculating the average.

3. COUNT Function: Counting Data

• Problem: Need to count the number of survey respondents.
• Usage: =COUNT(C1:C100)
• Note: COUNT only counts numeric values; use COUNTA to count text as well.

4. TRIM Function: Removing Spaces

• Problem: Customer names contain unnecessary spaces, making searching difficult.
• Usage: =TRIM(A1)

Additional Functions

• ROUND, ROUNDUP, ROUNDDOWN: Rounding numbers up or down.
• SUBTOTAL: Calculating sums or averages for filtered data.
• LARGE, SMALL: Finding the nth largest or smallest value.