# Managing & calculating data in Sheets 2022

Google Sheets 2022    |    Intermediate
• 11 videos | 45m 31s
• Includes Assessment
• Earns a Badge
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. You will explore how to find data in a database, as well as perform calculations using your database. Lastly, you will be able to find a value in a double-entry table and perform a search across two tables.

## WHAT YOU WILL LEARN

• Discover the key concepts covered in the managing & calculating data in sheets 2022 course
Calculate the interest of a loan
Compare loans
Use sumproduct and countif to find duplicate values
Use counta, sumproduct and countif functions to count 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

• This video outlines the key content covered in Managing & calculating data in Sheets 2022 course, including comparing loans, avoiding duplicate values, and performing a search across two tables.
• 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 period, use the IPMT function. Lastly, you can also use the PPMT function to know how much you will reimburse in a specific period.
• 3.  Comparing loans in Sheets 2022
It is not difficult to calculate loan payment information in Google Sheets. By using formulas to calculate these values, you can change constants without having to worry about updating cells that reference them. You can then use autofill to quickly apply the formulas to more than one cell. Google Sheets allows you to take things one step further and compare two loan types and choose the one that is right for you.
• 4.  Finding duplicate values in your spreadsheet in Sheets 2022
Combining the SUMPRODUCT and COUNTIF functions in Google Sheets can identify identical values in your spreadsheet. These two functions are used to count unique values within a table and duplicate values if two data ranges from different tables are compared. This can be very useful if you need to tidy up your data tables and remove duplicates.
• 5.  Counting the total number of duplicates in Sheets 2022
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 range. This data can then be used to work out the number of duplicates that your data table contains.
• 6.  Managing duplicate entries in Sheets 2022
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. You can use the UNIQUE function and the Remove duplicates tool to clean your data.
• 7.  Avoiding duplicate values in Sheets 2022
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 tools.
• 8.  Finding data in a database in Sheets 2022
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, DMIN, and DMAX very helpful when it comes to analyzing your data.
• 9.  Performing calculations using your database in Sheets 2022
Tables created in Google Sheets can be used as simplified databases. You can use functions such as DSUM, DAVERAGE, DSTDEV, and DSTDEVP to analyze the data found in your spreadsheet.
• 10.  Finding a value in a double-entry table in Sheets 2022
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 INDEX formula to return a particular value in a table if you know its row and column coordinates, and use the MATCH function to find a position of an item.
• 11.  Performing a search across two tables in Sheets 2022
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 automatically complete a summary table.

## 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.