Excel Pivot Table Basics

MyExcelOnline

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!