Summary
In this chapter, we learned about the power of formulas and functions and how we can use them to speed up our modeling and make it more interesting. We worked through examples of some of the more common functions, such as the VLOOKUP, MATCH, and CHOOSE functions. We were also introduced to some of the new functions introduced in Excel 365: XLOOKUP, FILTER, UNIQUE, and SORT. We will see another new function, SEQUENCE, in a practical example in Chapter 7, Asset and Debt Schedules.
In the next chapter, we will look at one of the features that forms the backbone of Excel, the referencing framework. Understanding this framework and knowing how to apply its principles will help to speed up your work and improve your productivity.
