# Using Basic Formulas

• 11 Videos | 45m 20s
• Includes Assessment
Likes 10
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.

## WHAT YOU WILL LEARN

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

• 1.
Selecting & using formulas
• 2.
Performing simple calculations
• 3.
• 4.
Creating automated cumulative totals
• 5.
Changing number units
• 6.
Factorizing the results of a division
• 7.
Counting cells in a range
• 8.
Ranking a value
• 9.
Rounding numbers
• 10.
Using replacement formulas
• 11.
Generating random numbers

## 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.

Likes 91