wconsulting.mu

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