Course details

Google Sheets: Conditional Formulas

Google Sheets: Conditional Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Conditional formulas let you perform a calculation on a range of values by specifying criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Goggle Sheets.



Expected Duration (hours)
0.9

Lesson Objectives

Google Sheets: Conditional Formulas

  • Using conditional formulas
  • Inserting a conditional sum formula
  • Creating multiple conditions
  • Performing complex conditional formulas
  • Using IF & OR in conditional formulas
  • Using reference positions in conditional formulas
  • Keeping your table up to date with conditional formulas
  • Viewing data in different languages
  • Creating a multi-language version of your worksheet
  • Course Number:
    ds_gshee16_11_enus

    Expertise Level
    Intermediate