### Google Sheets: Using Basic Formulas

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description

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.

Expected Duration (hours)
0.8

Lesson Objectives

• 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
• Course Number:
ds_gshee20_09_enus

Expertise Level
Intermediate