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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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.

        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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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.

              Excel: Working with Data: : 2 total

              Excel: Working with Data: Files: 0 total

              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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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.

                    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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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: Mon Dec 16 13:52:33 EST 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.

                          Excel: Working with Data: : 2 total

                          Excel: Working with Data: Files: 0 total