Course curriculum

  • 2

    Let's Create our First Pivot Table

    • Create a Pivot Table

    • Answer for Pivot Table Exercise

  • 3

    Customize Your Pivot Table

    • Change the Name and Format of Fields

    • Display the Percent of Total on Your Pivot Chart

    • Insert a Timeline for your Pivot Table

    • Answers for your formatting exercise.

  • 4

    Advanced Customization of Pivot Tables

    • Insert a Calculated Field in Your Pivot Chart

    • The Grouping Feature and Replacing Blank Cells

    • Answers to Exercise Grouping

  • 5

    Pivot Charts and Slicers

    • Creating a Pivot Chart

  • 6

    Creating a Dashboard

    • Plan Your Dashboard

    • Create Your Dashboard