IT Training

Excel 2019/365 Power Query – Level 1

Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without programming. Participants in our training courses should have a very good knowledge of Excel.

Who should attend this course?

Thanks to a functional and non-developer interface, facilitate the work of those who have to make data from multiple sources analyzable on a daily basis in order to make it understandable for everyone in Excel and/or Power BI.

Prerequisites

Participants in our training courses should have a very good knowledge of Excel

Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without programming. Participants in our training courses should have a very good knowledge of Excel.

Familiarize yourself with the Power Query environment

  • Know how to switch from Excel to Power Query and vice versa
  • Call Power Query mode from data stored in Excel
  • Know how to load data in connection/Table/Pivot Table & Pivot Chart mode

Connect multitudes of data sources

  • Know how to import data from different sources into Power Query
    • Excel
    • csv text

Data transformation operation

  • Manage columns and rows to keep
  • Rename headers
  • Sort/Filter
  • Split columns
  • Group data (subtotals)
  • Adapt data types to analysis needs (+ automatic detection)
  • Create header row
  • Replace/Adapt Values
  • Perform calculated operations
    • On Numbers (Stat, Rounding, Information…)
    • On Dates (Year, Anniversary,… )
  • Group columns to create structured data

Add Columns Operation

  • Adding column from selection
  • Adding Custom Column
  • Column duplication
  • Format columns
  • Retrieve data from columns

Practical exercises  and real-life scenario + Tips and Tricks

Practical information

Duration

1 Day

Languages

FR / NL

Price

€350,00 + 3% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

French courses
10/2Book
20/4Book
16/6Book
15/9Book
17/10Book
20/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?