Excel - Dynamic Arrays and New Functions
| |
| Venue | Online Live Stream |
| Date | Thursday 19 June 2025 |
| Time | 09:00 - 12:00 GMT+2 |
| Information | This advanced course covers some new Excel functions released in Office 365 and Microsoft 365.
You will review dynamic arrays and learn about the following functions:
UNIQUE SORT FILTER TRANSPOSE VSTACK & HSTACK XLOOKUP TEXTJOIN & TEXTSPLIT GROUPBY PIVOTBY LET and LAMBDA. It is recommended that you are familiar with Defined Names (Range Names) and Excel Tables
|
| 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 950 |
| Booking Deadline | Thursday 19 June 2025 |
|
|
|
