Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Course Info
Previous...
  • Playing
    Free
    3 CQ
    1. Excel Pivot Tables Course Intro
    A lesson with MyExcelOnline
    View lesson

    Begin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.

    Excel Pivot Tables Course Intro
    with MyExcelOnline

    Begin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.

  • Playing
    6 CQ
    2. Arranging an Excel Spreadsheet
    A lesson with MyExcelOnline
    View lesson

    In this lesson, learn what is required to convert Excel data into a pivot table. Review the steps for formatting, removing gaps, creating tables, and more!

    Arranging an Excel Spreadsheet
    with MyExcelOnline

    In this lesson, learn what is required to convert Excel data into a pivot table. Review the steps for formatting, removing gaps, creating tables, and more!

  • Playing
    8 CQ
    3. Creating an Excel Pivot Table
    A lesson with MyExcelOnline
    View lesson

    Learn how to create Excel pivot tables. MyExcelOnline explains how to insert pivot tables and designate which information to share using the Field List menu.

    Creating an Excel Pivot Table
    with MyExcelOnline

    Learn how to create Excel pivot tables. MyExcelOnline explains how to insert pivot tables and designate which information to share using the Field List menu.

  • Playing
    8 CQ
    4. Excel Data Caches and Sources
    A lesson with MyExcelOnline
    View lesson

    In this lesson from MyExcelOnline, find out more about how pivot tables connect to data sources, and learn about several methods for refreshing pivot tables.

    Excel Data Caches and Sources
    with MyExcelOnline

    In this lesson from MyExcelOnline, find out more about how pivot tables connect to data sources, and learn about several methods for refreshing pivot tables.

  • Playing
    3 CQ
    5. Excel Pivot Table Actions
    A lesson with MyExcelOnline
    View lesson

    Learn about the Excel pivot table Options menu, focusing on Actions. Follow along to clear pivot table filters or completely clear a pivot table to start fresh.

    Excel Pivot Table Actions
    with MyExcelOnline

    Learn about the Excel pivot table Options menu, focusing on Actions. Follow along to clear pivot table filters or completely clear a pivot table to start fresh.

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

    Julianne R
    How can I get sample data sheets to practice with?
    appreciate appreciated
     –  reply
     –  delete

    MyExcelOnline
    Hey Julianne, They are located to download within each tutorial. Thanks, John
    appreciate appreciated
     –  reply
     –  delete
    500 characters max