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
This course has been revised. Starting August 2024 the title is Excel Part 4 (Microsoft 365).Applies Towards the Following Digital Badges
- Microsoft Excel 2019 Digital Badge : Microsoft Excel 2019