Begin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.
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!
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.
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.
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.
- 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!