Microsoft Excel 2019 houses an enormous number of functions. During this part of the book, you will learn how to create a formula and investigate the difference between a formula and function, and learn about operators and formula construction, using the correct order of evaluation. After learning the different methods of constructing a formula, you will be introduced to a number of functions from different categories located in the Function Library.
The following list of topics are covered in this chapter:
- Learning basic formula operations
- Constructing a formula
- Using the Function Library
- Error checking in formulas
- Applying named ranges in a formula
At the end of the chapter, we will highlight common formula errors and learn how to use named ranges in a formula.
