Performing calculations in Sheets 2022

Google Sheets 2022    |    Expert
  • 10 videos | 41m 12s
  • Includes Assessment
  • Earns a Badge
Rating 4.9 of 11 users Rating 4.9 of 11 users (11)
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

  • Discover the key concepts covered in the performing calculations in sheets 2022 course
    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 if, and and or functions
    Translate data using conditional formulas
    Use match, sum and offset functions to find specific values
    Use counta, offset & average functions to keep a table up to date
    Use sumproduct function to create automatic reports

IN THIS COURSE

  • 1m 6s
    This video outlines the key content covered in Performing calculations in Sheets 2022 course, including using conditional formulas, viewing data in different languages, and creating automatic reports. FREE ACCESS
  • 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. In Google Sheets, you can create both simple and complex conditional formulas. FREE ACCESS
  • Locked
    3.  Inserting a conditional sum formula in Sheets 2022
    4m 50s
    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
  • Locked
    4.  Creating multiple conditions in Sheets 2022
    4m 29s
    In Google Sheets, you can create a formula to return more than two possible messages. You will, however, need to embed multiple IF functions within one another to obtain multiple result options. FREE ACCESS
  • Locked
    5.  Performing complex conditional formulas in Sheets 2022
    5m 15s
    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
  • Locked
    6.  Using IF, OR & AND in conditional formulas in Sheets 2022
    4m 2s
    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
  • Locked
    7.  Viewing data in different languages in Sheets 2022
    5m 17s
    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
  • Locked
    8.  Using reference positions in conditional formulas in Sheets 2022
    4m 8s
    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 can also combine the SUM and OFFSET functions to get totals for values meeting specific criteria. FREE ACCESS
  • Locked
    9.  Keeping your table updated with conditional formulas in Sheets 2022
    3m 58s
    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
  • Locked
    10.  Creating automatic reports in Sheets 2022
    4m 5s
    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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Rating 4.4 of 37 users Rating 4.4 of 37 users (37)
Rating 4.3 of 1578 users Rating 4.3 of 1578 users (1578)