Training: Excel – PowerQuery

Ref. MOE-43

Download PDF

Duration:

1

day

Exam:

Not certifying

Level:

Expert

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – PowerQuery

Description

This course will open the doors to data queries and big data analysis.

Participant profiles

Users who have reached the limits of Excel in terms of analysis

Objectives

Identify how relational databases work
Create and maintain queries using PowerQuery

Prerequisites

Excellent knowledge of Excel (expert level)

Course content

Module 1: Theory – relational databases

Dimension tables
Fact Tables
Relations between tables
Primary Keys
Secondary keys (Fremd Keys)
Different types of data
PowerQuery, display
Excel data model

Module 2: PowerQuery

The PowerQuery Editor
Importing data
How and where to load data
Edit the data
Adding data
Merging data

Documentation

Digital courseware included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Excel – PowerPivot | MOE-44

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress