Microsoft 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.
Good knowledge of Microsoft 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
- 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.
Czy szkolenie z poziomu zaawansowanego obejmuje Power BI?
Nie – Power BI to osobne narzędzie z osobnym szkoleniem. Kurs zaawansowany skupia się na Excelu 365: funkcje dynamiczne, Power Query, Power Pivot i dashboardy w arkuszu. Jeśli interesuje Cię Power BI, polecam szkolenie „Microsoft Power BI".
Czy Power Pivot jest częścią programu?
Tak – Power Pivot to jeden z kluczowych modułów. Uczestnicy uczą się budować modele relacyjne, tworzyć miary DAX i łączyć je z tabelami przestawnymi. To solidne wprowadzenie do modelowania danych bez opuszczania Excela.
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.