Google Sheets: Basic Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Manipulate data and perform calculations using formulas in Google Sheets. Discover how to select and use formulas; copy formulas; perform ranking, counting, and rounding; use replacement formulas on text; and generate random numbers.



Expected Duration (hours)
1.0

Lesson Objectives

Google Sheets: Basic Formulas

  • Selecting & using formulas
  • Performing simple calculations
  • Repeating your formula within your spreadsheet
  • Creating automated cumulative totals
  • Changing number units
  • Factorizing the results of a division
  • Counting cells in a range
  • Ranking a value
  • Rounding a number
  • Using replacement formulas
  • Generating random numbers
  • Inserting checkboxes

    • Course Number:
    ds_gshee16_08_09_enus

    Expertise Level
    Beginner