Using data in Sheets 2022

Google Sheets 2022    |    Intermediate
  • 12 videos | 53m 32s
  • 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, such as drop-down menus, using the data validation tool.

WHAT YOU WILL LEARN

  • discover the key concepts covered in the Using data in Sheets 2022 course
    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
    preview and manage Office files in Sheets 2022

IN THIS COURSE

  • Playable
    1.  Overview: Using data in Sheets 2022
    59s
    This video outlines the key content covered in Using data in Sheets 2022 course including referencing cells, defining a new data range, and inserting checkboxes. FREE ACCESS
  • Playable
    2.  Referencing cells in Sheets 2022
    4m 50s
    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. It is important to correctly… FREE ACCESS
  • Locked
    3.  Using absolute, mixed & relative cell references in Sheets 2022
    5m 6s
    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.… FREE ACCESS
  • Locked
    4.  Defining a new data range in Sheets 2022
    5m 1s
    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, you can define your own data range which can then be referenced in formulas… FREE ACCESS
  • Locked
    5.  Using data from multiple sheets in Sheets 2022
    5m 13s
    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. You can use data across more than one sheet in Google Sheets. This will… FREE ACCESS
  • Locked
    6.  Calculating with constant values in Sheets 2022
    5m 44s
    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… FREE ACCESS
  • Locked
    7.  Using cell references indirectly in Sheets 2022
    4m 3s
    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… FREE ACCESS
  • Locked
    8.  Inserting drop-down menus in Sheets 2022
    5m
    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… FREE ACCESS
  • Locked
    9.  Inserting menus with predefined options in Sheets 2022
    5m 9s
    In order to create your own drop-down menus, you can use predefined data lists. You can use data ranges in order to extract the entries for your customized menus in Google Sheets. You are also able to edit and remove… FREE ACCESS
  • Locked
    10.  Validating your data in Sheets 2022
    5m 11s
    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… FREE ACCESS
  • Locked
    11.  Inserting checkboxes in Sheets 2022
    3m 56s
    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… FREE ACCESS
  • Locked
    12.  Viewing embedded Office files in Sheets 2022
    3m 20s
    In Google Sheets, you can view embedded Microsoft Office files in your sheet. You are able to view files in preview mode as well as copy or edit the link to the file directly in Drive. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.