Alison's New App is now available on iOS and Android! Download Now
Reminders
Support Having completed this module, you will be able to:
Distinguish between the SORT and SORTBY functions.
Explain the purpose of RAND, RANDARRAY and RANDBETWEEN functions.
Define dynamic arrays.
List multiple functions used in the creation of management reports.
Describe the use of FILTER and SORT function to filter and sort data.
Outline the different lookup functions.
Join our community of 40 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics - all for free.
