Referencing & Managing Data
Google Sheets 2020
| Intermediate
- 10 Videos | 50m 43s
- 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 cells
work with absolute, relative and mixed cell references
work with data ranges
work with data from different sheets
calculate totals with constant values -
use cell references indirectly
use cell references to create drop-down menus
create menus with cell references
use data validation to create menus
use data ranges to insert checkboxes
IN THIS COURSE
-
1.Referencing cells5m 27sUP NEXT
-
2.Using absolute, mixed & relative cell references5m 31s
-
3.Defining a new data range3m 1s
-
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.
