028 3824 5819 traincert@tdt-tanduc.com
Tiếng ViệtEnglish

Excel Power Pivot

The Excel PowerPivot feature provides Business Intelligence (BI) functionality and reporting on a scale previously unimaginable with PivotTables enabling you to process millions of rows of data.

It provides deeper business insights, in a fraction of the time, using familiar Excel tools to get to get customized reports, table relationships, create calculated columns and measures using formulas, and then further analyze the data so that you can make timely business decisions

This course is aimed at experienced Excel users who need to perform more complex reports, advanced data analytics to process on massive amounts of data.

After completing this course, students will be able to:

  • Have the skills required to start using PowerPivot.
  • The course will learn how to leverage PivotTable knowledge in Excel with PowerPivot and how to apply PowerPivot in your work.


  • Create a one-dimensional pivot table report from a table
  • Create a grouped pivot table report
  • Understand pivot table rows and columns
  • Apply a simple filter and sort to a pivot table
  • Use report filter fields
  • Filter a pivot table visually using slicers
  • Add a timeline control to a pivot table
  • Use slicers to create a custom timeline
  • Use report filter fields to automatically create multiple pages
  • Format a pivot table using PivotTable styles
  • Understand pivot table report layouts
  • Add/remove subtotals and apply formatting to pivot table fields
  • Display multiple summations within a single pivot table
  • Add a calculated field to a pivot table
  • Group by Text, Date
  • Show row data by percentage of total rather than value
  • Create a pivot chart from a pivot table
  • Embed multiple pivot tables onto a worksheet
  • Use slicers to filter multiple pivot tables


  • Exploring the PowerPivot Interface
  • Loading Data
  • Create relationships between data
  • Configuring Calculated Columns and Calculated Fields
  • Creating PivotTables
  • Understanding DAX
  • Utilizing DAX functions
  • Using KPIs
  • Working with Hierarchies
  • Managing Perspectives
KH 2
KH 3
KH 5