Day 24 (Adv Apps)

FINISH THIS TODAY.

Excel Module 3–Performing Calculations with Formulas and Functions

At the end of this module you will know about how to:

  1. Document formulas and data values
  2. Explore function syntax
  3. Insert functions from the Formula Library
  4. Perform a what-if analysis
  5. AutoFill series and formulas
  6. Use relative and absolute cell references
  7. Use the Quick Analysis tool
  8. Work with dates and Date functions
  9. Find value with Lookup functions
  10. Work the Logical functions

RIGHT NOW:

  1. Autofilling Formulas & Data: Read and do pages EX156 to EX161 and watch this video to help–show me before continuing
  2. Exploring Cell References: Read and do pages EX161 to EX167 and watch this video to help–show me before continuing
  3. Summarizing Data with the Quick Analysis Tool: Read and do pages EX167 to EX169 and watch this video to help–show me before continuing
  4. Working with Dates and Date Functions: Read and do pages EX169 to EX170 and watch this video to help–show me before continuing
  5. Using Lookup Functions: Read and do pages EX171 to EX174 and watch this video to help–show me before continuing
  6. Working with Logical Functions: Read and do pages EX174 to EX179 and watch this video to help–show me before continuing