# Using data in Sheets 2022

• 12 videos | 53m 32s
• Includes Assessment
Rating 4.6 of 14 users (14)
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
Use data validation to create menus
Use data ranges to insert checkboxes
Preview and manage office files in sheets 2022

## IN THIS COURSE

• 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.
• 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 reference cells in your spreadsheet to get the results you are searching for.
• 3.  Using absolute, mixed & relative cell references in Sheets 2022
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 (\$).
• 4.  Defining a new data range in Sheets 2022
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 you insert into your spreadsheet.
• 5.  Using data from multiple sheets in Sheets 2022
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 give you the tools to create your own summary sheets, and insert formulas using data contained elsewhere.
• 6.  Calculating with constant values in Sheets 2022
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.
• 7.  Using cell references indirectly in Sheets 2022
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.
• 8.  Inserting drop-down menus in Sheets 2022
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.
• 9.  Inserting menus with predefined options in Sheets 2022
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 menus.
• 10.  Validating your data in Sheets 2022
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.
• 11.  Inserting checkboxes in Sheets 2022
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.
• 12.  Viewing embedded Office files in Sheets 2022
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.

## 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.

## YOU MIGHT ALSO LIKE

Rating 4.4 of 9 users (9)
Rating 4.5 of 16 users (16)
Rating 4.7 of 58 users (58)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 86 users (86)
Rating 4.3 of 12 users (12)
Rating 4.6 of 275 users (275)