Referencing & Managing Data
Google Sheets 2020
| Intermediate
- 10 Videos | 47m 30s
- Includes Assessment
- Earns a Badge
While working in Google Sheets, you will often use a cell value in a formula or another location. Discover how to use absolute, mixed, and relative cell references in formulas or to extract values from other cells. These cell references will also be useful to create a formula with data from multiple sheets. Lastly, learn how to define data ranges for creating different types of menus using the data validation tool.
WHAT YOU WILL LEARN
-
insert references to cellswork with absolute, relative and mixed cell referenceswork with data rangeswork with data from different sheetscalculate totals with constant values
-
use cell references indirectlyuse cell references to create drop-down menuscreate menus with cell referencesuse data validation to create menususe data ranges to insert checkboxes
IN THIS COURSE
-
1.Referencing cells5m 27sUP NEXT
-
2.Using absolute, mixed & relative cell references5m 31s
-
3.Using and managing data ranges in Google Sheets4m 49s
-
4.Using data from multiple sheets4m 7s
-
5.Calculating with constant values5m 31s
-
6.Using cell references indirectly3m 35s
-
7.Inserting drop-down menus4m 19s
-
8.Inserting menus with predefined options4m 30s
-
9.Validating your data5m 29s
-
10.Inserting checkboxes4m 14s
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.