top of page

Microsoft Excel PowerPivot Training

PowerPivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel 2013 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions, create key performance indicators (KPI) and use slicers and hierarchies to enhance the visualization of data. Exercises accompany each lesson to enhance the learning process. The courseware covers the buttons on the PowerPivot tab and accompanying tabs for creating and editing tables and charts. The power in PowerPivot is the ability to import data from multiple sources. The course provides examples using an Access database, copy and paste, text file and Excel file. In addition, calculated fields and columns are defined and used to enhance your PivotTable.   

Audience 

 

 

This course is intended for students with a sound working knowledge of Microsoft Excel 2013 and general computing proficiency, including those who will be using Excel to make business decisions.    

 

After completing this course, students will be able to:  

  • Become familiar with the PowerPivot application.

  • Develop data model while importing data from multiple sources.

  • Manipulate data in a PowerPivot worksheet.

  • Create reports using PowerPivot data.

  • Use DAX functions in PowerPivot.

  • Define KPIs (Key Performance Indicators).

  • Use slicers to enhance data visualization

bottom of page