Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
  • Playing
    5 CQ
    6. Excel Pivot Table Styles
    A lesson with MyExcelOnline
    View lesson

    Default Excel pivot table styles are pretty dull. MyExcelOnline explains how to apply and edit pivot table styles to improve data visualization.

    Default Excel pivot table styles are pretty dull. MyExcelOnline explains how to apply and edit pivot table styles to improve data visualization.

  • Playing
    4 CQ
    7. Excel Pivot Table Layouts
    A lesson with MyExcelOnline
    View lesson

    Continue exploring Excel pivot table design with layouts. Learn how to apply and edit pivot table layouts in order to visually emphasize data set highlights.

    Continue exploring Excel pivot table design with layouts. Learn how to apply and edit pivot table layouts in order to visually emphasize data set highlights.

  • Playing
    4 CQ
    8. Expand/Collapse Pivot Table Fields
    A lesson with MyExcelOnline
    View lesson

    Pivot tables in MS Excel can get long and text heavy, especially with large data sets. Find out how to collapse and expand data fields in Excel pivot tables.

    Pivot tables in MS Excel can get long and text heavy, especially with large data sets. Find out how to collapse and expand data fields in Excel pivot tables.

  • Playing
    4 CQ
    9. Excel Pivot Table Field Customization
    A lesson with MyExcelOnline
    View lesson

    It's not enough to slap on a theme to make an MS Excel pivot table easy to read; customizing fields is an important part of facilitating comprehension.

    It's not enough to slap on a theme to make an MS Excel pivot table easy to read; customizing fields is an important part of facilitating comprehension.

  • Playing
    6 CQ
    10. Excel Pivot Table Options Menu
    A lesson with MyExcelOnline
    View lesson

    The options for formatting and customizing MS Excel pivot tables are virtually limitless. Get an in-depth overview of the Pivot Table Options menu.

    The options for formatting and customizing MS Excel pivot tables are virtually limitless. Get an in-depth overview of the Pivot Table Options menu.

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