From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Enter and edit a formula - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Enter and edit a formula
- [Instructor] Formulas you create in Google Sheets let you summarize the data contained in your worksheets. Which in turn helps you discover important information about your business. In this movie I will show you how to create and edit formulas in your worksheet. I have two pieces of yearly revenue information in this workbook. That's revenue for years 2016 and 2017. If I want to create a formula that finds the sum or total of those two values. Then, I have a number of ways that I can do it. The first is to click in cell B6, which is next to my total label, and then type an equal sign. Every formula that you create in Sheets must start with an equal sign. And you can't have a space before it either. If you create a formula the equal sign must be the first character in the cell. Once you've done that you have a couple of options. This first is that you can add the values together based on the cell references. So for example the values that are in B4 and B5. To do B4 I can type in B4…
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.