SECTION 1: Working with Functions and Formulas

   

 


In this section you will learn how to:

  • Work with relative and absolute cell references
  • Work with the basic mathematical operators
  • Use formulas with multiple cell ranges
  • Use the Formula Auditing Bar
  • Fix formula errors
  • Display and print formulas
  • Understand functions
  • Find the function you need
  • Work with some basic and useful functions
  • Insert functions
  • Work with conditional functions
  • Work with nested functions
  • Define and use Range Names