Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
  • Playing
    2 CQ
    51. Intro to Conditional Formatting
    A lesson with MyExcelOnline
    View lesson

    Get an overview of how to use conditional formatting options available in MS Excel 2010 and later, including data bars, color scales, and icon sets.

    Get an overview of how to use conditional formatting options available in MS Excel 2010 and later, including data bars, color scales, and icon sets.

  • Playing
    2 CQ
    52. Highlight Cell Rules for Text & Date
    A lesson with MyExcelOnline
    View lesson

    You've dabbled in Highlight Cells Rules in the previous lesson; now continue mastering this MS Excel function in this lesson from MyExcelOnline.

    You've dabbled in Highlight Cells Rules in the previous lesson; now continue mastering this MS Excel function in this lesson from MyExcelOnline.

  • Playing
    2 CQ
    53. Top & Bottom Formatting Rules
    A lesson with MyExcelOnline
    View lesson

    Find out how to use conditional formatting to highlight the top and bottom values of a data set in an MS Excel pivot table containing quarterly revenue data.

    Find out how to use conditional formatting to highlight the top and bottom values of a data set in an MS Excel pivot table containing quarterly revenue data.

  • Playing
    3 CQ
    54. Data Bars, Color Scales & Icon Sets
    A lesson with MyExcelOnline
    View lesson

    Data bars, color scales, and icon sets are new formatting features in MS Excel 2010 and later. Find out how they can make data analysis a lot easier!

    Data bars, color scales, and icon sets are new formatting features in MS Excel 2010 and later. Find out how they can make data analysis a lot easier!

  • Playing
    4 CQ
    55. Formatting Field-Specific Cells
    A lesson with MyExcelOnline
    View lesson

    Learn how to use field-specific formatting to identify salespeople who will receive a bonus. Create tailor-made conditional formatting to suit your needs.

    Learn how to use field-specific formatting to identify salespeople who will receive a bonus. Create tailor-made conditional formatting to suit your needs.

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