Referencing & Managing Data in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 10 videos | 47m 30s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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.


  • 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


  • 5m 27s
    If you want to use the contents of a cell or range of cells, you'll need to tell Google Sheets where to find the values or data. In other words, you'll need to create a cell reference. Learn how to correctly reference cells in your spreadsheet. FREE ACCESS
  • 5m 31s
    Moving or automating a formula in Google Sheets will automatically adjust the cell references that it contains. Any references to cells, columns and rows contained in these formulas are known as relative cell references. If you want to avoid adjustments being made to your formula's cell references, you can learn how to use the dollar sign ($). FREE ACCESS
  • Locked
    3.  Using and managing data ranges in Google Sheets 2020
    4m 49s
    If you want to use data in your Google Sheets later on, you may find it useful to save them to your document's values list. Using this list, lets you define your own data range - effectively the data entries between two points - which can then be referenced in formulas you insert into your spreadsheet. FREE ACCESS
  • Locked
    4.  Using data from multiple sheets in Google Sheets 2020
    4m 7s
    Having multiple worksheets is useful if you want to use data in numerous locations without having to manually reinsert the same data into a new file. Find out how to use data across more than one sheet in Google Sheets. This will give you the tools to create your own summary sheets, and insert formulas using data contained elsewhere. FREE ACCESS
  • Locked
    5.  Calculating with constant values in Google Sheets 2020
    5m 31s
    Constants are values we often use in a spreadsheet. Instead of entering these values each time they're needed, you can simply name the value and then type in the name when necessary. If the constant needs to be modified, all you have to do is find it in the sheet, change the value and let Google Sheets automatically update the change wherever the constant appears in your sheet. FREE ACCESS
  • Locked
    6.  Using cell references indirectly in Google Sheets 2020
    3m 35s
    The INDIRECT formula can be used In Google Sheets to refer to a cell indirectly. This can be very useful if you want to manipulate the data referenced in certain formulas in your spreadsheet without having to adjust it manually. This is especially helpful for creating a summary using values found in various worksheets. FREE ACCESS
  • Locked
    7.  Inserting drop-down menus in Google Sheets 2020
    4m 19s
    The ability to share your document with others means that there may be multiple users working on the same document. If you want to maintain control over the information inserted into your spreadsheet, you can create customized drop-down menus from which your collaborators can choose the required response. This can ensure that only authorized data is added to your Google Sheets document. FREE ACCESS
  • Locked
    8.  Inserting menus with predefined options in Google Sheets 2020
    4m 30s
    In order to create your own drop-down menus, you can use predefined data lists. This tutorial will show you how to use data ranges in order to extract the entries for your customized menus in Google Sheets. FREE ACCESS
  • Locked
    9.  Validating your data in Google Sheets 2020
    5m 29s
    In Google Sheets you can share your spreadsheet documents with other individuals, who can then add data of their own. To ensure that your collaborators only add authorized data entries, you can set up a data validation system. This allows you to set up an alert that appears if a collaborator makes an unauthorized data entry in your spreadsheet. FREE ACCESS
  • Locked
    10.  Inserting checkboxes in Google Sheets 2020
    4m 14s
    Checkboxes can be used to visualize a binary choice or toggle when managing data entries in your spreadsheet. Checkboxes can be inserted into individual cells or selected data ranges, or as part of a data validation rule in Google Sheets. FREE ACCESS


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.


Likes 112 Likes 112  
Likes 43 Likes 43  
Likes 111 Likes 111