Microsoft Excel Training – Pivot Tables


1. PivotTables

  • PivotTable basics
  • Creating a PivotTable
  • Creating a Blank PivotTable report
  • Adding data to the PivotTable
  • Changing the Layout of a PivotTable report
  • Changing the View of a PivotTable report

2. PivotCharts

  • Creating a PivotChart
  • Changing the PivotChart type
  • Formatting the Chart
  • Changing the view of a PivotChart
  • Creating a PivotChart report from an existing PivotTable report
  • Changing the location of a PivotChart report
  • Changing the PivotChart type and format the chart
  • Changing the view of a PivotChart
  • Creating a PivotChart report directly form data
  • Adding a calculate field to a PivotTable report
  • Formatting the PivotTable and PivotChart

3. Working with PivotTables

  • Adding or removing information in a PivotTable
  • Arranging or updating information in a PivotTable
  • Changing the view of a PivotTable
  • Formatting or filtering a PivotTable

4. Working with Slicers

  • Copying a PivotTable and PivotChart
  • Formatting the PivotChart
  • Adding Slicer to the worksheet
  • Formatting Slicers
  • Using Slicers to review groups in the PivotTable
  • Using the Slicers to review groups not in the PivotTable

5. Calculated Fields

  • Inserting calculated fields
  • Using other functions in calculated fields
  • Hiding or deleting calculated fields

6. Filtering PivotTable Report

  • Filtering a PivotTable report using a Report Filter
  • Filtering a PivotTable using multiple selection criteria
  • Removing a Filter from a PivotTable report
  • Filtering a PivotTable report using the row label filter
  • Removing a row label filter from a PivotTable Report

7. Formatting PivotTable Reports

  • Formatting a PivotTable report
  • Switching summary functions in a PivotTable
  • Updating the contents of a PivotTable report
  • Adding a second value calculation to a PivotTable report
  • Customizing the display of the field list and field headers in the PivotTable report
  • Customizing the display of the +/- buttons in the PivotTable report

8. Working with Data Model

  • Adding data to the data model
  • Converting ranges to tables
  • Creating relationships
  • Adding new data to a data model
  • Using the Discount Count function

9. Working with PowerPivot

  • Installing the PowerPivot tab in the Ribon
  • Importing Data from different sources
  • Creating Relatioships
  • Creating PivotTable with the data from diffent sources
  • Using Dax Funcitons