Excel Pivot Table Basics

34 CQ
11 Lessons
Previous...
  • Playing
    4 CQ
    6. Using Calculations in Excel Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    In this lesson, learn how to use the Show Values as options under the Value Field Settings to run a variety of calculations in an Excel pivot table.

    In this lesson, learn how to use the Show Values as options under the Value Field Settings to run a variety of calculations in an Excel pivot table.

  • Playing
    4 CQ
    7. How to Group Data in Excel Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    In this data processing lesson, you'll learn how to use values, dates, and locations to group data in pivot tables together for dynamic, useful reports.

    In this data processing lesson, you'll learn how to use values, dates, and locations to group data in pivot tables together for dynamic, useful reports.

  • Playing
    2 CQ
    8. Inserting a Slicer in Excel Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    In this data processing lesson, learn how to use slicers in Excel pivot tables to sort associated data into informative, at-a-glance reports.

    In this data processing lesson, learn how to use slicers in Excel pivot tables to sort associated data into informative, at-a-glance reports.

  • Playing
    2 CQ
    9. Inserting a Pivot Chart in Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    Follow along with this Excel lesson to learn how to insert pivot charts that link not only to a pivot table but also to associated slicers.

    Follow along with this Excel lesson to learn how to insert pivot charts that link not only to a pivot table but also to associated slicers.

  • Playing
    3 CQ
    10. Creating an Excel Pivot Table Dashboard
    A lesson with MyExcelOnline
    View lesson

    Follow along with this pivot table lesson to learn how to link sliders and pivot charts together to create an adjustable, dynamic dashboard in MS Excel.

    Follow along with this pivot table lesson to learn how to link sliders and pivot charts together to create an adjustable, dynamic dashboard in MS Excel.

More...
  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

You don't have any lessons in your history.
Just find something that looks interesting and start learning!

Comments
500 characters max