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
-
59sThis 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
-
4m 50sIf 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. FREE ACCESS
-
3. Using absolute, mixed & relative cell references in Sheets 20225m 6sMoving 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
-
4. Defining a new data range in Sheets 20225m 1sIf 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. FREE ACCESS
-
5. Using data from multiple sheets in Sheets 20225m 13sHaving 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. FREE ACCESS
-
6. Calculating with constant values in Sheets 20225m 44sConstants 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
-
7. Using cell references indirectly in Sheets 20224m 3sThe 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
-
8. Inserting drop-down menus in Sheets 20225mThe 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
-
9. Inserting menus with predefined options in Sheets 20225m 9sIn 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. FREE ACCESS
-
10. Validating your data in Sheets 20225m 11sIn 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
-
11. Inserting checkboxes in Sheets 20223m 56sCheckboxes 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
-
12. Viewing embedded Office files in Sheets 20223m 20sIn 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.
