IU Only

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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• Linked From:

• 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:
  • using-the-auto-fill-feature
  • introducing-pivot-tables
  • validating-data
  • grouping-worksheets
  • working-with-tables-of-data
  • getting-started-with-data-management
  • importing-and-cleaning-data
  • protecting-your-work
  • splitting-and-combining-cell-contents

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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• 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: Mon Sep 19 10:57:49 EDT 2022
  • Last Published By: tlmason
• Linked From:

• 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:
  • using-the-auto-fill-feature
  • introducing-pivot-tables
  • validating-data
  • grouping-worksheets
  • working-with-tables-of-data
  • getting-started-with-data-management
  • importing-and-cleaning-data
  • protecting-your-work
  • splitting-and-combining-cell-contents