From the course: Google Sheets Essential Training
Join today to access over 24,900 courses taught by industry experts.
Using formulas and functions - Sheets Tutorial
From the course: Google Sheets Essential Training
Using formulas and functions
- [Instructor] Using formulas and functions in Google Sheets allows you to perform basic math calculations, such as adding, subtracting, multiplying, or dividing the contents of cells. You can also perform more sophisticated calculations with Google Sheets' built-in functions. A formula is the mathematical equation that's used to calculate the result. A function is used inside a formula and is sort of a code that's built into Google Sheets that makes the formula much easier to write. First, let's walk through how to create a formula that uses one of the built-in functions available in Google Sheets. I'll show you using this Sales spreadsheet. The first thing you'll want to do before you start adding formulas to your spreadsheet is make sure that the formula bar is visible. First, select any cell in your spreadsheet. Next, go to the View menu, select Show, and make sure that the formula bar is checked. You'll see a bar up here at the top of your sheet with a light gray fx icon on the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.