en
nlfr
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. Participants in this course should have a good analytical mind and master the calculation and sorting/filtering tool of Microsoft Excel.

Who should attend this course?

Anyone who wants to create a centralized analysis sheet. PowerPivot is a tool that allows you to stay in constant connection with external data files such as XLSX, CSV, TXT, ACCDB…

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

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

Practical information

Duration

publish

Languages

FR / NL

Price

€ 400 + 21% VAT

Location

Classroom Course

Schedule

Guaranteed to run

Sessions in English
Contact us for more infoBook
Sessions in Dutch
11/1/2024Book
07/3/2024Book
16/5/2024Book
03/9/2024Book
10/10/2024Book
07/11/2024Book
Sessions in French
22/2/2024Book
11/4/2024Book
13/6/2024Book
17/10/2024Book
21/11/2024Book
12/12/2024Book

Share this course on

Book your training

Enter your information to confirm your booking.

    You might also be interested in

    ExcelExcel
    Excel 365 – Level 3 Power user
    Contact us for more informat ...
    This 3-day course will train participants into becoming advanced Excel users by developing their skills regarding data handling, advanced functions,…
    ExcelExcel
    Excel 2019/365 – Level 1
    Contact us for more info, 23 ...
    Be able to create tables and manage the calculations, formatting and page layout of the tables.
    ExcelExcel
    Excel 2019/365 – Level 2
    Contact us for more info, 18 ...
    Be able to work with the main functions. Nest functions. Master powerful analytics tools. Create models.
    ExcelExcel
    Excel 2019/365 – Macro
    Contact us for more info, 12 ...
    Do you want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course the…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training