IU Only

Explore the Google Sheets interface.

• Asset Path: /training/gshbs/files/pc/introducing-google-sheets
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-google-sheets
• Asset System Name: introducing-google-sheets
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn how to identify text and numeric data.

• Asset Path: /training/gshbs/files/pc/exploring-types-of-data
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/exploring-types-of-data
• Asset System Name: exploring-types-of-data
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn about using formulas in Google Sheets, including syntax, operators, entering formulas, and copying and pasting formulas.

• Asset Path: /training/gshbs/files/pc/introducing-formulas
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-formulas
• Asset System Name: introducing-formulas
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore various ways to enter functions.

• Asset Path: /training/gshbs/files/pc/introducing-functions
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-functions
• Asset System Name: introducing-functions
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore absolute cell references.

• Asset Path: /training/gshbs/files/pc/working-with-absolute-references
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/working-with-absolute-references
• Asset System Name: working-with-absolute-references
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore how named ranges can be useful when working with data in a spreadsheet.

• Asset Path: /training/gshbs/files/pc/utilizing-named-ranges
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/utilizing-named-ranges
• Asset System Name: utilizing-named-ranges
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn about charts in Google Sheets and create a pie chart.

• Asset Path: /training/gshbs/files/pc/introducing-charts
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-charts
• Asset System Name: introducing-charts
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

See how to modify and update data.

• Asset Path: /training/gshbs/files/pc/updating-data
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/updating-data
• Asset System Name: updating-data
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn how to add a new worksheet to the workbook and add data using the autofill feature.

• Asset Path: /training/gshbs/files/pc/adding-a-worksheet
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/adding-a-worksheet
• Asset System Name: adding-a-worksheet
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

See how to insert blank columns and rows into a worksheet.

• Asset Path: /training/gshbs/files/pc/inserting-columns-and-rows
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/inserting-columns-and-rows
• Asset System Name: inserting-columns-and-rows
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Use the features of Google Sheets to sort and filter the data.

• Asset Path: /training/gshbs/files/pc/sorting-filtering-sheets
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/sorting-filtering-sheets
• Asset System Name: sorting-filtering-sheets
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore the Google Sheets interface.

• Asset Path: /training/gshbs/files/pc/introducing-google-sheets
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-google-sheets
• Asset System Name: introducing-google-sheets
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn how to identify text and numeric data.

• Asset Path: /training/gshbs/files/pc/exploring-types-of-data
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/exploring-types-of-data
• Asset System Name: exploring-types-of-data
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn about using formulas in Google Sheets, including syntax, operators, entering formulas, and copying and pasting formulas.

• Asset Path: /training/gshbs/files/pc/introducing-formulas
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-formulas
• Asset System Name: introducing-formulas
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore various ways to enter functions.

• Asset Path: /training/gshbs/files/pc/introducing-functions
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-functions
• Asset System Name: introducing-functions
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore absolute cell references.

• Asset Path: /training/gshbs/files/pc/working-with-absolute-references
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/working-with-absolute-references
• Asset System Name: working-with-absolute-references
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Explore how named ranges can be useful when working with data in a spreadsheet.

• Asset Path: /training/gshbs/files/pc/utilizing-named-ranges
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/utilizing-named-ranges
• Asset System Name: utilizing-named-ranges
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn about charts in Google Sheets and create a pie chart.

• Asset Path: /training/gshbs/files/pc/introducing-charts
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/introducing-charts
• Asset System Name: introducing-charts
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

See how to modify and update data.

• Asset Path: /training/gshbs/files/pc/updating-data
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/updating-data
• Asset System Name: updating-data
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Learn how to add a new worksheet to the workbook and add data using the autofill feature.

• Asset Path: /training/gshbs/files/pc/adding-a-worksheet
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/adding-a-worksheet
• Asset System Name: adding-a-worksheet
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

See how to insert blank columns and rows into a worksheet.

• Asset Path: /training/gshbs/files/pc/inserting-columns-and-rows
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/inserting-columns-and-rows
• Asset System Name: inserting-columns-and-rows
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From:

Use the features of Google Sheets to sort and filter the data.

• Asset Path: /training/gshbs/files/pc/sorting-filtering-sheets
• Asset Link: site://IU-UITS-ITTRAIN.content/training/gshbs/files/pc/sorting-filtering-sheets
• Asset System Name: sorting-filtering-sheets
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Apr 05 11:43:43 EDT 2023
  • Last Published By: blnolen
• Linked From: