Using Formulas to Calculate & Manage Data in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 10 videos | 45m 40s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
Discover how to use Google Sheets for common tasks like calculating the interest on a loan and comparing loans. This course will also teach you how to build formulas to find and manage duplicate values in your spreadsheets. Google Sheets includes built-in formulas to extract and analyze data. Learn how to work with some of these formulas on both data and text values, and use the LOOKUP and VLOOKUP formulas.

WHAT YOU WILL LEARN

  • calculate the interest of a loan
    compare loans
    use SUMPRODUCT and COUNTIF to find duplicate values
    use COUNTA, SUMPRODUCT and COUNTIF functions to find duplicates
    locate duplicate entries with formulas
  • use formulas to avoid duplicate values
    use database functions in a spreadsheet
    perform calculations in a database
    find a value in a double-entry table
    search for a value across two tables

IN THIS COURSE

  • Playable
    1.  Calculating the interest on a loan in Google Sheets 2020
    5m 40s
    Use Google Sheets formulas to calculate how much it will cost to pay back a loan. For example, use the PMT function to calculate the total payment per period. To get more details on the interest you will pay in a specific… FREE ACCESS
  • Playable
    2.  Comparing loans in Google Sheets 2020
    5m 44s
    In the previous video, you saw that it is not difficult to calculate loan payment information. By using formulas to calculate these values, you can change constants without having to worry about updating cells that… FREE ACCESS
  • Locked
    3.  Finding duplicate values in your spreadsheet in Google Sheets 2020
    3m 23s
    Combining the SUMPRODUCT and COUNTIF functions in Google Sheets can help you to find identical values in your spreadsheet. This can be very useful if you need to tidy up your data tables and remove duplicates. FREE ACCESS
  • Locked
    4.  Finding duplicates in your document in Google Sheets 2020
    4m 16s
    The COUNTA function will return the number of non-empty cells in a data range. If you combine this calculation with the SUMPRODUCT and COUNTIF functions in Google Sheets, you can obtain the number of different values in a… FREE ACCESS
  • Locked
    5.  Managing duplicate entries in Google Sheets 2020
    3m 6s
    If you have a lot of data in your spreadsheet and you are worried about duplicate entries, you can use Google Sheets formulas to locate them for you. This tutorial will show you how to use the UNIQUE function and the… FREE ACCESS
  • Locked
    6.  Avoiding duplicate values in Google Sheets 2020
    3m 53s
    If you want to be sure that users only enter unique values in your data table, you can tell Google Sheets to block duplicates and display an error message. To do this, you will need to know how to use the data validation… FREE ACCESS
  • Locked
    7.  Finding data in a database in Google Sheets 2020
    5m 48s
    If you have a complex table containing a large number of different data types, you can use the Google Sheets database formulas to extract the information you need. You will find functions such as DGET, DBMIN, and DMAX… FREE ACCESS
  • Locked
    8.  Performing calculations using your database in Google Sheets 2020
    4m 36s
    Tables created in Google Sheets can be used as simplified databases. In this video, learn how to use functions such as DSUM, DAVERAGE, DSTDEV, and DSTDEVP to analyze the data found in your spreadsheet. FREE ACCESS
  • Locked
    9.  Finding a value in a double-entry table in Google Sheets 2020
    5m 48s
    You can use the LOOKUP function to find a value in a double-entry table that you have created in Google Sheets. You can, for example, use it to find a customer's address based on their last name. You can also use the… FREE ACCESS
  • Locked
    10.  Performing a search across two tables in Google Sheets 2020
    3m 26s
    In Google Sheets, you can use a calculation combining the IF and VLOOKUP functions to search for a value in two separate data tables. This is very useful if you want to consult multiple data sources and use them to… 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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1788 Likes 1788  
Likes 11 Likes 11