Performing Conditional Calculations in Google Sheets 2020

Google Sheets 2020    |    Expert
  • 9 Videos | 39m 12s
  • Includes Assessment
  • Earns a Badge
Likes 7 Likes 7
Conditional formulas let you perform a calculation on a range of values by specifying the criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Google Sheets. In this course, you will also learn how to use conditional formulas to translate data or to keep your information up to date.

WHAT YOU WILL LEARN

  • use conditional formulas with multiple criteria
    build a conditional sum formula
    create a conditional formula to display specific messages
    create conditional formulas to display and calculate values
    build conditional formulas with AND and OR functions
  • translate data using conditional formulas
    use MATCH and OFFSET functions to find specific values
    use COUNTA and OFFSET functions to keep a table up to date
    use SUMPRODUCT function to create automatic reports

IN THIS COURSE

  • Playable
    1. 
    Using conditional formulas in Google Sheets 2020
    4m 2s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional sum formula in Google Sheets 2020
    4m 59s
  • Locked
    3. 
    Creating multiple conditions in Google Sheets 2020
    5m 6s
  • Locked
    4. 
    Performing complex conditional formulas in Google Sheets 2020
    4m 44s
  • Locked
    5. 
    Using IF & OR in conditional formulas in Google Sheets 2020
    4m 3s
  • Locked
    6. 
    Viewing data in different languages in Google Sheets 2020
    4m 26s
  • Locked
    7. 
    Using reference positions in conditional formulas in Google Sheets 2020
    4m 12s
  • Locked
    8. 
    Keeping your table updated with conditional formulas in Google Sheets 2020
    3m 25s
  • Locked
    9. 
    Creating automatic reports in Google Sheets 2020
    4m 16s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 123 Likes 123