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