IU Only

Excel 2016: Analyzing Data with Pivot Tables Asset List

Excel 2016: Analyzing Data with Pivot Tables: Pages: 21 total

Just a list of blobs

  • Asset Path: /training/exlpt/files/pc/index
  • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlpt/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:33:09 EDT 2019
    • Last Published By: tlmason
  • Linked From:

    Open a file in Excel and begin to learn about PivotTables.

    Review how to create an Excel table.

    Explore how to create and work with a PivotTable.

    • Asset Path: /training/exlpt/files/pc/creating-a-pivot-table
    • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlpt/files/pc/creating-a-pivot-table
    • Asset System Name: creating-a-pivot-table
    • 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:

      Explore how to filter and format a PivotTable, view the hidden details behind data, and work with built-in calculations.

      • Asset Path: /training/exlpt/files/pc/filtering-data
      • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlpt/files/pc/filtering-data
      • Asset System Name: filtering-data
      • 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 a PivotTable to create a frequency distribution and then group the values.

        Create and filter a PivotChart.

        Use Excel's search feature to add fields to the PivotTable.

        Explore ways to make your PivotTable more understandable, including renaming and rearranging fields and pivoting rows and columns.

        See how to add a total field and an average field to a PivotTable.

        Continue building the PivotTable by adding the Max and Min fields.

        • Asset Path: /training/exlpt/files/pc/challenge-exercise-1
        • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlpt/files/pc/challenge-exercise-1
        • Asset System Name: challenge-exercise-1
        • 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 filters to view specific data in the PivotTable.

          Explore how to use the Slicer tool to filter data.

          • Asset Path: /training/exlpt/files/pc/using-the-slicer-tool
          • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlpt/files/pc/using-the-slicer-tool
          • Asset System Name: using-the-slicer-tool
          • 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:

            See various ways to sort and group data, including by date, across PivotTables, and over multiple levels.

            Use conditional formatting to highlight values that meet specific criteria.

            Utilize the Recommended PivotTable feature to create a PivotTable. Then format and copy the PivotTable and use the Difference From calculation to compare data.

            Create and format a PivotTable.

            • Asset Path: /training/exlpt/files/pc/challenge-exercise-2
            • Asset Link: site://IU-UITS-ITTRAIN.content/training/exlpt/files/pc/challenge-exercise-2
            • Asset System Name: challenge-exercise-2
            • 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:

              Create a calculated field.

              Create a dynamic link between worksheets and explore what happens when the source data is changed.

              Materials for Welcome to Excel 2016: Analyzing Data with PivotTables

              Materials for Today's Project of Excel 2016: Analyzing Data with PivotTables

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

                Excel 2016: Analyzing Data with Pivot Tables: : 2 total

                Excel 2016: Analyzing Data with Pivot Tables: Files: 0 total