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

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

LearnNow Online
Updated Dec 09, 2020

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 experts

Kari Hoien

I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.

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 (00:50)

Demo: Create a PivotTable (02:20)

Recommended PivotTable (00:37)

Demo: RecommendedPivotTable (01:30)

Working with PivotTables Continued (00:28)

Data Model (02:19)

Data Model Continued (01:05)

Demo: Data Model (03:13)

Summary (00:12)

Modifying PivotTable Data (09:47)

Introduction (00:21)

Modifying PivotTable Data (00:39)

PivotTable Filter, Sort, and Aggregate (00:31)

Demo: Filter, Sort, and Aggregate (02:47)

PivotTable Calculated Column (02:10)

Demo: Calculated Column (01:14)

Timeline (00:32)

Demo: Timeline (01:14)

Summary (00:15)

Formatting PivotTables (16:57)

Introduction (00:23)

Formatting PivotTables (00:52)

Custom Style PivotTables (01:12)

Demo: Custom Style PivotTable (02:32)

Format Layout (01:07)

Demo: Report Layouts (05:57)

Number Formats (00:58)

Demo: Formatting Numbers (03:39)

Summary (00:13)

Using PivotCharts (04:19)

Introduction (00:22)

Using PivotCharts (00:30)

PivotChart Demo (00:55)

Demo: Using PivotCharts (02:17)

Summary (00:14)

PowerPivot (12:24)

Introduction (00:12)

PowerPivot (00:59)

PowerPivot Demo (00:42)

Demo: PowerPivot (02:06)

PowerPivot Continued (00:52)

Demo: Add a Column (01:44)

PivotCharts in PowerPivot (00:43)

Demo: PivotCharts (03:07)

PivotTables in PowerPivot (00:36)

Demo: PivotTables (01:02)

Summary (00:15)

Exporting and Importing Data (08:29)

Introduction (00:24)

Exporting and Importing Data (00:38)

Export Adoble PDF (00:32)

Demo: Export PDF (00:51)

Export PDF/XPS Document (00:37)

Demo: Export PDF/XPS (01:01)

Export Different File Types (00:32)

Demo: Export Different File Types (01:28)

Import (00:29)

Demo: Import Data (01:35)

Summary (00:16)