Training agenda
  1. Filtering and sorting
    1. FILTER – including partial text match and exclusions
    2. SORT, SORTBY
  2. Working with data ranges
    1. CHOSECOLS, CHOSEROWS
    2. UNIQUE
    3. TOROW, TOCOL
    4. SEQUENCE
    5. DROP, TAKE
    6. VSTACK, HSTACK
  3. Lookup functions
    1. XLOOKUP
    2. XMATCH
    3. CHOOSE
  4. Logical functions
    1. IFS
    2. SWITCH
  5. Aggregating functions
    1. GROUPBY
    2. PIVOTBY
  6. Working with texts
    1. TEXTJOIN, TEXTSPLIT
    2. TEXTBEFORE, TEXTAFTER
    3. ARRAYTOTEXT
  7. Regular expression functions
    1. REGEXTEST
    2. REGEXEXTRACT
    3. REGEXREPLACE
  8. Importing data from pictures
  9. Automatic data analysis
  10. Creating variables – LET function
  11. Creating custom functions without VBA – LAMBDA function
  12. LAMBDA helpers
    1. MAP
    2. REDUCE
    3. BYROW
    4. BYCOL
    5. SCAN
    6. ISOOMITED
  13. CUBE functions
    1. CUBESET
    2. CUBESETCOUNT
    3. CUBERANKEDMEMBER
    4. CUBEMEMBER
    5. CUBEVALUE
    6. CUBEKPIMEMBER
  14. New navigation pane VIEW / NAWIGATION