0:00 / 7:36
 
 
 
 
 
 

Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Course Info
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.

    Excel Pivot Table Styles
    with MyExcelOnline

    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.

    Excel Pivot Table Layouts
    with MyExcelOnline

    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.

    Expand/Collapse Pivot Table Fields
    with MyExcelOnline

    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.

    Excel Pivot Table Field Customization
    with MyExcelOnline

    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.

    Excel Pivot Table Options Menu
    with MyExcelOnline

    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...