IT Training

Excel 2019/365 Power Pivot

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.

Who should attend this course?

Anyone who wants to create a centralized analysis sheet. Participants in this course should have a good analytical mind and master the calculation and sorting/filtering tool of Microsoft Excel.

Prerequisites

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

PowerPivot is a tool that allows you to stay in constant connection with external data files such as XLSX, CSV, TXT, ACCDB…

  • Reminder of the Efficient Method for Creating PivotTables
  • The power of Power Pivot
  • Import data into Power Pivot
  • Create your own data model
  • Create calculated columns

Reminder 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

Practical information

Duration

1 Day

Languages

FR / NL

Price

€350,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Dutch courses
13/1Book
10/2Book
10/3Book
21/4Book
19/5Book
09/6Book
07/7Book
11/8Book
08/9Book
13/10Book
17/11Book
08/12Book
French courses
20/1Book
24/2Book
17/3Book
24/4Book
19/5Book
16/6Book
14/7Book
18/8Book
16/9Book
21/10Book
24/11Book
15/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?