Brand New Course Exclusively by Office Instructor
This is a game changer course for clients using Microsoft 365
Intermediate knowledge of Formulas and Functions (Code: 20135)
This course allows you to do in few seconds, tasks that you would usually do in long hours with classic Excel Functions
Among the Course Topics Some or Most of the Following:
1. The new calculation engine in Excel.
2. The concept of Dynamic Array functions
3. Referencing a Dynamic Array result
4. The Spill Error #
5. Extracting Records conditionally with Dynamic Arrays.
6. Comparing lists with a single click
7. UNIQUE and FILTER Functions
8. 5 Drop lists in a single cell
9. Create any year calendar with a single function and a single argument.
12.SEQUENCE and RANDARRAY functions.
13.Create an entire report with a single cell function.
14.VLOOKUP, gone but not forgotten: XLOOKUP
15.Sorting with Dynamic Array functions: SORT/ SORTBY
16.Creating Charts with Dynamic Arrays
17.TEXTJOIN/ TEXTSPLIT/ TEXTBEFORE/ TEXTAFTER
18.TAKE/ REDUCE Functions
19.TOCOL/ TOROW Functions
20.SCAN/ MAP Functions
21.HSTACK/ VSTACK Functions
22.WRAPROWS/ WRAPCOLS Functions
24.LET and LAMBDA