IU Only

Excel 2016: Data Management Asset List

Excel 2016: Data Management: Pages: 12 total

See how to open a new workbook and name the worksheets.

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 Dec 16 13:52:33 EST 2019
    • Last Published By: tlmason
  • Linked From:

    Learn how to import and clean up text from an external source.

    Create and format an Excel table.

    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 Dec 16 13:52:33 EST 2019
      • Last Published By: tlmason
    • Linked From:

      Separate cell contents using a Wizard and combine cell contents using a formula.

      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 Dec 16 13:52:33 EST 2019
        • Last Published By: tlmason
      • Linked From:

        Create and use a custom list, work with the Name Manager, and utilize filters.

        Create and work with a PivotTable.

        Practice creating a PivotTable.

        Excel 2016: Data Management: : 2 total

        Excel 2016: Data Management: Files: 0 total

        Excel 2016: Data Management Asset List

        Excel 2016: Data Management: Pages: 12 total

        See how to open a new workbook and name the worksheets.

        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 Dec 16 13:52:33 EST 2019
          • Last Published By: tlmason
        • Linked From:

          Learn how to import and clean up text from an external source.

          Create and format an Excel table.

          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 Dec 16 13:52:33 EST 2019
            • Last Published By: tlmason
          • Linked From:

            Separate cell contents using a Wizard and combine cell contents using a formula.

            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 Dec 16 13:52:33 EST 2019
              • Last Published By: tlmason
            • Linked From:

              Create and use a custom list, work with the Name Manager, and utilize filters.

              Create and work with a PivotTable.

              Practice creating a PivotTable.

              Excel 2016: Data Management: : 2 total

              Excel 2016: Data Management: Files: 0 total