Print Course information
E-mail to a friend
Return to Course Catalog

Workshops > Microsoft Office 2016

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

 

Data Analysis with Power Pivot
Item: ITOFF90134
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 1 Th 5407 N. University Peoria, IL 61635
12/14/2017 - 12/14/2017 Fee: $80.00
 

Data Analysis with Power Pivot
Item: ITOFF90135
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 1 W 5407 N. University Peoria, IL 61635
2/14/2018 - 2/14/2018 Fee: $80.00
 

The Professional Development Institute
Illinois Central College Peoria Campus
5407 N. University St. Peoria, IL. 61635

© Illinois Central College. All Rights Reserved.