en
fr
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.

At the end of this training you will be able to let you know which of the 2 tools between Pivot Table and PowerPivot is the most effective to meet your analysis needs. As part of PowerPivot, you will be able to consider teamwork strategies to centralize your data to be analyzed.

Practical information

Duration

1 Day

Languages

FR / NL

Price

€350,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

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.

    You might also be interested in

    ExcelExcel
    Excel 2019/365 – Level 1
    20/1 - 21/1, 10/2 - 11/2, 17 ...
    Being able to create tables and manage the calculations, formatting and page layout of the tables. The new Office interface,…
    ExcelExcel
    Excel 2019/365 – Level 2
    27/1 - 28/1, 24/2 - 25/2, 24 ...
    Dealing with the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates and macros. The new…
    ExcelExcel
    Excel 2019/365 – Macro
    21/1, 25/2, 18/3, 25/4, 20/5 ...
    Do you want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course the…
    ExcelExcel
    Excel 2019/365 Power Query – Level 1
    10/2, 20/4, 16/6, 15/9, 17/1 ...
    Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training