Power Pivot is a free add-in for Excel 2013 that greatly extends PivotTable and PivotChart functionalities. Power Pivot workbooks can accommodate millions of rows of data, create complex data models, perform advanced calculations using Data Analysis Expressions (DAX), use key performance indicators (KPIs), and much more. In this short, three-hour hands-on session we will explore the features of Excel 2013 Power Pivot and learn what it can do for you. If you’ve already reached the limits of standard PivotTables and PivotCharts, it’s time to move up to Power Pivot!
Prerequisites: Intermediate level experience with Excel 2013. Some experience with standard PivotTables and PivotCharts is highly recommended, but not required.
Instructor: Staff, Training Services
Hours: 3.0
Contact FAST3 (training@illinois.edu) or Phil Nyman (217-244-9041) to discuss course availability or scheduling.