Excel skills your team uses the next day
A live online session of two to three hours with an experienced trainer: Tables, PivotTables, SUMIFS and XLOOKUP, practised on realistic data. Your colleagues join from wherever they work, and we plan the session around your time zone.
Your session in four steps
Pick your topicsChoose the Excel functions your team needs most.
Share your time zoneTell us where your colleagues sit.
Join live onlineZoom or Microsoft Teams, with a practice file for everyone.
Keep workingYour team keeps the file and applies the tools straight away.
Faster reports and numbers everyone trusts
Build Tables that grow with the data
Turn a raw list into a clean Excel Table with filters, totals and formulas that extend automatically as new rows arrive.
Summarise thousands of rows in minutes
Create PivotTables that answer “how much, by whom, per month?” and refresh them in one click.
Answer business questions with SUMIFS
Add up and count by several criteria at once, so the numbers in every report come from one clear formula.
Find any value with XLOOKUP
Pull prices, names or targets from another list in seconds, with lookups that stay robust when columns move.
Live online Excel training for teams, wherever they work
One trainer, your whole team and a shared practice file: interactive learning that fits into a single afternoon or morning.
Choose the Excel topics for your session
Combine the core tools in one session, or add a module that takes your reports a step further.
Excel Tables
Structure data once and every formula, filter and chart built on it stays tidy.
CorePivotTables
Group, filter and compare large data sets, and turn the result into a clear summary.
CoreSUMIFS and COUNTIFS
Conditional sums and counts for reports, budgets and sales overviews.
CoreXLOOKUP
The modern lookup for matching data across lists and workbooks.
CoreCharts and simple dashboards
Show the key figures on one page so your colleagues see the story at a glance.
Add-onCopilot in Excel
Let AI suggest formulas and analyses, for teams with a Microsoft 365 Copilot licence.
Add-onShort sessions that fit any working day
Two or three focused hours keep the energy high and the learning practical. Teams that want to go deeper book a series of sessions.
Looking for a full programme? See our advanced Excel training or the Copilot in Excel training.
One focus topic
Ideal for one tool in depth, for example PivotTables or XLOOKUP.
The core toolkit
Tables, PivotTables, SUMIFS and XLOOKUP in one session, each with practice time.
Several sessions
Build skills step by step, with time to apply them between sessions.
Files and formulas to reuse every week
Your practice file
The workbook with every exercise from the session, ready to reuse for your own reports.
Your own worked examples
Each participant leaves with the formulas and PivotTables they built themselves.
A clear next step
A recommendation for the topics your team can go deeper on next.
A three-hour session at a glance
Welcome and your questions
A quick look at the reports your team works on, so every example feels familiar.
Excel Tables
From raw list to structured Table, with filters and calculated columns.
PivotTables
Summarise, group and filter, then refresh with new data.
Short break
Time to stretch and grab a coffee.
SUMIFS and XLOOKUP
Conditional sums and lookups across lists, practised in the file.
Your own case
Participants apply the tools to a task from their daily work, then agree their next step.
A proposal: in a short call we tailor the flow to your team and agree what success looks like after the session.
SkillDay works with teams at
Questions about the live online Excel training
Which platform do you use?
We run the session in Zoom or in your Microsoft Teams, whichever your team prefers. Participants need Excel on their computer and, ideally, a second screen.
Does group size change anything?
The session is priced per booking, regardless of how many colleagues join. Larger groups work in their own files and bring questions through chat and short breakout rounds.
Which time zones can you cover?
Tell us where your team sits and we propose times that work for your locations. Teams spread across several regions often split into two sessions.
Can we choose the topics?
Yes. Pick the functions that matter for your team, and in a short call we shape the session around your typical reports.
Do you work with our own data?
Every session comes with a practice file built on realistic data. On request we shape the exercises around your reports, using anonymised or sample data that looks like yours.
Which Excel version do participants need?
XLOOKUP and Copilot depend on your Excel version and Microsoft 365 licence. We check your setup beforehand and adapt the exercises.
Which languages do you train in?
English and German.
Microsoft, Excel, Microsoft Teams, Copilot and Microsoft 365 are trademarks of the Microsoft group of companies. Zoom is a trademark of Zoom Communications, Inc. SkillDay is an independent training provider and is not affiliated with or endorsed by Microsoft or Zoom.
Jörn Steinz
Founder of SkillDay · trainer and facilitator since 2014
Jörn started as a consultant at Accenture and worked in corporate development at XING and the freenet Group. Today he and a network of around six SkillDay trainers help teams work faster and more accurately with the tools they use every day.
Ready for a live Excel session with your team?
Send us your topics, group size and time zone. We reply with suitable times and a proposal for your session.
Send us your topics