LCT0042 - Excel 2019 PivotTables
202763
Delivery Options
LEL-Lecture-lab.
Loading...
Course Description
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.
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.
Applies Towards the Following Digital Badges
- Microsoft Excel 2019 Digital Badge : Microsoft Excel 2019
Loading...
Enroll Now - Select a section to enroll in
Required fields are indicated by .