Kursangebot

Microsoft Excel - Grundlagen

Microsoft Excel - Fortgeschrittene A

Erweiterter Anwendungsumfang, Funktionen, Diagramme

Microsoft Excel - Fortgeschrittene B

Großen Datenmengen, PivotTabellen, ersten Schritte in Makros

Aktuell im Fokus:
Microsoft 365
Teams und Online
Zusammenarbeit

Microsoft Excel Power Query

Back to the main page

Duration:	1 day
Target group:	Users who require comprehensive data analysis
Target:	Automated data queries and transformations for the creation of regular reports
Prior knowledge:	Good basic knowledge of Excel, understanding of data structure
Content:	Introduction to Power Query Application possibilities, classification in Power BI Data import from different data sources (Excel, text files, Access, etc.) Changes to existing queries Filter and transform data Merge multiple files Create calculated columns (conditions, text operations, etc.) Date calculations Create different join types depivot data Parameter transfer Data import from the Web Short introduction to the M language, editing a query in the extended editor

Power Query is a data query tool that allows you to access external data sources (SQL Server, Oracle, SAP Hana, etc.) to load data in the form of query results into the spreadsheet or data model of an Excel workbook. While querying the external data sources, their data can be filtered, ordered as well as “cleaned” without changing the data source.

Kursangebot

Microsoft Excel Power Query

Company

Information

Support

Partnerships