Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Course Info
Previous...
  • Playing
    2 CQ
    56. Formatting Multiple Fields
    A lesson with MyExcelOnline
    View lesson

    In this lesson, MyExcelOnline demonstrates how to expand or reduce the range of a conditional formatting rule using the Excel pivot table field list menu.

    Formatting Multiple Fields
    with MyExcelOnline

    In this lesson, MyExcelOnline demonstrates how to expand or reduce the range of a conditional formatting rule using the Excel pivot table field list menu.

  • Playing
    2 CQ
    57. Using Slicers for Conditional Formatting
    A lesson with MyExcelOnline
    View lesson

    In this lesson, MyExcelOnline demonstrates how to create a slicer to control how conditional formatting is applied to an MS Excel pivot table.

    Using Slicers for Conditional Formatting
    with MyExcelOnline

    In this lesson, MyExcelOnline demonstrates how to create a slicer to control how conditional formatting is applied to an MS Excel pivot table.

  • Playing
    3 CQ
    58. Displaying Text in the Values Area
    A lesson with MyExcelOnline
    View lesson

    Learn how to display text in pivot table values areas using conditional formatting. This handy MS Excel pivot table trick will help you synthesize data.

    Displaying Text in the Values Area
    with MyExcelOnline

    Learn how to display text in pivot table values areas using conditional formatting. This handy MS Excel pivot table trick will help you synthesize data.

  • Playing
    4 CQ
    59. Creating Accounts Receivable Aging
    A lesson with MyExcelOnline
    View lesson

    Learn how to create an accounts receivable aging report in MS Excel using pivot table conditional formatting. These reports are critical management tools!

    Creating Accounts Receivable Aging
    with MyExcelOnline

    Learn how to create an accounts receivable aging report in MS Excel using pivot table conditional formatting. These reports are critical management tools!

  • Playing
    2 CQ
    60. Conditionally Formatting Sales Results
    A lesson with MyExcelOnline
    View lesson

    Find out how to use conditional formatting and slicers to analyze sales results in Excel pivot tables, highlighting highest and lowest sales by year and region.

    Conditionally Formatting Sales Results
    with MyExcelOnline

    Find out how to use conditional formatting and slicers to analyze sales results in Excel pivot tables, highlighting highest and lowest sales by year and region.

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