Advanced Excel: Basic and Conditional Functions

In this session we will be guiding the students through the Basic and Conditional Functions:

1. SUM: Adds up a range of numbers. For example, =SUM(A1:A10) adds the values in cells A1 through A10.
2. COUNT: Counts the number of cells containing numeric data. Use it like this: =COUNT(B1:B20).
3. AVERAGE: Calculates the average of a set of values. For instance, =AVERAGE(C1:C100) gives you the average of cells C1 to C100.
4. MAX and MIN: Find the highest and lowest values in a range. Try =MAX(D1:D50) and =MIN(D1:D50).
5. AND: Tests multiple conditions, returning true only if all conditions are true.
6. OR: Tests multiple conditions, returning true if at least one condition is true.