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
Need help with your own assignment?
Our expert writers can help you apply everything you've just read — to your actual assignment.
Get Expert Help Now →