Excel Learning Series Part-3

Complete Excel Topics for Data Analysis: https://t.me/sqlspecialist/547

Now, let's learn about Formulas and Functions in Excel.

1. Basic Arithmetic Functions:
- Addition: To add numbers in Excel, you can use the plus "+" operator. For example, to add the numbers in cells A1 and B1, you would enter "=A1+B1" in another cell.
- Subtraction: To subtract numbers, use the minus "-" operator. For instance, "=A2-B2" subtracts the value in cell B2 from the value in cell A2.
- Multiplication: Use the asterisk "*" for multiplication. For example, "=C1*D1" multiplies the values in cells C1 and D1.
- Division: To divide numbers, use the forward slash "/" operator. For instance, "=E1/F1" divides the value in cell E1 by the value in cell F1.

2. SUM Function:
- The SUM function adds up a range of numbers. For example, "=SUM(A1:A5)" adds the numbers in cells A1 through A5.
- You can also use the SUM function to add individual numbers. For instance, "=SUM(10, 20, 30)" adds 10, 20, and 30 together.

3. AVERAGE Function:
- The AVERAGE function calculates the average of a range of numbers. For example, "=AVERAGE(B1:B10)" calculates the average of the numbers in cells B1 through B10.
- Like the SUM function, you can also use the AVERAGE function to find the average of individual numbers.

4. COUNT Function:
- The COUNT function counts the number of cells that contain numbers within a specified range. For example, "=COUNT(C1:C20)" counts the number of non-empty cells in the range C1 to C20 that contain numeric values.
- You can also use COUNTA function to count non-empty cells regardless of data type.

Here are a few examples to illustrate these concepts:

- Addition: If cell A1 contains 10 and cell B1 contains 20, entering "=A1+B1" in another cell will display the result 30.
- SUM Function: If cells C1 to C5 contain the numbers 10, 20, 30, 40, and 50 respectively, "=SUM(C1:C5)" will yield the result 150.
- AVERAGE Function: If cells D1 to D4 contain the numbers 10, 20, 30, and 40 respectively, "=AVERAGE(D1:D4)" will give the average 25.
- COUNT Function: If cells E1 to E10 contain numeric values, "=COUNT(E1:E10)" will count how many of those cells are populated with numbers.

These basic arithmetic functions and built-in Excel functions form the foundation for performing calculations and analysis in Excel.

Share with credits: https://t.me/sqlspecialist

Stay tuned for the next topics ☺️

Hope it helps :)