Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Course Info
Previous...
  • Playing
    3 CQ
    26. Excel Slicer Settings
    A lesson with MyExcelOnline
    View lesson

    Now that you've learned how to use slicer styles, find out how to apply MS Excel slicer settings to optimize how information is displayed within the slicer.

    Excel Slicer Settings
    with MyExcelOnline

    Now that you've learned how to use slicer styles, find out how to apply MS Excel slicer settings to optimize how information is displayed within the slicer.

  • Playing
    2 CQ
    27. Adjusting Excel Slicer Properties
    A lesson with MyExcelOnline
    View lesson

    MyExcelOnline explains how to adjust slicer size, columns, and alignment using the slicer properties dialogue box and properties ribbon menu.

    Adjusting Excel Slicer Properties
    with MyExcelOnline

    MyExcelOnline explains how to adjust slicer size, columns, and alignment using the slicer properties dialogue box and properties ribbon menu.

  • Playing
    2 CQ
    28. Connecting Slicers to Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    MyExcelOnline demonstrates how to use the Pivot Table Connections tool to create clear relationships between multiple pivot tables and slicers.

    Connecting Slicers to Pivot Tables
    with MyExcelOnline

    MyExcelOnline demonstrates how to use the Pivot Table Connections tool to create clear relationships between multiple pivot tables and slicers.

  • Playing
    3 CQ
    29. How to Use Slicers as Filters
    A lesson with MyExcelOnline
    View lesson

    Excel slicers not only display pivot table filters, they also function as filtering devices. Learn how to select slicer items in order to filter a pivot table.

    How to Use Slicers as Filters
    with MyExcelOnline

    Excel slicers not only display pivot table filters, they also function as filtering devices. Learn how to select slicer items in order to filter a pivot table.

  • Playing
    5 CQ
    30. Linking Employee Photos with Slicers
    A lesson with MyExcelOnline
    View lesson

    Put a name to a face with MS Excel slicers! In this lesson, MyExcelOnline explains how to add interactive employee photos to slicers using an offset function.

    Linking Employee Photos with Slicers
    with MyExcelOnline

    Put a name to a face with MS Excel slicers! In this lesson, MyExcelOnline explains how to add interactive employee photos to slicers using an offset function.

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