Referencing & Managing Data in Google Sheets 2020

IN THIS COURSE

• 1.  Referencing cells in Google Sheets 2020
  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
• 2.  Using absolute, mixed & relative cell references in Google Sheets 2020
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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