LearnNowOnline

Learn your way! Get started

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

with expert Sondra Nelson

Watch trailer

Course at a glance

Release date 10/21/2017
Level Intermediate
Runtime 1h 5m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

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.

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.

Learning Paths

This course is part of the following LearnNowOnline SuccessPaths™:
Microsoft Office Advanced

Meet the expert

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.

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)