Summary

You now have the skills to work with Math & Trig and Statistical functions using Excel 2021. You have built on prior knowledge by learning valuable functions, such as being able to generate random numbers using RANDBETWEEN and RAND functions. In addition, you went through examples of working with PRODUCT functions and explored the SUMPRODUCT, MROUND, FLOOR, TRUNC, AGGREGATE, and CONVERT functions.

We also investigated the MEDIAN, COUNTBLANK, and AVERAGEIFS statistical functions in this chapter, from which you can experiment and apply to existing or new scenarios when working with workbook data.

This next chapter will take you through Outlook 2021 enhancements, where we will explore and configure objects such as mail, contacts, tasks, notes, and journals. You will set some advanced and language options in the interface and learn how to manipulate item tags and arrange the content pane.

In addition, we will apply some search and filter tools, and print Outlook...