en
nlfr
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 the recovery of your data. This tool allows you to create complex queries without programming!

  • Familiarize yourself with the Power Query environment
  • Connect multitudes of data sources
  • Data transformation operation
  • Add Columns Operation
  • Practical exercises  and real-life scenario + Tips and Tricks

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 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Dutch courses
17/1Book
07/3Book
09/5Book
04/7Book
10/10Book
14/11Book
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.

    You might also be interested in

    ExcelExcel
    Excel 2019/365 – Level 1
    24/1 - 25/1, 21/2 - 22/2, 14 ...
    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
    20/1 - 21/1, 17/2 - 18/2, 17 ...
    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
    14/1, 11/2, 11/3, 22/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 Pivot
    13/1, 10/2, 10/3, 21/4, 19/5 ...
    By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot,…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training