Using Basic Formulas

Google Sheets 2020
  • 11 Videos | 45m 53s
  • Includes Assessment
  • Earns a Badge
Likes 10
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
    5m 5s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    4m 10s
  • Locked
    3. 
    Repeating your formula within your spreadsheet
    4m 31s
  • Locked
    4. 
    Creating automated cumulative totals
    3m 19s
  • Locked
    5. 
    Changing number units
    3m 5s
  • Locked
    6. 
    Factorizing the results of a division
    3m 8s
  • Locked
    7. 
    Counting cells in a range
    2m 57s
  • Locked
    8. 
    Ranking a value
    4m 12s
  • Locked
    9. 
    Rounding numbers
    5m 52s
  • Locked
    10. 
    Using replacement formulas
    4m 38s
  • Locked
    11. 
    Generating random numbers
    4m 57s

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.