MS Excel - Mastering Formulas and Functions
| |
Venue | Online Live Stream |
Date | Tuesday 2 April 2024 |
Time | 12:00 - 15:00 GMT+2 |
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 |
Vickie Watt
Vickie has an extensive background in communication and training consulting in various industries which include manufacturing, mining, insurance, retail, media, and ICT.
As a Microsoft Certified Professional and Microsoft Certified Trainer, Vickie has achieved Microsoft Office Specialist Expert status, and is an advanced user in Microsoft Excel, Word, Project, PowerPoint, and Outlook, with extensive experience in a number of other software applications.
She is a registered Assessor with the ETDP and MICT SETAs.
Close this popup
|
CPD Units | 3 units on full attendance |
Price | R 700 |
Booking Deadline | Tuesday 2 April 2024 |
|
|
|