LCT0042 - Excel 2019 PivotTables

Course Description

This course has been revised. Starting August 2024 the title is Excel Part 4 (Microsoft 365).

Summarize and organize raw data in a way that can be meaningfully presented to others. Gain a solid understanding of Pivot Tables to maximize effectiveness when analyzing data. Use Power Pivot along with Excel to analyze data from a variety of sources. To ensure success in this course, you should have experience working with Excel and PivotTables, understand spreadsheet concepts, and be comfortable creating basic PivotTables.

Note: Summer 2024 is the last time Community Education will be offering Excel 2019. Starting in August, we will be moving to Microsoft 365. 

Course Outline

• Lesson 1: Preparing Data and Creating PivotTables
  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Source
• Lesson 2: Analyzing Data by Using PivotTables
  •  Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data
• Lesson 3: Working with PivotCharts
  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

Learner Outcomes

• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze data by using PivotTables.
• Work with PivotCharts.

Notes