Excel 2016/2019 - Data Analysis with Power Pivot

Price
$295.00
Duration
 1 Day
Delivery Methods
 VILT    Private Group

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.

 

Upcoming Class Dates and Times

Jan 25, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Mar 23, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
May 24, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR

Who Should Attend

Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Course Objectives

    Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 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.

Agenda

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