Microsoft Excel Power Query training is for teams that want to put an end to manual copy-and-paste in Excel once and for all. Participants learn to import, combine and transform data from different sources directly in Excel — without macros, without programming, without tedious manual operations. Power Query in Excel uses the same technology as Power BI, but is available natively within the spreadsheet.
Good knowledge of Microsoft Excel (intermediate level or above)
Who is this for
- Teams working with Excel at intermediate or advanced level
- Departments regularly consolidating reports from multiple files or systems into one spreadsheet
- Analytical teams looking to automate data preparation without VBA knowledge
- Finance, HR and sales departments processing data from ERP, CSV or external databases
What you'll gain
- Automatic data ingestion and refresh from files, folders, databases and websites
- Cleaning and transforming data without touching the original sources
- Combining multiple files from a folder into one consolidated report with a single click
- Merging and comparing data from different tables, just like in a database
- M language basics — editing queries and creating custom transformations
- 01
Materials
Presentations and exercise files to keep.
- 02
Workshops
Hands-on tasks using real business data.
- 03
Certificate
In Polish and English, print and digital.
- 04
Consultations
Post-training questions via LinkedIn.
Czym różni się to szkolenie od szkolenia Power Query dla Power BI?
Silnik i język M są identyczne. Różnica leży w środowisku: to szkolenie skupia się na Power Query wbudowanym w Excel, z załadowaniem danych do tabel i modelu Power Pivot. Jeśli pracujesz głównie w Excelu – to właściwy wybór.
Czy Power Query zastąpi moją wiedzę o formułach Excela?
Nie – to uzupełniające, nie wykluczające się umiejętności. Power Query doskonale radzi sobie z importem, czyszczeniem i transformacją danych przed analizą. Formuły Excela nadal są potrzebne do obliczeń i raportowania.
Czy otrzymam materiały szkoleniowe?
Tak – każdy uczestnik otrzymuje prezentacje, zestawy ćwiczeń oraz pliki warsztatowe. Po szkoleniu udostępniam listę sprawdzonych źródeł do samodzielnej nauki.
Can the training be delivered at our company premises?
Yes, I run closed-group corporate Power BI, Excel, SQL and VBA trainings across Poland. By default, sessions are delivered on participants' own equipment. On request, I can provide laptops for every participant and a multimedia projector.
Do participants need to bring their own laptops?
By default, yes — participants use their own devices. If the company does not have the required hardware or software (Power BI Desktop, Excel, SQL Server Management Studio) — on request, I can provide computers for each participant for the duration of the training.
How do I choose the right level for my team?
I offer a skills assessment test that evaluates the team's current competencies and helps select the right Power BI, Excel or SQL training level — from beginner through to advanced.
Are the sessions practical or theoretical?
Every Power BI, Excel and SQL training combines solid theoretical foundations with hands-on business exercises. The greatest value comes from tasks based on real analytical scenarios — the kind teams actually face day to day.
Will participants receive certificates?
Yes — every participant receives a completion certificate in both Polish and English. Because I am a Microsoft Certified Trainer (MCT), the certificates carry real weight in the job market and are widely recognised by employers.
How many people can attend a single training session?
The optimal group size for a corporate Power BI, Excel or SQL training is up to 12 people. Smaller groups allow for a more personalised approach; larger groups are possible by arrangement. Pricing is structured per group, not per person.
Do you offer online Power BI and Excel training?
Yes — all trainings (Power BI, Excel, SQL, VBA, DAX) are available both on-site and online via Microsoft Teams or Zoom. Online sessions follow the same hands-on, workshop format as classroom training.
Can the training programme be tailored to our specific needs?
Absolutely. I regularly design fully bespoke training programmes built around your team's tools, actual data and real-world challenges. If your company works with specific Power BI reports, Excel dashboards or SQL queries — I can structure the entire training around those. This is the most effective approach for teams with clear, defined goals.