Excel Pivot Table Basics

34 CQ
11 Lessons
Course Info
Previous...
  • Playing
    Free
    4 CQ
    1. Intro to Excel Pivot Table Basics
    A lesson with MyExcelOnline
    View lesson

    Ready to do more with MS Excel? Gain an overview of what will be included in this Microsoft Excel course on the basics of pivot tables.

    Intro to Excel Pivot Table Basics
    with MyExcelOnline

    Ready to do more with MS Excel? Gain an overview of what will be included in this Microsoft Excel course on the basics of pivot tables.

  • Playing
    3 CQ
    2. How to Create & Format an Excel Table
    A lesson with MyExcelOnline
    View lesson

    Learn to organize and format data to create an Excel table with an easy-to-read design, complete with useful header and total rows; next step, pivot tables!

    How to Create & Format an Excel Table
    with MyExcelOnline

    Learn to organize and format data to create an Excel table with an easy-to-read design, complete with useful header and total rows; next step, pivot tables!

  • Playing
    3 CQ
    3. How to Create a Pivot Table in Excel
    A lesson with MyExcelOnline
    View lesson

    In this data processing lesson, learn how to create a pivot table in Excel, including organizing the fields to summarize, analyze, and report key information.

    How to Create a Pivot Table in Excel
    with MyExcelOnline

    In this data processing lesson, learn how to create a pivot table in Excel, including organizing the fields to summarize, analyze, and report key information.

  • Playing
    2 CQ
    4. How to Format a Pivot Table in Excel
    A lesson with MyExcelOnline
    View lesson

    In this lesson, learn how to format a pivot table in Excel, including how to refresh data, and format the values, style, and layout of the pivot table.

    How to Format a Pivot Table in Excel
    with MyExcelOnline

    In this lesson, learn how to format a pivot table in Excel, including how to refresh data, and format the values, style, and layout of the pivot table.

  • Playing
    2 CQ
    5. Displaying Values in Excel Pivot Tables
    A lesson with MyExcelOnline
    View lesson

    In this Excel lesson, learn to display various values based on a field, how to hide grand totals, and tips for customizing the pivot table labels.

    Displaying Values in Excel Pivot Tables
    with MyExcelOnline

    In this Excel lesson, learn to display various values based on a field, how to hide grand totals, and tips for customizing the pivot table labels.

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