1. What are Dynamic Arrays
2. Introduction to Spills and Arrays
3. Extract and Count Unique Entries
4. Unique vs Distinct
5. Extract Unique Values with Multiple Criteria
6. Extract Unique Values by Column
7. The SORT Function
8. The SORT Function - Horizontal SORT
9. The SORTBY Function
10. The SORTBY Function - Horizontal SORT
11. Simple SEQUENCE and Unstacking Records
12. The FILTER Function
13. FILTER with Logic + Operator (OR)
14. FILTER with Logic Operator (AND)
15. FILTER with Logic = Operator (Both or Neither)
16. FILTER with Logic - Operator (One or the Other)
17. Using RANDARRAY and RANDBETWEEN to Randomize Data
18. Using XLOOKUP to Perform Complex Lookups
19. Using XMATCH
20. Exercise 02
21. Section Quiz.html