Applying Formulas and Functions in Microsoft Excel 2019

Microsoft Excel 2019 houses an enormous number of functions. Duringthis part of the book, you will learn how to create a formula andinvestigate the difference between a formula and function, and learnabout operators and formula construction, using the correct order ofevaluation. After learning the different methods of constructing aformula, you will be introduced to a number of functions from differentcategories located in the FunctionLibrary.

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 formulaerrors and learn how to use named ranges in a formula.

Leave a Comment