Melvin R's Enrolled Lessons
-
5 minFREEComputer Science lessonFree3 CQ
Begin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.
with MyExcelOnlineBegin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.
-
11 minComputer Science lesson6 CQ
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!
with MyExcelOnlineIn 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!
-
14 minMicrosoft Office lesson8 CQ
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.
with MyExcelOnlineLearn how to create Excel pivot tables. MyExcelOnline explains how to insert pivot tables and designate which information to share using the Field List menu.
-
15 minMicrosoft Office lesson8 CQ
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.
with MyExcelOnlineIn this lesson from MyExcelOnline, find out more about how pivot tables connect to data sources, and learn about several methods for refreshing pivot tables.
-
5 minMicrosoft Office lesson3 CQ
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.
with MyExcelOnlineLearn 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.
-
9 minMicrosoft Office lesson5 CQ
Default Excel pivot table styles are pretty dull. MyExcelOnline explains how to apply and edit pivot table styles to improve data visualization.
with MyExcelOnlineDefault Excel pivot table styles are pretty dull. MyExcelOnline explains how to apply and edit pivot table styles to improve data visualization.
-
6 minMicrosoft Office lesson4 CQ
Continue exploring Excel pivot table design with layouts. Learn how to apply and edit pivot table layouts in order to visually emphasize data set highlights.
with MyExcelOnlineContinue exploring Excel pivot table design with layouts. Learn how to apply and edit pivot table layouts in order to visually emphasize data set highlights.
-
7 minMicrosoft Office lesson4 CQ
Pivot tables in MS Excel can get long and text heavy, especially with large data sets. Find out how to collapse and expand data fields in Excel pivot tables.
with MyExcelOnlinePivot tables in MS Excel can get long and text heavy, especially with large data sets. Find out how to collapse and expand data fields in Excel pivot tables.
-
7 minMicrosoft Office lesson4 CQ
It's not enough to slap on a theme to make an MS Excel pivot table easy to read; customizing fields is an important part of facilitating comprehension.
with MyExcelOnlineIt's not enough to slap on a theme to make an MS Excel pivot table easy to read; customizing fields is an important part of facilitating comprehension.
-
10 minMicrosoft Office lesson6 CQ
The options for formatting and customizing MS Excel pivot tables are virtually limitless. Get an in-depth overview of the Pivot Table Options menu.
with MyExcelOnlineThe options for formatting and customizing MS Excel pivot tables are virtually limitless. Get an in-depth overview of the Pivot Table Options menu.