LCT0089 - Excel Part 4 (Microsoft 365)
Course Description
Gain a competitive edge by mastering advanced PivotTable features and creating PivotCharts in Excel to maximize effectiveness. Learn to analyze and present data effectively, leveraging PowerPivot for diverse data sources. The instructional environment of this course utilizes Microsoft 365, however, information that is presented is also appropriate for users of the desktop version. This course requires prior Excel and PivotTable experience as it builds on skills from Excel Parts 1, 2, and 3.
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
This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps): Exam MO-210 and Microsoft Excel Expert (Microsoft 365 Apps): Exam MO-211 certification exams.
Prerequisites
Excel Part 3 (Microsoft 365) LCT0088 or equivalent experience
Applies Towards the Following Digital Badges
- Excel Specialist (Microsoft 365) Digital Badge : Excel for Microsoft 365