MS Excel 365: Data transformation and analysis with PowerQuery and PivotTables

 In this course you will learn to import and transform data from various sources into Excel so that it can be used for further analysis and reporting.

In the course we will learn the process of data import, data cleansing, data preparation with the PowerQuery editor and analytical compilation of data with Excel PivotTables.

In the interaction of PowerQuery and Pivot, data is collected, sorted, cleaned and analytically organised in an automatable and reproducible way.
 

Code: HS25-WEP-02
Sprache: English
Anmeldefrist: 10.01.2026
Kursleitung: Milena Brennwald
Daten: Di 13.01.2026 (14:00 - 17:00 Uhr)
Do 15.01.2026 (14:00 - 17:00 Uhr)
Standort und Raum: Universität Zürich Zentrum, Rämistrasse, 8006 Zürich, Switzerland
RAI-D-021
Auf Karte anzeigen
Bemerkungen: This course uses Excel for Mac. It is possible to participate with a Windows computer, as the displayed functions are often identical. However, the layout may differ. Therefore, we recommend that Windows users book the Windows-based course.
Angebot: Weitere Informationen zum Angebot.

Zurück