Online Session: MS Excel - Mastering Formulas and Functions
| |
| Venue | Online - Microsoft Teams |
| Date | Tuesday 28th September 2021 |
| Time | 11:00 - 14:00 |
| Information | Financial Functions: PMT IPMT PPMT the Loan Amortisation Schedule template other financial functions.
Logical Functions: IF AND OR NOT – letting Excel decide for you.
Lookup Functions: VLOOKUP MATCH INDEX.
Text Functions: Extracting and combining text with LEFT RIGHT MID CONCATENATE also LEN and VALUE.
Date and Time Functions: TODAY DATE YEARFRAC NETWORKDAYS WORKDAY.
Nested Functions: IF(OR; IF(AND; IFERROR(VLOOKUP etc.
Troubleshooting Formulas and Functions: Tracer arrows error checking evaluate a formula control calculation options.
Note: This course is not refundable by the HRDC as it is being broadcasted from our Johannesburg office |
| Presenter |
|
| CPD Units | 3 units on full attendance |
| Seats Left | 42 |
| Price | Rs 1500 |
| Booking Deadline | Tuesday 28th September 2021 |
| Map | View Map |
|
|
|
