Intermediate Formulas

Intermediate Formulas

About this course

Within these lessons, you will learn about functions like Nested IF, SUMIF, COUNTIF, SUMIFS, COUNTIFS, VLOOKUP, INDEX and MATCH, as well as how to use these functions across multiple sheets.

Curriculum

  • Introduction
  • Nested IF
  • Cross-sheet Formulas
  • VLOOKUP
  • INDEX/MATCH
  • COUNTIFS
  • SUMIFS
  • Wrap-up
  • Course Evaluation

About this course

Within these lessons, you will learn about functions like Nested IF, SUMIF, COUNTIF, SUMIFS, COUNTIFS, VLOOKUP, INDEX and MATCH, as well as how to use these functions across multiple sheets.

Curriculum

  • Introduction
  • Nested IF
  • Cross-sheet Formulas
  • VLOOKUP
  • INDEX/MATCH
  • COUNTIFS
  • SUMIFS
  • Wrap-up
  • Course Evaluation