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
This session is not eligible for the HRDC refund as it is being broadcasted from our Johannesburg office |