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
Language: English
Term for application: 10.01.2026
Referent: Milena Brennwald
Dates: Tue 13.01.2026 (14:00 - 17:00 o'clock)
Thu 15.01.2026 (14:00 - 17:00 o'clock)
Location and room: Universität Zürich Zentrum, Rämistrasse, 8006 Zürich, Switzerland
RAI-D-021
Show on Google Maps
Comment: 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.
Occasion: Further information about the offer.

Back