Microsoft Excel Intermediate training is for teams that already know the spreadsheet basics and want to significantly improve their efficiency. Participants master advanced lookup and logic functions, learn to create dynamic pivot tables and apply formula-based conditional formatting — skills that make a real difference in everyday analytical work.
Basic knowledge of Microsoft Excel (beginner level or equivalent)
Who is this for
- Employees who have completed beginner level or independently mastered Excel fundamentals
- Office and analytical teams regularly using spreadsheets
- Finance, sales and reporting departments wanting to increase productivity
- Employees preparing for advanced training or Power Query
What you'll gain
- Fluent use of XLOOKUP, INDEX and MATCH instead of outdated VLOOKUP
- Nesting logical functions — multi-condition analyses with IF, AND, OR and IFERROR
- Efficient text manipulation with LEFT, RIGHT, FIND, SUBSTITUTE and TEXTJOIN
- Advanced pivot tables with grouping, calculated fields and slicers
- Formula-based conditional formatting — dynamic data highlighting
- 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.
Skąd wiem, czy mój poziom Excela odpowiada poziomowi średniozaawansowanemu?
Jeśli swobodnie tworzysz formuły SUMA i JEŻELI, stosujesz filtrowanie i sortowanie, a tabele przestawne nie są Ci obce – jesteś gotowy. W razie wątpliwości chętnie przeprowadzę krótką rozmowę kwalifikacyjną przed szkoleniem.
Czy szkolenie dotyczy Excela 365, czy też starszych wersji?
Program jest dostosowany do Microsoft 365, ale wszystkie omawiane funkcje (poza XWYSZUKAJ) działają również w Excelu 2019 i 2016. Na początku szkolenia ustalamy, z jakiej wersji korzysta zespół.
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.