Excel

MS Excel Power Query

Duration

2 days / 16 hours

Net price per group

up to 5 people

3,800 PLN

up to 7 people

4,700 PLN

up to 10 people

5,400 PLN

Contact Frequently asked questions

About the training

MS 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.

Prerequisites

Good knowledge of MS 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

Training programme

—Power Query vs. manual copying — an efficiency comparison
—The query editor interface in Excel
—Step types and transformation history
—Loading data to a table, model or connection only

What you get

Materials

Presentations and exercise files to keep

Workshops

Hands-on tasks using real business data

Certificate

In Polish and English, (print and digital)

Consultations

Post-training questions via LinkedIn

Frequently asked questions

Ready to get started?

Contact me via the form or send an email.

Ask a question Send email

About the training

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