After this workshop, you will be able to:
Summarise data by using functions
- Insert references
- Perform calculations by using the SUM function
- Perform calculations by using MIN and MAX functions
- Perform calculations by using the COUNT function
- Perform calculations by using the AVERAGE function
Perform conditional operations by using functions
- Perform logical operations using the IF function
- Perform logical operations using the SUMIF function
- Perform logical operations using the AVERAGEIF function
- Perform statistical operations by using the COUNTIF function
Format and modify text by using functions
- Format text by using RIGHT, LEFT and MID functions
- Format text by using UPPER, LOWER and PROPER functions
- Format text by using the CONCATENATE function