Learning Outcomes

In this free course, you will learn how to:

• Distinguish between the SORT and SORT BY functions
• Explain the purpose of RAND, RANDARRAY and RANDBETWEEN functions
• Define dynamic arrays and state their uses
• List multiple functions used in the creation of management reports
• Describe the use of FILTER and SORT functions to filter and sort data
• Outline the different lookup functions
• Evaluate the different functions to be used in a multi-scenario situation
• Explain the syntax of various functions