Performing Conditional Calculations in Google Sheets 2020

IN THIS COURSE

• 1.  Using conditional formulas in Google Sheets 2020
  4m 2s
  If you only want to use data which corresponds to certain criteria that you have specified, then you can use the IF and AND functions to create conditional formulas. Learn how to build a conditional formula in Google Sheets. FREE ACCESS
• 2.  Inserting a conditional sum formula in Google Sheets 2020
  4m 59s
  In Google Sheets, you can use the SUMIF and SUMIFS functions to perform a sum calculation on certain data values in your range. All you need to know is how to specify the conditions that your qualifying data values have to meet. These tools can be very useful when creating subtotals. FREE ACCESS
• 3.  Creating multiple conditions in Google Sheets 2020
  5m 6s
  Learn how to create a formula to return more than two possible messages in Google Sheets. You will, however, need to embed multiple IF functions within one another to obtain multiple result options. FREE ACCESS
• 4.  Performing complex conditional formulas in Google Sheets 2020
  4m 44s
  In Google Sheets, the IF function can be used in conjunction with other functions. You can create conditions based on calculations, and analyze your data in a variety of different ways. FREE ACCESS
• 5.  Using IF & OR in conditional formulas in Google Sheets 2020
  4m 3s
  In Google Sheets, you can combine qualifying and alternative conditions in your IF formula. This can allow you to specify various different optional conditions that can be met when calculating a formula. FREE ACCESS
• 6.  Viewing data in different languages in Google Sheets 2020
  4m 26s
  In Google Sheets, you can use the IF and GOOGLETRANSLATE functions to create a table that can be viewed in two or more languages. Once you have inserted a dropdown list, you can use it as a button to quickly switch from one language to another. FREE ACCESS
• 7.  Using reference positions in conditional formulas in Google Sheets 2020
  4m 12s
  In Google Sheets, you may need to find a cell value by using its positional coordinates in the table. You can do this with the MATCH and OFFSET functions. You will also learn how to combine the SUM and OFFSET functions to get totals for values meeting specific criteria. FREE ACCESS
• 8.  Keeping your table updated with conditional formulas in Google Sheets 2020
  3m 25s
  If you are constantly updating your tables and adding new data entries to your Google Sheets worksheet, you can create conditional formulas to keep up to date with your new additions. Once you have inserted these calculations, using functions such as COUNTA or OFFSET, you won't need to modify them again or adjust the data ranges that they reference. FREE ACCESS
• 9.  Creating automatic reports in Google Sheets 2020
  4m 16s
  The SUMPRODUCT function can be used to perform a sum calculation on data that corresponds to particular criteria. You can, for example, use it to create an automatic data report in Google Sheets. FREE ACCESS