Excel: Working with Non-Numeric Data Asset List
- Current folder path within the WCMS: /training/exlnnd/files/pc
- Title Code: exlnnd
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/exlnnd
- Expand Course URL: false
Expand the accordions to see the lists of assets and their properties.
Excel: Working with Non-Numeric Data: Pages: 10 total
Learn about and create a data validation rule.
- Asset Path: /training/exlnnd/files/pc/working-with-data-validation
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/files/pc/working-with-data-validation
- Asset System Name: working-with-data-validation
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Combine two columns into a single column.
- Asset Path: /training/exlnnd/files/pc/using-the-concat-function
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Separate data in a single column to multiple columns.
- Asset Path: /training/exlnnd/files/pc/splitting-cell-contents
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to apply specialized cell formattings such as zip codes and custom number formats.
- Asset Path: /training/exlnnd/files/pc/utilizing-special-cell-formats
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Explore ways to work with dates in Excel.
- Asset Path: /training/exlnnd/files/pc/working-with-dates
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to bring external data into Excel.
- Asset Path: /training/exlnnd/files/pc/working-with-external-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/files/pc/working-with-external-data
- Asset System Name: working-with-external-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to move and copy worksheets, rearrange worksheet tabs, and use data from another worksheet.
- Asset Path: /training/exlnnd/files/pc/working-across-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/files/pc/working-across-worksheets
- Asset System Name: working-across-worksheets
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to copy and paste only visible data.
- Asset Path: /training/exlnnd/files/pc/copying-visible-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Remove duplicate data and see the remaining unique values.
- Asset Path: /training/exlnnd/files/pc/removing-duplicate-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Excel: Working with Non-Numeric Data: : 2 total
Excel: Working with Non-Numeric Data: Files: 0 total
Excel: Working with Non-Numeric Data Asset List
- Current folder path within the WCMS: /training/exlnnd/files/pc
- Title Code: exlnnd
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/exlnnd
- Expand Course URL: false
Expand the accordions to see the lists of assets and their properties.
Excel: Working with Non-Numeric Data: Pages: 10 total
Learn about and create a data validation rule.
- Asset Path: /training/exlnnd/files/pc/working-with-data-validation
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/files/pc/working-with-data-validation
- Asset System Name: working-with-data-validation
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Combine two columns into a single column.
- Asset Path: /training/exlnnd/files/pc/using-the-concat-function
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Separate data in a single column to multiple columns.
- Asset Path: /training/exlnnd/files/pc/splitting-cell-contents
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to apply specialized cell formattings such as zip codes and custom number formats.
- Asset Path: /training/exlnnd/files/pc/utilizing-special-cell-formats
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Explore ways to work with dates in Excel.
- Asset Path: /training/exlnnd/files/pc/working-with-dates
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to bring external data into Excel.
- Asset Path: /training/exlnnd/files/pc/working-with-external-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/files/pc/working-with-external-data
- Asset System Name: working-with-external-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to move and copy worksheets, rearrange worksheet tabs, and use data from another worksheet.
- Asset Path: /training/exlnnd/files/pc/working-across-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/files/pc/working-across-worksheets
- Asset System Name: working-across-worksheets
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
See how to copy and paste only visible data.
- Asset Path: /training/exlnnd/files/pc/copying-visible-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From:
Remove duplicate data and see the remaining unique values.
- Asset Path: /training/exlnnd/files/pc/removing-duplicate-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exlnnd/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: Tue Apr 04 16:33:29 EDT 2023
- Last Published By: blnolen
- Linked From: