pbix.plRadosław Sobczak
v1.3.8
PLEN
HomeTrainingsProjectsFAQContact
Excel

MS Excel – Intermediate Level

Duration
2 days / 16 hours
Net price per group
up to 5 people
4,700 PLN
up to 7 people
5,800 PLN
up to 10 people
6,600 PLN
ContactFrequently asked questions

About the training

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

Prerequisites

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

Training programme

  • —VLOOKUP with approximate and exact match
  • —XLOOKUP — the modern alternative to VLOOKUP
  • —INDEX and MATCH — flexible two-way lookups
  • —Error handling in lookup functions with IFERROR

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 questionSend email
pbix.pl
The best of Excel, Power BI and SQL in one place.
Trainings
Power BIExcelSQLData Visualization
Navigation
HomeTrainingsProjectsContact
Contact
kontakt@pbix.pl
Microsoft Certified Trainer (MCT)
© 2025 Radosław Sobczak | pbix.pl
Power BI, Excel, SQL trainings across Poland