IU Only

Excel 2016: Analyzing Data with Pivot Tables Asset List

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

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: Thu Mar 05 17:13:49 EST 2020
    • 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: Thu Mar 05 17:13:49 EST 2020
      • 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: Thu Mar 05 17:13:49 EST 2020
        • 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: Thu Mar 05 17:13:49 EST 2020
          • 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: Thu Mar 05 17:13:49 EST 2020
            • 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.

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

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

            Excel 2016: Analyzing Data with Pivot Tables Asset List

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

            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: Thu Mar 05 17:13:49 EST 2020
              • 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: Thu Mar 05 17:13:49 EST 2020
                • 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: Thu Mar 05 17:13:49 EST 2020
                  • 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: Thu Mar 05 17:13:49 EST 2020
                    • 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: Thu Mar 05 17:13:49 EST 2020
                      • 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.

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

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