Excel 2019/365 Power Pivot

Inter-company training

How long does the training course last?

 1,00 day(s)

In which language(s) is the training course taught?

EN FR

When will the next session take place?

Who is organising this training course?

We enhance both individual development and efficiency by sharing the IT expertise and managerial experience of our instructors. We offer over 300 courses in French and English at our center in Capellen. These courses focus on infrastructure, development, project management, governance, and soft skills.

See more

What are the prerequisites?

Good analytical skills and proficiency in Excel, Pivot Table calculation and sorting/filtering tools.

What are the aims or the skills being targeted?

By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot, is most effective for your analysis needs. In the context of PowerPivot, you will be able to consider teamwork strategies to centralise your data for analysis. Participants in this course should have a good analytical mind and master the calculation and sorting/filtering tool of Microsoft Excel.

What does the training course cover?

Revisions of the Efficient Method for Creating PivotTables

  • On unique tables
  • Multiple tables to connect
  • Les Segments
  • PivotCharts

The power of Power Pivot

  • The advantages of Power Pivot

Import data into Power Pivot

  • Prepare your data
  • Import from a relational database
  • Import from a text or csv file
  • Import from an Excel file
  • Import from internal data - Excel table
  • Update your data

Create your own data model

  • Prepare your data model
  • Establish a team strategy to promote data centralization and analysis
  • Create relationships
  • Create a Power PivotTable analysis

Create calculated columns

  • Understanding DAX Functions for Establishing Relationships Between Tables
  • Create calculated columns

Mode of organisation

Classroom Courses

How to contact the training provider?

Service Formation

These courses might interest you