Google Sheets: Basic Formulas

Expected Duration
Lesson Objectives
Course Number
Expertise Level


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)

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:

    Expertise Level