This is an example of a simple banner

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

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
Mois actuel

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

lun17Mar09:00lun17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-43

mar22Avr09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar22Avr09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

mar27Mai09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar27Mai09:00mar17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-43

mar01juil09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar01juil09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

mar05Aoû09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar05Aoû09:00mar17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-43

mar09Sep09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar09Sep09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

mar14Oct09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar14Oct09:00mar17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-43

mar18Nov09:00mar17:00VirtuelVirtual Etiquettes de sessionMOE-43

mar18Nov09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-43

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

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

Contact us

Your request