Excel 365 for Beginners: Learn the Most Essential Formulas and Functions (18 of 51)

Introduction

This tutorial covers six essential Excel formulas that are fundamental for data analysis: SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX. Understanding how to use these functions will enhance your ability to manipulate and analyze data efficiently in Excel 365.

Step 1: Using the SUM Function

The SUM function allows you to add together a range of numbers.

• How to Use:

  1. Click on the cell where you want the sum to appear.
  2. Type =SUM(.
  3. Select the range of cells you want to add (e.g., A1:A10).
  4. Close the parenthesis and press Enter.

• Example:

  =SUM(A1:A10)
  

Step 2: Using the COUNT Function

The COUNT function counts the number of cells that contain numeric data.

• How to Use:

  1. Click on the cell where you want the count to appear.
  2. Type =COUNT(.
  3. Select the range of cells (e.g., B1:B10).
  4. Close the parenthesis and press Enter.

• Example:

  =COUNT(B1:B10)
  

Step 3: Using the COUNTA Function

The COUNTA function counts the number of non-empty cells, regardless of the data type.

• How to Use:

  1. Click on the cell for the result.
  2. Type =COUNTA(.
  3. Select the range (e.g., C1:C10).
  4. Close the parenthesis and hit Enter.

• Example:

  =COUNTA(C1:C10)
  

Step 4: Using the AVERAGE Function

The AVERAGE function calculates the mean of a set of numbers.

• How to Use:

  1. Select the cell for the average result.
  2. Type =AVERAGE(.
  3. Highlight the range (e.g., D1:D10).
  4. Close the parenthesis and press Enter.

• Example:

  =AVERAGE(D1:D10)
  

Step 5: Using the MIN Function

The MIN function returns the smallest number in a set of values.

• How to Use:

  1. Click on the cell for the minimum value.
  2. Type =MIN(.
  3. Select the range (e.g., E1:E10).
  4. Close the parenthesis and press Enter.

• Example:

  =MIN(E1:E10)
  

Step 6: Using the MAX Function

The MAX function identifies the largest number in a set.

• How to Use:

  1. Click on the cell where you want the maximum value.
  2. Type =MAX(.
  3. Choose the range of cells (e.g., F1:F10).
  4. Close the parenthesis and hit Enter.

• Example:

  =MAX(F1:F10)
  

Conclusion

In this tutorial, you learned how to use six fundamental Excel functions: SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX. Mastering these formulas will significantly improve your data analysis skills in Excel 365. For further learning, consider exploring more advanced functions or additional tutorials to broaden your Excel knowledge.