Excel 2016: Data Management Asset List
- Current folder path within the WCMS: /training/exldm/files/pc
- Title Code: exldm
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/exldm
- Expand Course URL: false
Expand the accordions to see the lists of assets and their properties.
Excel 2016: Data Management: Pages: 12 total
See how to open a new workbook and name the worksheets.
- Asset Path: /training/exldm/files/pc/getting-started-with-data-management
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/getting-started-with-data-management
- Asset System Name: getting-started-with-data-management
- 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:
Explore how to group worksheets, summarize data across worksheets, and consolidate data.
- Asset Path: /training/exldm/files/pc/grouping-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/grouping-worksheets
- Asset System Name: grouping-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:
Learn how to import and clean up text from an external source.
- Asset Path: /training/exldm/files/pc/importing-and-cleaning-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/importing-and-cleaning-data
- Asset System Name: importing-and-cleaning-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:
Create and format an Excel table.
- Asset Path: /training/exldm/files/pc/working-with-tables-of-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/working-with-tables-of-data
- Asset System Name: working-with-tables-of-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:
Explore and create data validation criteria.
- Asset Path: /training/exldm/files/pc/validating-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/validating-data
- Asset System Name: validating-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:
Separate cell contents using a Wizard and combine cell contents using a formula.
- Asset Path: /training/exldm/files/pc/splitting-and-combining-cell-contents
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/splitting-and-combining-cell-contents
- Asset System Name: splitting-and-combining-cell-contents
- 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:
Explore how to protect an Excel worksheet as well as an entire workbook.
- Asset Path: /training/exldm/files/pc/protecting-your-work
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/protecting-your-work
- Asset System Name: protecting-your-work
- 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:
Create and use a custom list, work with the Name Manager, and utilize filters.
- Asset Path: /training/exldm/files/pc/using-the-auto-fill-feature
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/using-the-auto-fill-feature
- Asset System Name: using-the-auto-fill-feature
- 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:
Create and work with a PivotTable.
- Asset Path: /training/exldm/files/pc/introducing-pivot-tables
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/introducing-pivot-tables
- Asset System Name: introducing-pivot-tables
- 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:
Practice creating a PivotTable.
- Asset Path: /training/exldm/files/pc/challenge-exercise-creating-a-pivot-table
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/challenge-exercise-creating-a-pivot-table
- Asset System Name: challenge-exercise-creating-a-pivot-table
- 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:
Excel 2016: Data Management: : 2 total
- Asset Path: /training/exldm/files/pc/img
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/img
- Asset System Name: img
- Asset Data Definition: $asset.dataDefinitionPath
- Last modified by: litc
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: $asset.lastPublishedOn
- Last Published By: $asset.lastPublishedBy
- Linked From:
Excel 2016: Data Management: Files: 0 total
Excel 2016: Data Management Asset List
- Current folder path within the WCMS: /training/exldm/files/pc
- Title Code: exldm
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/exldm
- Expand Course URL: false
Expand the accordions to see the lists of assets and their properties.
Excel 2016: Data Management: Pages: 12 total
See how to open a new workbook and name the worksheets.
- Asset Path: /training/exldm/files/pc/getting-started-with-data-management
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/getting-started-with-data-management
- Asset System Name: getting-started-with-data-management
- 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:
Explore how to group worksheets, summarize data across worksheets, and consolidate data.
- Asset Path: /training/exldm/files/pc/grouping-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/grouping-worksheets
- Asset System Name: grouping-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:
Learn how to import and clean up text from an external source.
- Asset Path: /training/exldm/files/pc/importing-and-cleaning-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/importing-and-cleaning-data
- Asset System Name: importing-and-cleaning-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:
Create and format an Excel table.
- Asset Path: /training/exldm/files/pc/working-with-tables-of-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/working-with-tables-of-data
- Asset System Name: working-with-tables-of-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:
Explore and create data validation criteria.
- Asset Path: /training/exldm/files/pc/validating-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/validating-data
- Asset System Name: validating-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:
Separate cell contents using a Wizard and combine cell contents using a formula.
- Asset Path: /training/exldm/files/pc/splitting-and-combining-cell-contents
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/splitting-and-combining-cell-contents
- Asset System Name: splitting-and-combining-cell-contents
- 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:
Explore how to protect an Excel worksheet as well as an entire workbook.
- Asset Path: /training/exldm/files/pc/protecting-your-work
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/protecting-your-work
- Asset System Name: protecting-your-work
- 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:
Create and use a custom list, work with the Name Manager, and utilize filters.
- Asset Path: /training/exldm/files/pc/using-the-auto-fill-feature
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/using-the-auto-fill-feature
- Asset System Name: using-the-auto-fill-feature
- 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:
Create and work with a PivotTable.
- Asset Path: /training/exldm/files/pc/introducing-pivot-tables
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/introducing-pivot-tables
- Asset System Name: introducing-pivot-tables
- 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:
Practice creating a PivotTable.
- Asset Path: /training/exldm/files/pc/challenge-exercise-creating-a-pivot-table
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/challenge-exercise-creating-a-pivot-table
- Asset System Name: challenge-exercise-creating-a-pivot-table
- 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:
Excel 2016: Data Management: : 2 total
- Asset Path: /training/exldm/files/pc/img
- Asset Link: site://IU-UITS-ITTRAIN.content/training/exldm/files/pc/img
- Asset System Name: img
- Asset Data Definition: $asset.dataDefinitionPath
- Last modified by: litc
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: $asset.lastPublishedOn
- Last Published By: $asset.lastPublishedBy
- Linked From: