Excel Functions Overview

1. Average Function

• Purpose: Calculates the average of a group of numbers.
• Example Usage:
  • To find the average of numbers (15, 27, 42, 93, 56, 84, 75, 33, 49):
    • Formula: =AVERAGE(range)
    • Result: 53.125
  • Averaging specific numbers:
    • For 100 and 200: =AVERAGE(100, 200) ➔ Result: 150
    • For 100, 200, and 300: =AVERAGE(100, 200, 300) ➔ Result: 200

2. Sum Function

• Purpose: Sums a range of numbers.
• Example Usage:
  • To sum a list of numbers:
    • Formula: =SUM(range)
    • Result: 429
  • To sum specific numbers:
    • For 50 and 125: =SUM(50, 125) ➔ Result: 175
    • For 100, 200, and 300: =SUM(100, 200, 300) ➔ Result: 600

3. Sum If Function

• Purpose: Sums values based on a specified condition.
• Example Usage:
  • To sum only Mazda vehicles:
    • Formula: =SUMIF(range, criteria, sum_range)
    • Result: Sum of Mazda vehicles = 692
  • Change criteria to Honda or Toyota to get their respective sums.

4. Count Function

• Purpose: Counts the number of cells containing numbers.
• Example Usage:
  • Total numeric cells in a range: Result = 10.

5. Count A Function

• Purpose: Counts the number of non-empty cells.
• Example Usage:
  • Count of non-empty cells (including text): Result = 10.

6. Count Blank Function

• Purpose: Counts the number of empty cells.
• Example Usage:
  • Result: 3 empty cells.

7. Count If Function

• Purpose: Counts cells that meet a specific criteria.
• Example Usage:
  • To count Mazda vehicles in the list:
    • Formula: =COUNTIF(range, criteria)
    • Result: 4 Mazdas, 2 Toyotas.

8. Concatenate Function

• Purpose: Combines text strings from different cells.
• Example Usage:
  • To combine first and last names:
    • Formula: =CONCATENATE(text1, text2)
    • Include space using: =CONCATENATE(B2, " ", C2).

9. If Function

• Purpose: Returns one value if a condition is true and another if false.
• Example Usage:
  • Check for specific text (e.g., fruit names):
    • Formula: =IF(condition, true_value, false_value)
  • Perform calculations based on conditions:
    • Example: =IF(B9>30, B9*10, 0).

10. VLOOKUP Function

• Purpose: Looks up a value in a table and returns a value from a specified column.
• Example Usage:
  • Lookup for email, phone number, or revenue:
    • Formula: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE)
    • Example for finding John Smith's email: =VLOOKUP(C8, table, 2, FALSE).

11. Drop Down List Creation

• Purpose: Simplifies data entry by providing a list of options.
• Example Usage:
  • Create a drop-down list using Data Validation in Excel:
    • Go to Data > Data Validation > Allow: List.
    • Enter options or select from a range.

---

Additional Resources

• Check the description for more detailed videos on topics such as VLOOKUP, drop-down lists, IF functions, and more.
• Explore playlists for algebra, geometry, trigonometry, precalculus, chemistry, and physics.