This assignment involves the following Excel functions and techniques: • Pivot T

This assignment involves the following Excel functions and techniques: • Pivot Tables, inserting fields, filters, and slicers. • Functional programming with dynamic arrays: LAMBDA, LET, SORT, UNIQUE, FILTER, SUM- IFS, AVERAGEIFS, all LAMBDA-helper functions we covered in earlier assignments/labs, text processing functions such as TEXTBEFORE and TEXTAFTER, stacking functions (HSTACK, VSTACK), array accessing functions such as TAKE, DROP etc. further information will be provided