Referencing & Managing Data

Google Sheets 2020
  • 10 Videos | 46m 13s
  • Includes Assessment
  • Earns a Badge
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 30s
    UP NEXT
  • Playable
    2. 
    Using absolute, mixed & relative cell references
    5m 34s
  • Locked
    3. 
    Defining a new data range
    3m 4s
  • Locked
    4. 
    Using data from multiple sheets
    4m 10s
  • Locked
    5. 
    Calculating with constant values
    5m 34s
  • Locked
    6. 
    Using cell references indirectly
    3m 38s
  • Locked
    7. 
    Inserting drop-down menus
    4m 22s
  • Locked
    8. 
    Inserting menus with predefined options
    4m 33s
  • Locked
    9. 
    Validating your data
    5m 32s
  • Locked
    10. 
    Inserting checkboxes
    4m 17s

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.