Using Basic Formulas

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

YOU MIGHT ALSO LIKE

Likes 8 Likes 8  
Likes 5 Likes 5  
Likes 0 Likes 0