Live Session: MS Excel: Mastering formulas and functions
| |
| Venue | Online - Microsoft Teams |
| Date | Tuesday 29th September 2020 |
| Time | 14:30 - 17:30 |
| Information | This course is aimed at users who need to use advanced Excel formulas and functions. You will learn how to work with some Financial Logical Lookup Text and Date and Time functions. In addition you will learn how to troubleshoot formulas and functions and control calculation options. At the end of this course (and with a little practice) you should feel confident to find and use most Excel functions.
Course pre-requisites: Is able to work with the Windows operating system and Excel fundamentals including selecting cells and ranges basic formulas and functions absolute references and cut copy and paste. If your foundation in Excel needs to be strengthened please attend the Excel Fundamentals course before this one.
Topic
1. Financial Functions: PMT IPMT PPMT the Loan Amortisation Schedule
template other financial functions
2. Logical Functions: IF AND OR NOT – letting Excel decide for you
3. Lookup Functions: VLOOKUP MATCH INDEX
4. Text Functions: Extracting and combining text with LEFT RIGHT MID
CONCATENATE also LEN and VALUE
5. Date and Time Functions: TODAY DATE YEARFRAC NETWORKDAYS WORKDAY
6. Nested Functions: IF(OR; IF(AND; IFERROR(VLOOKUP etc
7. Troubleshooting Formulas and Functions: Tracer arrows error checking
evaluate a formula control calculation options |
| Presenter |
|
| CPD Units | 3 units on full attendance |
| Seats Left | 11 |
| Price | Rs1500
| | Booking Deadline | Tuesday 29th September 2020 |
| Map | View Map |
|
|
|
