Excel for companies: formulas, PivotTables & AI
Two days of intensive workshops that take your team from solid foundations to modern Excel 365 — and show how Copilot and ChatGPT speed up everyday work with data. The program is fitted to your company's real examples.
Key facts
Prices are in EUR, excluding VAT, for the whole group. Contact us to confirm the teaching language, dates and time zone.
A training that meets your team where it is
Office & operations
Teams that work with lists, tables and reports every day and want to do it faster and with fewer errors.
Analysts & controllers
People who prepare cyclic reports and want solid, repeatable techniques instead of copy-paste.
Reporting teams
Groups that build monthly packs and dashboards and need one common, correct way of working in Excel.
Teams adopting AI
Organizations that want to use Copilot and ChatGPT in Excel consciously, safely and effectively.
What participants learn
Correct formulas
Build formulas that don't break: references, logical functions, XLOOKUP instead of fragile VLOOKUP.
Clean, organized data
Prepare data for analysis and reporting — remove errors, duplicates and manual "cleaning" work.
PivotTables
Summarize thousands of rows in seconds and build management-ready cross-tables and reports.
Excel 365 dynamic arrays
Modern functions (FILTER, SORT, UNIQUE, LET, LAMBDA) that replace entire columns of helper formulas.
AI in daily work
Copilot in Excel and ChatGPT: faster analysis, formulas on request, data checks — with awareness of limits.
Reporting habits
A repeatable way of working: from raw data to a report that is readable for management.
Two days, day by day
Exact topics depend on your team's needs — the final agenda is agreed with you before the training.
Everyone works on their own laptop, on examples from your industry.
- Organizing and cleaning data: Excel tables, data types, removing errors and duplicates
- Building correct formulas: references, logical functions, error handling
- Lookups done right: XLOOKUP (and why VLOOKUP breaks), INDEX/MATCH
- Excel 365 dynamic arrays: FILTER, SORT, UNIQUE, LET — formulas that replace helper columns
- Workshop: cleaning and merging your team's real dataset
- PivotTables and pivot charts: grouping, calculated fields, slicers
- Management reporting: structuring numbers so decision-makers actually read them
- Copilot in Excel: analysis, formula help and insights in practice
- ChatGPT for data work: formulas on request, validation, knowing the limits
- Workshop: a full report from raw data to management summary
- Wrap-up: cheat sheet, materials and an individual action plan for every participant
The training program is flexible. Before the workshops, we can adapt the scope, difficulty level, examples and training duration to your team’s needs.
Frequently asked questions
Yes — we train only your team, up to 15 people, and fit the examples to your company's data and reports.
About 7 hours including hands-on workshops, with short breaks. Two days give the material time to settle — exercises run on both days.
For the full program, use Microsoft 365 desktop Excel on Windows. Older Excel versions cover only part of the program. Access to Copilot and ChatGPT depends on your accounts and licenses; we confirm requirements before booking. For onsite training, laptops are available on request.
Yes. Before the training we talk to you and (optionally) the participants, then fit the examples and emphasis to what your team actually does with data.
No. The training is formula-based plus AI tools — no coding. The available functions depend on the Excel version and AI tools agreed before booking.
Before the training, every participant receives access to the complete 13-hour online Excel course “Formulas, Pivot Tables & Maps”.
Participants also receive workshop files with solutions, ready-to-use templates, an Excel 365 & AI cheat sheet and a certificate of completion.
Book by phone or email
Ask about available dates, agenda details or group pricing — a short call or an e-mail is all it takes.
+48 500 196 861 Mon–Fri, 9:00–17:00 Warsaw time (CET/CEST) contact@maps-for-excel.com