Excel

MS Excel – Advanced Level

Duration

2 days / 16 hours

Net price per group

up to 5 people

5,300 PLN

up to 7 people

6,200 PLN

up to 10 people

7,000 PLN

Contact Frequently asked questions

About the training

MS Excel Advanced training is for experienced Excel teams that want to fully leverage the capabilities of the modern spreadsheet. The programme covers dynamic and array functions from Excel 365, Power Query and Power Pivot tools, advanced scenario analyses and interactive dashboard creation — knowledge that genuinely raises the analytical competency of the whole department.

Prerequisites

Good knowledge of MS Excel at intermediate level

Who is this for

Teams with intermediate Excel experience
Analytical, controlling and BI departments working with large datasets
Teams looking to build professional dashboards directly in Excel
Employees planning to extend their skills to Power Query and Power Pivot

What you'll gain

Fluent use of dynamic functions: FILTER, SORT, UNIQUE, SEQUENCE
Automating data ingestion and transformation with Power Query — no coding required
Building data models with relationships and DAX measures in Power Pivot
Creating advanced dashboards with dynamic charts and slicers
Running scenario analyses with Solver, data tables and Goal Seek

Training programme

—FILTER — dynamically extracting data based on conditions
—SORT and SORTBY — flexible result sorting
—UNIQUE — list of values without duplicates
—SEQUENCE — generating numeric series
—Combining dynamic functions in advanced formulas

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

What you'll gain

Fluent use of dynamic functions: FILTER, SORT, UNIQUE, SEQUENCE

Automating data ingestion and transformation with Power Query — no coding required

Building data models with relationships and DAX measures in Power Pivot

Creating advanced dashboards with dynamic charts and slicers

Running scenario analyses with Solver, data tables and Goal Seek