SkillSoft Explore Course – Lambers, Inc.

Productivity & Collaboration Tools Google Google Apps Google Sheets 2020

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.

Asset ID	ds_gshee20_09_enus
Course Type	Video Course
Course Category	Google

Objectives
Google Sheets: Using Basic Formulas 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

Objectives

Google Sheets: Using Basic Formulas

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