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
    FREE ACCESS
  • Locked
    4. 
    Using data from multiple sheets
    4m 10s
    FREE ACCESS
  • Locked
    5. 
    Calculating with constant values
    5m 34s
    FREE ACCESS
  • Locked
    6. 
    Using cell references indirectly
    3m 38s
    FREE ACCESS
  • Locked
    7. 
    Inserting drop-down menus
    4m 22s
    FREE ACCESS
  • Locked
    8. 
    Inserting menus with predefined options
    4m 33s
    FREE ACCESS
  • Locked
    9. 
    Validating your data
    5m 32s
    FREE ACCESS
  • Locked
    10. 
    Inserting checkboxes
    4m 17s
    FREE ACCESS

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

COURSE Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Likes  0
COURSE Performing Conditional Calculations
Likes  0
COURSE VBA: Getting Started with VBA in Excel
Likes  44