Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
  • Playing
    4 CQ
    46. Limitations of Excel Pivot Charts
    A lesson with MyExcelOnline
    View lesson

    Pivot charts have come a long way since Excel 2010, but some limitations remain, even in Excel 2013. Find out about some pivot chart workarounds and shortcuts.

    Pivot charts have come a long way since Excel 2010, but some limitations remain, even in Excel 2013. Find out about some pivot chart workarounds and shortcuts.

  • Playing
    6 CQ
    47. Sharing & Linking Pivot Charts
    A lesson with MyExcelOnline
    View lesson

    Now that you've learned how to create attractive, informative pivot charts, learn how to copy and paste them within workbooks and across the MS Office platform.

    Now that you've learned how to create attractive, informative pivot charts, learn how to copy and paste them within workbooks and across the MS Office platform.

  • Playing
    5 CQ
    48. Filtering Pivot Charts with Slicers
    A lesson with MyExcelOnline
    View lesson

    Learn how to use slicers to filter data in Excel pivot charts. MyExcelOnline explains how to set up slicers for pivot charts and link data. Pretty nifty!

    Learn how to use slicers to filter data in Excel pivot charts. MyExcelOnline explains how to set up slicers for pivot charts and link data. Pretty nifty!

  • Playing
    5 CQ
    49. P&L Pivot Table Report with Graphs
    A lesson with MyExcelOnline
    View lesson

    You've already learned the basics of creating P&L reports using MS Excel pivot tables; now find out how to add pivot charts to graphically represent this data.

    You've already learned the basics of creating P&L reports using MS Excel pivot tables; now find out how to add pivot charts to graphically represent this data.

  • Playing
    8 CQ
    50. Pivot Chart & Slicer Sales Dashboard
    A lesson with MyExcelOnline
    View lesson

    Find out how to use MS Excel pivot table charts and slicers to create a sales dashboard that can be filtered by year, region, or numerical range.

    Find out how to use MS Excel pivot table charts and slicers to create a sales dashboard that can be filtered by year, region, or numerical range.

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