Excel - Data Analysis with Power Pivot

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

Enroll in this course

£148.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

GBP Pound sterling