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.

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!

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.

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.

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.

In this lesson, learn how to use the Show Values as options under the Value Field Settings to run a variety of calculations in an Excel pivot table.

In this data processing lesson, you'll learn how to use values, dates, and locations to group data in pivot tables together for dynamic, useful reports.

In this data processing lesson, learn how to use slicers in Excel pivot tables to sort associated data into informative, at-a-glance reports.

Follow along with this Excel lesson to learn how to insert pivot charts that link not only to a pivot table but also to associated slicers.

Follow along with this pivot table lesson to learn how to link sliders and pivot charts together to create an adjustable, dynamic dashboard in MS Excel.