IT Training

Excel 2019/365 Power Query Complete

Forget VBA and discover Power Query to automate your data collection. With this tool you can create complex queries without programming! At the end of this course you will be able to create data tables ready for analysis. Participants in this course need to have a very good knowledge of Microsoft Excel

Who should attend this course?

Thanks to a functional and non-developer interface, PowerQuery facilitates the work of those who need to analyse data from multiple sources on a daily basis, making it understandable to everyone in Excel and/or Power BI.

Prerequisites

Very good knowledge of Excel

Forget VBA and discover Power Query to automate the recovery of your data. This tool allows you to create complex queries without programming!

At the end of this training you will be able to create data tables ready to be analyzed with

  • Excel (Pivot Tables and PivotCharts + Slicer)
  • Power Bi t(Table/Matrix/Graphics/Slicer)

Practical information

Duration

2 Days

Languages

FR / NL

Price

€700,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

French courses
17/1 - 18/1Book
04/4 - 05/4Book
05/9 - 06/9Book
05/12 - 06/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?