During this 2–hour workshop, participants will learn to:
- Apply basic math and statistical Excel functions such as sum, mean, median, mode, minimum and maximum.
- Use the COUNT and COUNTIF functions to determine the number sat and number passed.
- Apply the RANK function to determine positions, and IF function to grade marks.
- Generate report sheets from a master marksheet.