Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
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.

    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.

    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.

    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.

    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.

    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!

Comments
500 characters max