Print Course information
Email me when offered
Return to Course Catalog

Workshops > From 0 to 60

Data Analysis with Power Pivot   

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

This workshop is a blended training experience that includes instructor-led classroom time plus these online components available to you on any mobile device.

  • E-Book – an electronic version of your printed book, readable on any computer or mobile device
  • Files – the practice files used in the instructor-led class
  • Assessments – Detailed evaluations based on course content
  • Learn To – Short video tutorials reinforcing and expanding key concepts of the course
  • Checklist – Quick reference material and step-by-step instructions for tasks covered in the class in an easy-to-find format

Recommended Prerequisite: Data Analysis with PivotTables

Topics Covered
Getting Started with Power Pivot
     Enable and Navigate Power Pivot
     Manage Data Relationships

Visualizing Power Pivot Data
     Create a Power Pivot Report
     Create Calculations in Power Pivot

Working with Advanced Functionality in Power Pivot
     Create a Key Performance Indicator
     Work with Dates and Time in Power Pivot

Download Class Files


No sections are currently available for this workshop. Click here to continue searching for workshops.