Using Formulas to Calculate & Manage Data

Google Sheets 2020
  • 10 Videos | 50m 40s
  • Includes Assessment
  • Earns a Badge
Likes 1 Likes 1
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
    5m 40s
    UP NEXT
  • Playable
    2. 
    Comparing loans
    5m 44s
  • Locked
    3. 
    Finding duplicate values in your spreadsheet
    3m 23s
  • Locked
    4. 
    Finding duplicates in your document
    4m 16s
  • Locked
    5. 
    Managing duplicate entries
    3m 6s
  • Locked
    6. 
    Avoiding duplicate values
    3m 53s
  • Locked
    7. 
    Finding data in a database
    5m 48s
  • Locked
    8. 
    Performing calculations using your database
    4m 36s
  • Locked
    9. 
    Finding a value in a double-entry table
    5m 48s
  • Locked
    10. 
    Performing a search across two tables
    3m 26s

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.

YOU MIGHT ALSO LIKE

Likes 1 Likes 1  
Likes 0 Likes 0  
Likes 1 Likes 1