Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Course Info
Previous...
  • Playing
    3 CQ
    71. Macro for Different Pivot Table Views
    A lesson with MyExcelOnline
    View lesson

    MyExcelOnline records macros to generate views for region by quarter, year-to-date sales by month, and top ten channels, creating buttons for each macro.

    Macro for Different Pivot Table Views
    with MyExcelOnline

    MyExcelOnline records macros to generate views for region by quarter, year-to-date sales by month, and top ten channels, creating buttons for each macro.

  • Playing
    4 CQ
    72. Excel Top 10 Macro with Scrollbar
    A lesson with MyExcelOnline
    View lesson

    Find out how to use Excel macros to easily identify your best customers! In this lesson, MyExcelOnline demonstrates how to create a macro for a top 10 filter.

    Excel Top 10 Macro with Scrollbar
    with MyExcelOnline

    Find out how to use Excel macros to easily identify your best customers! In this lesson, MyExcelOnline demonstrates how to create a macro for a top 10 filter.

  • Playing
    6 CQ
    73. Ways to Reduce Excel File Size
    A lesson with MyExcelOnline
    View lesson

    Get data management tips that will help you conserve memory when working with large MS Excel files. Find out about four ways to reduce Excel workbook file size.

    Ways to Reduce Excel File Size
    with MyExcelOnline

    Get data management tips that will help you conserve memory when working with large MS Excel files. Find out about four ways to reduce Excel workbook file size.

  • Playing
    3 CQ
    74. Using the Pivot Table Wizard
    A lesson with MyExcelOnline
    View lesson

    You've learned how to create pivot tables the hard way, and skills are sharper for it! Now learn how to use the Excel Pivot Table Wizard to consolidate data.

    Using the Pivot Table Wizard
    with MyExcelOnline

    You've learned how to create pivot tables the hard way, and skills are sharper for it! Now learn how to use the Excel Pivot Table Wizard to consolidate data.

  • Playing
    2 CQ
    75. Frequency Distribution with Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    Learn how to use pivot tables to create a frequency distribution, and insert a chart to visually display the frequency of sales according to sales person.

    Frequency Distribution with Pivot Tables
    with MyExcelOnline

    Learn how to use pivot tables to create a frequency distribution, and insert a chart to visually display the frequency of sales according to sales person.

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!

    2 Comments
    500 characters max

    Fay V
    The session 2 has a problem. It goes black without sound. Tks
    appreciate appreciated
     –  reply
     –  delete

    MyExcelOnline
    Hello Fay, Please try and use another web browser and see if this fixes the problem. If you are still having issues, please contact the Curious support team and they will help you out with this issue. Thanks, John
    appreciate appreciated
     –  reply
     –  delete
    500 characters max