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!

    14 Comments
    500 characters max

    Caymanian C
    Hi John, did I do so,etching wrong with the link?
    appreciate appreciated
     –  reply
     –  delete

    MyExcelOnline
    What is the issue that you are having?
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    Maria L
    Hello John, The link for the attachments seems to be broken, as it states I'm not enrolled in the course. I've exhausted all ways to move forward and enroll, so do you have any idea what the issue may be? I used my Mac, PC and my mobile device, but cannot access the spreadsheets. I can access the overview from my mobile device though. Let me know. Thank you! Maria
    appreciate appreciated
     –  reply
     –  delete
    Show previous replies...

    MyExcelOnline
    Hey Maria, You will need to send in a Help request to Curious as it seems that it is an error from their end. Please let us know if you find a solution. Thanks, John
    appreciate appreciated
     –  reply
     –  delete

    Maria L
    Hello John, I contacted support, and will respond as soon as I hear back. Do you have any idea how to fully 'enroll' in the course?
    appreciate appreciated
     –  reply
     –  delete

    MyExcelOnline
    Maria, You will need to sign up to a paid monthly account and then you will have access to all the courses. Here is how: https://curious.com/help Thanks, John
    1 appreciate 1 appreciated
     –  reply
     –  delete

    Maria L
    I signed up a for an annual membership already, so I'll make sure and notify you when I hear back from support.
    appreciate appreciated
     –  reply
     –  delete

    Maria L
    Anddd now this morning I can download them! Thank you for your prompt responses John. I really appreciate it. Loving your courses so far!
    appreciate appreciated
     –  reply
     –  delete

    MyExcelOnline
    You are welcome Maria & best of luck with the course :)
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    Francisco S
    Hi there, good presentation, but the link for pc is btoken
    appreciate appreciated
     –  reply
     –  delete
    Show previous replies...

    MyExcelOnline
    Hello Francisco, What exactly is the issue that you are facing? I tried the link and it downloads from my end. Thanks, John
    appreciate appreciated
     –  reply
     –  delete

    Francisco S
    You're right, thank you I was doing something wrong, it works.
    appreciate appreciated
     –  reply
     –  delete

    MyExcelOnline
    EXCELlent!
    1 appreciate 1 appreciated
     –  reply
     –  delete
    500 characters max

    Sadie Stoumen
    Wow, great downloadable resources. Thanks for including!
    appreciate appreciated
     –  reply
     –  delete
    500 characters max