Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
  • Playing
    8 CQ
    21. Excel Pivot Table Filters | Pt 1
    A lesson with MyExcelOnline
    View lesson

    In this first of three Excel filtering lessons, learn how to use Excel filters to sort pivot table data, as well as customizing settings for easy filtering.

    In this first of three Excel filtering lessons, learn how to use Excel filters to sort pivot table data, as well as customizing settings for easy filtering.

  • Playing
    8 CQ
    22. Excel Pivot Table Filters | Pt 2
    A lesson with MyExcelOnline
    View lesson

    This lesson from MyExcelOnline covers how to search a channel by percent values, and explains methods for filtering by date and filtering column labels.

    This lesson from MyExcelOnline covers how to search a channel by percent values, and explains methods for filtering by date and filtering column labels.

  • Playing
    8 CQ
    23. Excel Pivot Table Filters | Pt 3
    A lesson with MyExcelOnline
    View lesson

    Learn about more helpful MS Excel filters to help you understand pivot table data, including filtering by top and bottom values and sorting by report filters.

    Learn about more helpful MS Excel filters to help you understand pivot table data, including filtering by top and bottom values and sorting by report filters.

  • Playing
    3 CQ
    24. Inserting Slicers into Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    Sometimes it's difficult to know what filters are applied in an Excel pivot table. Find out how slicers can help create a more transparent format.

    Sometimes it's difficult to know what filters are applied in an Excel pivot table. Find out how slicers can help create a more transparent format.

  • Playing
    5 CQ
    25. Applying MS Excel Slicer Styles
    A lesson with MyExcelOnline
    View lesson

    Learn how to use the Excel slicer tool menu to select and apply slicer styles, as well as how to create, modify, or duplicate custom slicer styles.

    Learn how to use the Excel slicer tool menu to select and apply slicer styles, as well as how to create, modify, or duplicate custom slicer styles.

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