Google Sheets: Working with Non-Numeric Data Asset List
- Current folder path within the WCMS: /training/gshnnd/files/pc
- Title Code: gshnnd
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/gshnnd
- Expand Course URL: https://expand.iu.edu/browse/ittraining/single/courses/gshnnd
Expand the accordions to see the lists of assets and their properties.
Google Sheets: Working with Non-Numeric Data: Pages: 10 total
Learn about and create a data validation rule.
- Asset Path: /training/gshnnd/files/pc/working-with-data-validation
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-with-data-validation
- Asset System Name: working-with-data-validation
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Combine two columns into a single column.
- Asset Path: /training/gshnnd/files/pc/using-the-concat-function
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/using-the-concat-function
- Asset System Name: using-the-concat-function
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Separate data in a single column to multiple columns.
- Asset Path: /training/gshnnd/files/pc/splitting-cell-contents
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/splitting-cell-contents
- Asset System Name: splitting-cell-contents
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to apply specialized cell formattings such as zip codes and custom number formats.
- Asset Path: /training/gshnnd/files/pc/utilizing-special-cell-formats
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/utilizing-special-cell-formats
- Asset System Name: utilizing-special-cell-formats
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Explore ways to work with dates in Google Sheets.
- Asset Path: /training/gshnnd/files/pc/working-with-dates
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-with-dates
- Asset System Name: working-with-dates
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to bring external data into Excel.
- Asset Path: /training/gshnnd/files/pc/working-with-external-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-with-external-data
- Asset System Name: working-with-external-data
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to move and copy worksheets, rearrange worksheet tabs, and use data from another worksheet.
- Asset Path: /training/gshnnd/files/pc/working-across-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-across-worksheets
- Asset System Name: working-across-worksheets
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Remove duplicate data and see the remaining unique values.
- Asset Path: /training/gshnnd/files/pc/removing-duplicate-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/removing-duplicate-data
- Asset System Name: removing-duplicate-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to copy and paste only visible data.
- Asset Path: /training/gshnnd/files/pc/copying-visible-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/copying-visible-data
- Asset System Name: copying-visible-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Google Sheets: Working with Non-Numeric Data: : 2 total
Google Sheets: Working with Non-Numeric Data: Files: 1 total
$asset.metadata.description
- Asset Path: /training/gshnnd/files/pc/img_TrashCan.png
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/img_TrashCan.png
- Asset System Name: img_TrashCan.png
- Asset Data Definition: $asset.dataDefinitionPath
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Google Sheets: Working with Non-Numeric Data Asset List
- Current folder path within the WCMS: /training/gshnnd/files/pc
- Title Code: gshnnd
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/gshnnd
- Expand Course URL: https://expand.iu.edu/browse/ittraining/single/courses/gshnnd
Expand the accordions to see the lists of assets and their properties.
Google Sheets: Working with Non-Numeric Data: Pages: 10 total
Learn about and create a data validation rule.
- Asset Path: /training/gshnnd/files/pc/working-with-data-validation
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-with-data-validation
- Asset System Name: working-with-data-validation
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Combine two columns into a single column.
- Asset Path: /training/gshnnd/files/pc/using-the-concat-function
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/using-the-concat-function
- Asset System Name: using-the-concat-function
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Separate data in a single column to multiple columns.
- Asset Path: /training/gshnnd/files/pc/splitting-cell-contents
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/splitting-cell-contents
- Asset System Name: splitting-cell-contents
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to apply specialized cell formattings such as zip codes and custom number formats.
- Asset Path: /training/gshnnd/files/pc/utilizing-special-cell-formats
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/utilizing-special-cell-formats
- Asset System Name: utilizing-special-cell-formats
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Explore ways to work with dates in Google Sheets.
- Asset Path: /training/gshnnd/files/pc/working-with-dates
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-with-dates
- Asset System Name: working-with-dates
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to bring external data into Excel.
- Asset Path: /training/gshnnd/files/pc/working-with-external-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-with-external-data
- Asset System Name: working-with-external-data
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to move and copy worksheets, rearrange worksheet tabs, and use data from another worksheet.
- Asset Path: /training/gshnnd/files/pc/working-across-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/working-across-worksheets
- Asset System Name: working-across-worksheets
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Remove duplicate data and see the remaining unique values.
- Asset Path: /training/gshnnd/files/pc/removing-duplicate-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/removing-duplicate-data
- Asset System Name: removing-duplicate-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to copy and paste only visible data.
- Asset Path: /training/gshnnd/files/pc/copying-visible-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/copying-visible-data
- Asset System Name: copying-visible-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Google Sheets: Working with Non-Numeric Data: : 2 total
Google Sheets: Working with Non-Numeric Data: Files: 1 total
$asset.metadata.description
- Asset Path: /training/gshnnd/files/pc/img_TrashCan.png
- Asset Link: site://IU-UITS-ITTRAIN.content/training/gshnnd/files/pc/img_TrashCan.png
- Asset System Name: img_TrashCan.png
- Asset Data Definition: $asset.dataDefinitionPath
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From: