Udemyallpl

Mistrz Power Query w Excelu

Master Excel data extraction & analysis with Power Query. Learn to clean, transform, and analyze data efficiently. Boost your data skills!

4.5(1,054)
6,529students
10h 32m
Certificate
Adam Kopeć
Adam KopećMiłośnik Excela i Power Query, Microsoft MVP

Course Content

Mistrz Power Query w Excelu is an all-levels Udemy course taught by Adam Kopeć. It runs 10h 32m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 1,054 reviews, with 6,529 students enrolled. It is a paid course, last updated September 2025.

Power Query: Unlock Powerful Data Analysis in Excel & Power BI

Discover the power of Power Query, a free add-in for Excel (and part of the free Power BI Desktop), revolutionizing data analysis and business intelligence (BI). Effortlessly extract, transform, and load (ETL) data from a wide variety of sources.

Data Source Connectivity:

  • Websites: Pull data directly from web pages.
  • Files: Import data from .txt, .csv, Excel, and XML files.
  • Folders: Access data stored in designated folders.
  • Databases: Connect to databases like Access.
  • Social Media: Extract data from platforms like Facebook.
  • And Many More: Power Query supports a vast range of data sources.

Data Transformation Capabilities:

Power Query provides a comprehensive suite of tools to reshape your data:

  • Column & Row Manipulation: Add, remove, and reorder columns and rows.
  • Column Splitting: Divide columns based on delimiters or character counts.
  • Filtering & Sorting: Quickly filter and sort data for focused analysis.
  • Value Transformation: Control text formatting (case, trimming, adding text).
  • Data Operations: Perform calculations like multiplication, division, modulo, and exponents.
  • Data Grouping: Aggregate data for insightful summaries.
  • Data Merging & Appending: Combine datasets using "Merge Queries" (similar to VLOOKUP).
  • Column Unpivoting & Pivoting: Reverse the functionality of Pivot Tables for flexible data reshaping.
  • And Much More: A wide array of transformations for data cleaning and preparation.

Data Loading & Automation:

Load transformed data directly into Excel, Power Pivot, or keep it as a query for dynamic updates. Power Query remembers your transformation steps, automatically applying them whenever the source data changes. This powerful automation saves significant time and effort.

User-Friendly Interface:

Power Query's intuitive user interface makes data transformation accessible to everyone. This course guides you through finding and utilizing the key options to achieve your desired results. Learn how to effectively clean data, create clear reports, and uncover valuable insights.

Course Outline:

  • Introduction to Power Query: Fundamental concepts and overview.
  • Data Acquisition: Connecting to various data sources.
  • Query Combination: Merging and appending data from multiple sources.
  • Data Grouping: Summarizing data using grouping operations.
  • Pivot & Unpivot: Creating and reversing pivot tables for data reshaping.
  • Column Manipulation: Adding, removing, and transforming columns.
  • Logical Operations: Implementing conditional logic in your queries.
  • Parameters & Query Parameterization: Creating dynamic and reusable queries.
  • Custom Functions: Extending Power Query's capabilities with custom code.
  • Practical Examples: Real-world use cases demonstrating Power Query's versatility.

Who Should Learn Power Query?

  • Daily Data Users: Anyone who works with data on a regular basis.
  • Dashboard Creators: Those who frequently build dashboards and reports.
  • Data Integrators: Individuals who import and combine data from diverse sources.
  • Data Cleaners: Those who spend time cleaning and preparing data for analysis.
  • Report Developers: Professionals who regularly create reports.
  • Data Analysts: A valuable tool for data analysis and exploration.
  • Excel & VBA Users: Those seeking an alternative to complex formulas or VBA code.
  • Large Dataset Managers: Anyone working with datasets containing tens of thousands or millions of rows.

Save countless hours and unlock the full potential of your data! Enroll now and discover the amazing capabilities of Power Query for data analysis.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

4.8(95)
5h 50m
intermediate

Czysty JavaScript zamiast jQuery

by Mateusz Chrzonstowski

4.8(124)
3h 58m
intermediate
4.8(8,474)
6h 17m
all
4.8(5,296)
4h 57m
beginner
4.8(353)
8h 55m
beginner