Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
  • Playing
    3 CQ
    31. P&L Reports with Pivot Table Slicers
    A lesson with MyExcelOnline
    View lesson

    MS Excel pivot tables help businesses understand profit and loss metrics. In this lesson, learn how to use pivot table slicers for easy-to-read P&L reports.

    MS Excel pivot tables help businesses understand profit and loss metrics. In this lesson, learn how to use pivot table slicers for easy-to-read P&L reports.

  • Playing
    3 CQ
    32. Excel Forecasts with Pivot Table Slicers
    A lesson with MyExcelOnline
    View lesson

    Get the most out of Excel's forecast functions by using pivot tables and slicers to graph business forecasts for base, best-, and worst-case scenarios.

    Get the most out of Excel's forecast functions by using pivot tables and slicers to graph business forecasts for base, best-, and worst-case scenarios.

  • Playing
    3 CQ
    33. Adding Calculated Fields
    A lesson with MyExcelOnline
    View lesson

    Learn to add custom calculations to an Excel pivot table. There's no need to stick to the standard field values; edit pivot tables to fit your needs.

    Learn to add custom calculations to an Excel pivot table. There's no need to stick to the standard field values; edit pivot tables to fit your needs.

  • Playing
    2 CQ
    34. Leveraging Calculated Data Fields
    A lesson with MyExcelOnline
    View lesson

    Explore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.

    Explore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.

  • Playing
    3 CQ
    35. Creating a Calculated Item
    A lesson with MyExcelOnline
    View lesson

    A calculated item is a virtual data item based on a row or column label. MyExcelOnline demonstrates how to add calculated items to MS Excel pivot tables.

    A calculated item is a virtual data item based on a row or column label. MyExcelOnline demonstrates how to add calculated items to MS Excel pivot tables.

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