Using Basic Formulas in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 11 Videos | 45m 20s
  • Includes Assessment
  • Earns a Badge
Likes 43 Likes 43
This course will focus on manipulating data and performing basic calculations using formulas in Google Sheets. First, discover how to manually select and use formulas in a cell, as well as to get access to the full list of functions available in Google Sheets. You will also see how to copy formulas to quickly fill out a table. Other functions will allow you to rank, count, and round values in a sheet. Google Sheets' functions are useful for manipulating text as well. For example, to replace specific characters or a text string. Finally, learn how to create formulas to generate random numbers and remove whitespace.

WHAT YOU WILL LEARN

  • get access to the function library to create formulas
    perform basic calculations with operators and functions
    re-use formulas to copy values and perform calculations
    get cumulative totals
    convert numbers to binary, hexadecimal or decimal formats
    obtain the quotient and remainder in a division
  • count a full list of values or specific items in a list
    rank values and find the smallest or largest values in a list
    use different functions to round a value
    use functions to replace characters and remove whitespace
    use formulas to generate random values

IN THIS COURSE

  • Playable
    1. 
    Selecting & using formulas in Google Sheets 2020
    5m 2s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations in Google Sheets 2020
    4m 7s
  • Locked
    3. 
    Repeating your formula within your spreadsheet in Google Sheets 2020
    4m 28s
  • Locked
    4. 
    Creating automated cumulative totals in Google Sheets 2020
    3m 16s
  • Locked
    5. 
    Changing number units in Google Sheets 2020
    3m 2s
  • Locked
    6. 
    Factorizing the results of a division in Google Sheets 2020
    3m 5s
  • Locked
    7. 
    Counting cells in a range in Google Sheets 2020
    2m 54s
  • Locked
    8. 
    Ranking a value in Google Sheets 2020
    4m 9s
  • Locked
    9. 
    Rounding numbers in Google Sheets 2020
    5m 49s
  • Locked
    10. 
    Using replacement formulas in Google Sheets 2020
    4m 35s
  • Locked
    11. 
    Generating random numbers in Google Sheets 2020
    4m 54s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 219 Likes 219  
Likes 33 Likes 33  
Likes 3892 Likes 3892