Excel – Advanced Functions

Summary

Suitable for: SHOs and registrars in all surgical specialties; emergency medicine doctors

This course has been developed as a follow-on to the Excel – Introduction course, with a specific focus on introducing you to the more advanced features of the application. 

Learning outcomes

Understanding of and ability to use the following functions:

  • Logical functions (IF, AND, OR, IFERROR)
  • Lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP)
  • Date/time functions (DAY, MONTH, YEAR, DATEVALUE)
  • Text functions (LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TEXT, TRIM)