Summary
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)
Suitable for: SHOs and registrars in all surgical specialties; emergency medicine doctors