Using basic formulas in Sheets 2022

Google Sheets 2022    |    Intermediate
  • 12 Videos | 46m 38s
  • Earns a Badge
This course will focus on manipulating data and performing calculations using basic formulas in Google Sheets. First, discover how to manually select and use formulas in a cell, as well as get access to the full list of functions available in Google Sheets. You will also learn how to perform simple calculations and 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

  • discover the key concepts covered in the Using basic formulas in Sheets 2022 course
    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. 
    Overview: Using basic formulas in Sheets 2022
    57s
    UP NEXT
  • Playable
    2. 
    Selecting & using formulas in Sheets 2022
    5m 17s
  • Locked
    3. 
    Performing simple calculations in Sheets 2022
    4m 40s
  • Locked
    4. 
    Repeating your formula within your spreadsheet in Sheets 2022
    4m 19s
  • Locked
    5. 
    Creating automated cumulative totals in Sheets 2022
    3m 36s
  • Locked
    6. 
    Changing number units in Sheets 2022
    3m 26s
  • Locked
    7. 
    Factorizing the results of a division in Sheets 2022
    3m 17s
  • Locked
    8. 
    Counting cells in a range in Sheets 2022
    3m 20s
  • Locked
    9. 
    Ranking a value in Sheets 2022
    4m 5s
  • Locked
    10. 
    Rounding numbers in Sheets 2022
    5m 13s
  • Locked
    11. 
    Using replacement formulas in Sheets 2022
    3m 58s
  • Locked
    12. 
    Generating random numbers in Sheets 2022
    4m 32s

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