Microsoft Excel Power Query Course
Catalogue index: EXP/8_21-09-2026_ul Skierniewicka 10a Warszawa
- Low
- Delivery: free
- Producer:
- Training level:
- nie
- Type of training:
- nie
product- line 1
Features
| Name | Value |
|---|---|
| Additional materials: |
|
| Certification: |
|
| Number of training hours: |
|
| Producer: | |
| Training level: |
|
| Type of training: |
|
| Name | Value |
|---|---|
| Date of training: |
|
| Miejsce szkolenia: |
|
Description
We are a dynamically growing training group, with a fresh perspective on established solutions in the IT industry. Expose is backed by individuals with many years of experience and passion, and the company's mission is to enhance the quality and efficiency of your work.
The Power Query training in Excel aims to familiarize participants with the capabilities of the Excel add-in – Power Query. The Microsoft Power Query add-in for Excel expands its capabilities in terms of self-service business analysis, simplifying data discovery and access, as well as collaboration among users. During the course, you will learn about the program's capabilities regarding importing data from various sources, editing and re-running queries, and working with the collected data. Both built-in functions and tools will be used, as well as new ones created using the M language. All this to maximize efficiency and optimize work.
The Power Query training in Excel is ideal for individuals who regularly work with data — analysts, accountants, BI specialists, managers, and students. It is useful for anyone who wants to automate reports, combine data from different sources, and save time on manual data processing.
The objective of the Power Query training is to teach participants how to quickly and effectively transform, clean, and combine data from various sources in Excel — without the need for programming. Participants learn to automate repetitive tasks, which saves time and minimizes errors in reports and analyses.
The Power Query training brings many benefits — primarily saving time through the automation of repetitive tasks and reducing the number of errors in data. It facilitates the combination of information from various sources without the need for programming, speeding up the creation of analyses and reports. Participants gain greater control over data and work with Excel at a significantly higher level.
- Introduction to Power Query
- Importing data from external sources
- Working with data
- Adding new columns
- Working on queries
- M Language (Power Query language)
- Interactive queries
16 hours
The training is conducted by a Certified Microsoft Trainer (MCT), ensuring a high level of expertise and professional approach. Participants receive proprietary training materials in both paper and electronic versions, with a one-year access to the online training platform. Upon completion of the training, each participant receives a certificate confirming the acquired skills. Additionally, we provide individual recommendations for further development in the area of Excel, as well as the possibility of consultations with the trainer for three months after the course ends – in case of questions or doubts. On-site, there is also a full-day coffee service and lunch available.