Corporate Excel training your teams use the very next day
Hands-on Excel sessions for teams across countries – from PivotTables and XLOOKUP to charts for your slides. Every exercise is built around your industry, so participants practise each function with the kind of data they handle every day – and keep working faster from the next morning on.
See it
The trainer builds one function step by step on screen, at a pace everyone can follow.
Do it
Straight away, everyone applies it in their own worksheet with a related task.
Reflect
We look at what worked and clear up questions while they are fresh.
Next function
Then we move on. Short loops keep every participant active all session.
Three focus areas, covered in three hours
Every live session works through three focus areas. Within each one, we pick the functions that matter most for your teams from the curriculum below.
Tables and lists
Your team formats data as tables, sorts and filters with several criteria, lets conditional formatting point out what matters and summarises it with PivotTables.
Functions
Your team connects lists with XLOOKUP, counts and sums with conditions and builds formulas that colleagues can follow and trust.
Data visualisation
Your team picks the right chart type and designs clear, meaningful charts that make the message obvious on the next slide.
Corporate Excel training content: the full overview
Everything we can cover in the three focus areas, from Format as Table to XLOOKUP to waterfall charts. In the briefing we choose the topics that fit your teams for the three-hour session; a series of sessions covers more of the list.
Tables and lists
Clean, structured data that is quick to filter, summarise and share.
Tables and lists
- Format as Table
- Sort and filter with multiple criteria
- Freeze Panes
- Hide and unhide rows and columns
- Number and custom cell formats
- Keyboard shortcuts that save time every day
Clean and combine data
- Compare and merge tables
- Remove Duplicates
- AutoFill
- Absolute and relative cell references
- Import data, e.g. from PDF
Analyse and present
- PivotTables
- Conditional Formatting
- Sparklines
- Named Ranges
- Drop-down lists with Data Validation
- Linked Pictures
- Protect Sheet and Protect Workbook
Functions
Calculations your team can build, read and trust.
Lookup and reference
- XLOOKUP
- VLOOKUP and HLOOKUP
- INDEX/MATCH
- Lookups with multiple criteria
Logic
- IF and nested IF
- AND, OR
- IFERROR
- Conditional formatting with formulas
Count and sum
- COUNTIF, COUNTIFS
- SUMIF, SUMIFS
- SUMPRODUCT
- SUBTOTAL
- FREQUENCY
Text and dates
- LEFT, RIGHT, MID, LEN
- CONCAT and Text to Columns
- UNIQUE, ISBLANK
- Date and workday functions such as NETWORKDAYS and WORKDAY
What-if analysis and forecasting
- Goal Seek
- Data Tables for break-even analysis
- FORECAST and TREND
- Show Formulas and Watch Window to check your work
Data visualisation
Charts that make the point at first glance – ready for your slides.
Design that guides attention
- Choose the right chart type
- Clear, uncluttered design
- Highlight the one number that matters
Typical business cases
- Before-and-after comparisons
- Distributions
- Plan versus actual
Special chart types
- Waterfall and bridge charts
- Gantt charts
- Bar-in-bar charts
- Dot plots
- Slope charts
Turn one session into a learning path
Core session
The three-hour corporate Excel training with its three focus areas – the foundation for every team.
Follow-up sessions
A series of sessions over several weeks lets teams go deeper, one topic at a time.
Copilot in Excel
Add AI to the toolkit with our Copilot in Excel training once the foundations are in place.
Corporate Excel training built around your industry
Corporate Excel training is Excel training your company books for its own teams. Ours goes one step further: participants practise with an exercise file from your industry, so the function they learn at ten is the function they use at eleven.
Your industry’s exercise file
Participants receive an exercise file related to your business. All tasks work in their context.
Show, do, reflect
The trainer shows a function, participants apply it right away, we reflect and move on.
One format for every location
Live online sessions for each team, scheduled around their time zone.
Excel training for employees who work with data every day
The training is ideal for teams whose results depend on clean lists, quick analyses and clear reports. Here is what the three focus areas look like in different departments.
Finance and controlling
Summarise costs by cost centre and month with a PivotTable and flag budget overruns automatically.
Trading
Filter positions by several criteria at once and pull current prices into your list with a lookup.
Sales
Rank customers by revenue, look up prices and discounts from the price list and chart the pipeline by region.
Marketing
Compare campaign results in a PivotTable and turn them into one clear chart for the next review.
HR
Keep employee lists as tables, highlight contract end dates automatically and summarise headcount by department.
Logistics
Filter shipments by route, status and date, highlight delays and match order numbers across lists.
From first call to trained teams in four steps
Short briefing call
In 30 minutes we clarify goals, level and what success looks like after the training.
Your exercise file
We prepare an exercise file related to your industry, so every task fits your teams’ daily work.
Live sessions per team
Online or onsite, scheduled for each team and its time zone.
A file to keep
Participants keep the exercise file they worked in – a reference for the next time a task comes up.
Live online for global teams, onsite where it suits you
Teams spread across Europe, the Middle East, Africa and Asia each get a session that fits their working day – with the same content and the same exercise file everywhere.
Regular onsite locations include Berlin, Cologne, Düsseldorf, Frankfurt, Hamburg, Hanover, Munich, Stuttgart, Vienna and Zurich.
Looking for short sessions for a single team? Have a look at our live online Excel training for global teams.
Live online
Three interactive hours on the video platform your company uses. Ideal for teams spread across countries.
Onsite at your office
The same hands-on format in your meeting room, with everyone working on their own laptop.
Several teams, one standard
Each team or region gets its own session – the content stays consistent across the company.
Everything participants need is already on their desk
For live online sessions
A laptop with the desktop version of Excel, ideally Microsoft 365, plus camera and microphone. A second screen makes it easy to watch and practise side by side.
For onsite sessions
A screen or projector with HDMI and a laptop with Excel for every participant. We bring everything else.
SkillDay trains teams at leading companies
Questions about our corporate Excel training
What is corporate Excel training?
Corporate Excel training is Excel training that a company books for its own teams. Content, examples and timing are tailored to the company, instead of a public course with participants from many organisations.
What makes this corporate Excel training different?
Every exercise works with data from your industry. Participants receive an exercise file related to your business, so each function is practised in the context they work in every day.
Can you train teams in different countries?
Yes. The training runs live online, so teams in several countries can take part. Each team or region gets its own session at a time that suits its working day.
Which Excel topics does the training cover?
The training covers three focus areas: tables and lists (including PivotTables and Conditional Formatting), functions (including XLOOKUP, SUMIFS and IF) and data visualisation. From the full curriculum we select the topics that fit your teams.
Do you cover XLOOKUP?
Yes. XLOOKUP is part of the lookup block, alongside VLOOKUP, HLOOKUP and INDEX/MATCH, including lookups with multiple criteria.
How long is a session?
Three hours. One live session covers all three focus areas with the topics we selected together. A series of sessions covers more of the curriculum.
Can the training also take place onsite?
Yes. We can also run the corporate Excel training at your office, with the same hands-on approach.
Which level is the training for?
We agree the starting level in a short briefing call and adapt the exercises so that both confident users and newer users get real value from the session.
How is the training priced?
We charge per training hour, independent of the number of participants. Live online sessions involve no travel costs. Ask us for a proposal for your teams.
Which Excel version do participants need?
The desktop version of Excel. Microsoft 365 is ideal, because newer functions such as XLOOKUP are only available in recent versions. We check this in the briefing.
In which language is the training held?
In English or German.
Can we add Copilot in Excel?
Yes. If your teams use Microsoft 365 Copilot, we can add a block from our Copilot in Excel training.
How quickly can we start?
Check our available workshop days and pick the dates that suit your teams. We prepare the exercise file in the time before the first session.
Jörn Steinz
Founder of SkillDay, a network of around six trainers. Jörn worked as a consultant at Accenture and in corporate development at XING AG and freenet Group, holds an MBA from EADA Business School Barcelona and has been running Excel trainings since 2014.
Book a corporate Excel training for your teams
Tell us about your teams, locations and goals. We reply within 24 hours with a proposal and available dates.