IU Only

Excel: Working with Data Asset List

Excel: Working with Data: Pages: 25 total

Open an Excel workbook.

View a summary of selected data on the status bar.

Learn about and create data validation rules.

Work with existing data validation rules.

Separate data in a single column into multiple columns.

Use column headers to create named ranges.

Combine two columns (First_Name and Last_Name) into a single column.

Copy the year from a date and place it in a new column.

  • Asset Path: /training/exlwd/files/pc/a_using_year_function
  • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_using_year_function
  • Asset System Name: a_using_year_function
  • Asset Data Definition: Page - Content Blob
  • Last modified by: allaw
  • Asset Indexable: true
  • Asset Publishable: true
    • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
    • Last Published By: tlmason
  • Linked From:

    Use named ranges in a function.

    Explore how to protect a worksheet and then remove the protection.

    Explore how delimited text files can be imported into Excel.

    • Asset Path: /training/exlwd/files/pc/a_importing_data
    • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_importing_data
    • Asset System Name: a_importing_data
    • Asset Data Definition: Page - Content Blob
    • Last modified by: tlmason
    • Asset Indexable: true
    • Asset Publishable: true
      • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
      • Last Published By: tlmason
    • Linked From:

      Remove blank rows, set consistent formats, and find and replace spaces.

      • Asset Path: /training/exlwd/files/pc/a_cleaning_data
      • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_cleaning_data
      • Asset System Name: a_cleaning_data
      • Asset Data Definition: Page - Content Blob
      • Last modified by: tlmason
      • Asset Indexable: true
      • Asset Publishable: true
        • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
        • Last Published By: tlmason
      • Linked From:

        Use a formula to calculate a running balance.

        Explore ways to work with data in multiple worksheets, including copying and pasting data, correcting the #REF! error, and linking data between worksheets.

        Use the worksheet tabs to place the worksheets in chronological order.

        Select multiple worksheets and format these worksheets simultaneously.

        • Asset Path: /training/exlwd/files/pc/a_combining_worksheets
        • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_combining_worksheets
        • Asset System Name: a_combining_worksheets
        • Asset Data Definition: Page - Content Blob
        • Last modified by: allaw
        • Asset Indexable: true
        • Asset Publishable: true
          • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
          • Last Published By: tlmason
        • Linked From:

          Review the benefits and procedures for working with Excel tables.

          Use the built-in filter in an Excel table to filter the data.

          • Asset Path: /training/exlwd/files/pc/a_working_with_filters
          • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_working_with_filters
          • Asset System Name: a_working_with_filters
          • Asset Data Definition: Page - Content Blob
          • Last modified by: allaw
          • Asset Indexable: true
          • Asset Publishable: true
            • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
            • Last Published By: tlmason
          • Linked From:

            Review how to hide columns then learn how to select only the visible data.

            • Asset Path: /training/exlwd/files/pc/a_copying_visible_rows
            • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_copying_visible_rows
            • Asset System Name: a_copying_visible_rows
            • Asset Data Definition: Page - Content Blob
            • Last modified by: allaw
            • Asset Indexable: true
            • Asset Publishable: true
              • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
              • Last Published By: tlmason
            • Linked From:

              Utilize the Remove Duplicates dialog box to remove duplicate data.

              Use the Sort dialog box to sort the data alphabetically.

              • Asset Path: /training/exlwd/files/pc/a_sorting_data
              • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/a_sorting_data
              • Asset System Name: a_sorting_data
              • Asset Data Definition: Page - Content Blob
              • Last modified by: tlmason
              • Asset Indexable: true
              • Asset Publishable: true
                • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
                • Last Published By: tlmason
              • Linked From:

                Learn about the structure and use of PivotTables as well as how to organize source data.

                Create and format a simple PivotTable.

                Explore how to filter and then pivot a PivotTable.

                Just a list of blobs

                • Asset Path: /training/exlwd/files/pc/index
                • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlwd/files/pc/index
                • Asset System Name: index
                • Asset Data Definition: Page - Standard
                • Last modified by: tlmason
                • Asset Indexable: false
                • Asset Publishable: true
                  • Last Published Date: Fri Jun 14 14:35:34 EDT 2019
                  • Last Published By: tlmason
                • Linked From:

                  Excel: Working with Data: : 2 total

                  Excel: Working with Data: Files: 0 total