Excel - Data Analysis with Power Pivot
- 0.5 Course
- Language: English
Introduction:
Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In this course, students gain a solid understanding of Power Pivot to maximize their effectiveness when analyzing data.
Objectives:
Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources. You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot.
Course Outline:
1 – Getting Started with Power Pivot
- Enable and Navigate Power Pivot
- Manage Data Relationships
2 – Visualizing Power Pivot Data
- Create a Power Pivot Report
- Create Calculations in Power Pivot
3 – Working with Advanced Functionality in Power Pivot
- Create a Key Performance Indicator
- Work with Dates and Time in Power Pivot