Training: Excel – PowerQuery

Ref. MOE-43
Duration:
1
 day
Exam:
Not certifying
Level:
Expert

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 course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

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
  • Explore all our Microsoft Office courses by clicking here
Prix de l'inscription
CHF 700.-
Inclus dans ce cours
  • Training provided by an expert trainer
  • Documentation in digital format
  • Achievement Badge

lun11Mar09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun11Mar09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

lun15Avr09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-43

lun15Avr09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun20Mai09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun20Mai09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

lun24Juin09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-43

lun24Juin09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun29juil09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun29juil09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

lun02Sep09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-43

lun02Sep09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun07Oct09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun07Oct09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

lun11Nov09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-43

lun11Nov09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun16Déc09:00lun17:00VirtuelVirtual Etiquettes de sessionMOE-43

lun16Déc09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X