BACK

Blog:

COURSE OF THE WEEK = Excel Advanced Data: Pivot Tables and PowerPivot (Apps)

Apr 14, 2020

Excel Advanced Data: Pivot Tables and PowerPivot

Perform powerful data analysis and create sophisticated data models.

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of doing much more. Students will not only be able to summarize data, but also organize the data in a way that can be meaningfully presented to others. With PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your effectiveness when analyzing data.

Audience

Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.

Prerequisites

To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.