Performing Conditional Calculations
Google Sheets 2020
| Expert
- 9 Videos | 39m 12s
- Includes Assessment
- Earns a Badge
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 criteriabuild a conditional sum formulacreate a conditional formula to display specific messagescreate conditional formulas to display and calculate valuesbuild conditional formulas with AND and OR functions
-
translate data using conditional formulasuse MATCH and OFFSET functions to find specific valuesuse COUNTA and OFFSET functions to keep a table up to dateuse SUMPRODUCT function to create automatic reports
IN THIS COURSE
-
1.Using conditional formulas4m 2sUP NEXT
-
2.Inserting a conditional sum formula4m 59s
-
3.Creating multiple conditions5m 6s
-
4.Performing complex conditional formulas4m 44s
-
5.Using IF & OR in conditional formulas4m 3s
-
6.Viewing data in different languages4m 26s
-
7.Using reference positions in conditional formulas4m 12s
-
8.Keeping your table updated with conditional formulas3m 25s
-
9.Creating automatic reports4m 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.