Referencing & Managing Data

Google Sheets 2020    |    Intermediate
  • 10 Videos | 50m 43s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 4
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

  • Playable
    1. 
    Referencing cells
    5m 27s
    UP NEXT
  • Playable
    2. 
    Using absolute, mixed & relative cell references
    5m 31s
  • Locked
    3. 
    Defining a new data range
    3m 1s
  • Locked
    4. 
    Using data from multiple sheets
    4m 7s
  • Locked
    5. 
    Calculating with constant values
    5m 31s
  • Locked
    6. 
    Using cell references indirectly
    3m 35s
  • Locked
    7. 
    Inserting drop-down menus
    4m 19s
  • Locked
    8. 
    Inserting menus with predefined options
    4m 30s
  • Locked
    9. 
    Validating your data
    5m 29s
  • Locked
    10. 
    Inserting checkboxes
    4m 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.

YOU MIGHT ALSO LIKE

Likes 3 Likes 3  
Likes 6 Likes 6  
Likes 9 Likes 9