Microsoft Excel 2016 Data Analysis, Part 3 of 4: PivotTables and PivotCharts

Course description

Data summarization is essential when managing large datasets. This course will take a closer look at PivotTables, PivotCharts, PowerPivot, and importing and exporting data in Excel. Learn about building, modifying, and formatting PivotTables from given data sets, generating PivotCharts to enhance the display of data, and discover the amazing tool PowerPivot.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.

Meet the expert

Sondra Nelson

Sondra Nelson is a Microsoft Certified Trainer and has been teaching Microsoft Office for over 15 years. She has teaching and consulting experience with high school students, college students and corporate employees.

Video Runtime

65 Minutes

Time to complete

118 Minutes

Course Outline

PivotTables

Working with PivotTables (13:28)

• Introduction (00:23)
• Working with PivotTables (00:26)
• Create PivotTable Demo (00:50)
• Demo: Create a PivotTable (02:20)
• Recommended PivotTable Demo (00:37)
• Demo: Recommended PivotTable (01:30)
• Working with PivotTables Continued (00:28)
• Data Model Demo (00:00)
• Data Model Demo (02:19)
• Data Model Demo Continued (01:05)
• Demo: Data Model Continued (03:13)
• Summary (00:12)

Modifying PivotTable Data (09:52)

• Introduction (00:26)
• Modifying PivotTable Data (00:39)
• PivotTable Filter, Sort, and Aggregates Demo (00:31)
• Demo: Filter, Sort, and Aggregate (04:17)
• PivotTable Calculated Column Demo (00:40)
• Demo: Calculated Column (01:14)
• Timeline Demo (00:32)
• Demo: Timeline (01:14)
• Summary (00:16)

Formatting PivotTables (17:02)

• Introduction (00:28)
• Formatting PivotTables (00:52)
• Custom Style PivotTables Demo (01:12)
• Demo: Custom PivotTable Style (02:32)
• Format Layout Demo (01:07)
• Demo: Report Layouts (05:57)
• Number Formats Demo (00:58)
• Demo: Formatting Numbers (03:39)
• Summary (00:13)

Using PivotCharts (04:24)

• Introduction (00:27)
• Using PivotCharts (00:30)
• PivotChart Demo (00:55)
• Demo: Using PivotCharts (02:17)
• Summary (00:14)

PowerPivot (12:34)

• Introduction (00:21)
• PowerPivot (00:59)
• PowerPivot Demo (00:42)
• Demo: PowerPivot (02:06)
• PowerPivot Demo Continued (00:52)
• Demo: Add a Column (01:44)
• PowerPivot Demo Continued (00:43)
• Demo: PivotCharts (03:07)
• PowerPivot Demo Continued (00:36)
• Demo: PivotTables (01:02)
• Summary (00:15)

Exporting and Importing Data (08:34)

• Introduction (00:28)
• Exporting and Importing Data (00:38)
• Export Adobe PDF Demo (00:32)
• Demo: Export PDF (00:51)
• Export PDF/XPS Document Demo (00:37)
• Demo: Export PDF/XPS (01:01)
• Export Demo (00:32)
• Demo: Export Different File Types (01:28)
• Import Demo (00:29)
• Demo: Import Data (01:35)
• Summary (00:16)