Microsoft Excel Training: from beginner to expert, always tailored
Practical in-company training where your team learns to use Excel efficiently and professionally. From basic calculations to macros and pivot tables. Tailored to your organisation.
8 training programmes, from beginner to expert
Choose the level that suits your team, or let us design a custom programme from the topics most relevant to you.
Exploring Excel
Build a solid Excel foundation.
- Working with the ribbon, cells, columns and rows
- Entering and deleting data
- Opening, saving and recovering workbooks
- Working with multiple worksheets
- Date, time and spell check
Calculations
Learn to calculate efficiently in Excel.
- Using the fill handle and Flash Fill
- Moving, copying and pasting
- AutoSum functions
- Relative and absolute references
- Calculations across multiple worksheets
Formatting
Create professional spreadsheets.
- Cell borders, cell styles and fonts
- Aligning and merging cell contents
- Number formatting
- Using themes
Conditional formatting
Make data visually insightful.
- Applying simple conditional formatting
- Formatting based on rules
- Formatting based on formulas
Printing
Spreadsheets ready for print.
- Page break preview and print area
- Print titles (title rows and columns)
- Headers, footers and margin settings
- Inserting or removing page breaks
Working efficiently
Work faster and smarter in Excel.
- Customising the Quick Access Toolbar
- Creating a personal tab
- Essential keyboard shortcuts
- Optimising Excel preferences
Tables
Structure and overview in large datasets.
- Using filters
- Creating and modifying tables
- Sorting, filtering and table calculations
- Working with table ranges
Graphic objects
Using visual elements professionally.
- Inserting images and shapes
- Formatting graphic elements
- Ordering, grouping and duplicating
- Inserting SmartArt
Collaboration
Working together on spreadsheets efficiently.
- Adding comments
- Tracking changes
- Reviewing changes
Charts
Visualise data convincingly.
- Creating a chart
- Different chart types
- Adjusting design and trendlines
- Sparklines
Miscellaneous
Handy features for daily use.
- Named ranges
- Using custom lists
- Freezing titles and columns
- Split screen
Logical functions
Smart decisions in your spreadsheets.
- IF function and nested IF
- AND and OR functions
- Combining nested functions
Date and time functions
Calculating with dates and times.
- TODAY and NOW functions
- DAY / MONTH / YEAR functions
- DATEDIF function
- Calculating with date and time
Pivot tables & charts
Excel's most powerful analysis tool.
- Creating and adjusting pivot tables
- Creating pivot charts
- Filtering data and using slicers
Lookup functions
Looking up data from other tables - classic and modern.
- XLOOKUP function (the modern successor)
- XMATCH function
- VLOOKUP function (classic)
- HLOOKUP function (classic)
Dynamic array functions
The most powerful new functions in Excel.
- FILTER function - filter data with formulas
- SORT and SORTBY functions
- UNIQUE function - remove duplicates
- SEQUENCE function
Statistical functions
Analyse data with powerful formulas.
- AVERAGEIF(S) function
- COUNTIF(S) function
- SUMIF(S) function
Text functions
Cleaning and editing text data.
- TEXTSPLIT, TEXTBEFORE and TEXTAFTER
- CLEAN and TRIM functions
- SUBSTITUTE and REPLACE functions
Advanced formulas
Professional-level formulas.
- LET function - name calculations
- LAMBDA function - create custom functions
- GROUPBY and PIVOTBY functions
- Database functions (DAVERAGE, DCOUNT)
What-if analyses
Calculate and simulate scenarios.
- Defining and reporting scenarios
- Generating pivot tables from scenarios
- Goal Seek
- Data tables
Automation
Automate recurring tasks.
- Recording and editing macros (VBA)
- Assigning macros to a button or shape
- Introduction to Office Scripts (modern alternative)
Power Query
Import, transform and clean data.
- Getting data from diverse sources
- Transformations and cleaning in the Editor
- Data validation and drop-down lists
Python in Excel
Advanced analyses with Python.
- Running Python code in cells
- Data analysis with pandas and NumPy
- Creating advanced visualisations
Date and time functions
Essential for HR administration.
- TODAY and NOW functions
- DAY / MONTH / YEAR functions
- DATEDIF function
- Calculating with date and time
Miscellaneous
Keeping overview in HR data.
- Named ranges
- Using custom lists
- Freezing titles and columns
- Split screen
Working efficiently
Work faster with HR spreadsheets.
- Customising the Quick Access Toolbar
- Personal tab and keyboard shortcuts
- Optimising Excel preferences
Logical functions
Automate decisions in HR overviews.
- IF function and nested IF
- AND and OR functions
- Combining nested functions
Collaboration
Safely collaborate on personnel data.
- Tracking and reviewing changes
- Protecting worksheets
- Protecting parts of worksheets
Lookup functions
Quickly look up employee data.
- XLOOKUP function (the modern successor)
- VLOOKUP function (classic)
- XMATCH function
Charts
Present data convincingly to stakeholders.
- Chart types, design and trendlines
- Sparklines for compact overviews
Pivot tables & charts
Build management reports.
- Creating and adjusting pivot tables
- Pivot charts and slicers
Collaboration
Sharing and protecting workbooks.
- Tracking and reviewing changes
- Protecting worksheets and sections
Tables
Structuring and filtering team data.
- Creating, sorting and filtering tables
- Table calculations and table ranges
Logical functions
Automate complex decisions.
- IF, AND and OR functions
- Combining nested functions
Graphic objects
Make reports visually appealing.
- Images, shapes and SmartArt
- Grouping and formatting objects
Calculations & tables
The foundation for financial models.
- Relative and absolute references
- Creating, sorting and filtering tables
- Table calculations and table ranges
Pivot tables & charts
Building financial reports.
- Pivot tables, pivot charts and slicers
- Chart types, trendlines and sparklines
- Conditional formatting
Functions & formulas
From date to logical functions.
- Date and time functions (TODAY, DATEDIF)
- Statistical functions (AVERAGEIF, COUNTIFS, SUMIFS)
- Logical functions (IF, AND, OR)
- XLOOKUP and VLOOKUP
- Dynamic array functions (FILTER, SORT)
Automation & data
Automate recurring tasks.
- Recording and editing macros
- Power Query: importing and transforming data
- Text functions for data cleansing
What-if analyses
Calculate financial scenarios.
- Defining and reporting scenarios
- Goal Seek and data tables
- Data validation and drop-down lists
Collaboration & efficiency
Working productively in financial teams.
- Tracking and reviewing changes
- Keyboard shortcuts and toolbar setup
- Named ranges and custom lists
Why choose this Excel training?
No standard story, but a training that matches how your team actually works.
Immediately applicable
You practise with recognisable examples from your own work environment. No fictional cases, but your own spreadsheets and data.
100% tailored
In a preliminary meeting we map your industry, tasks and skill level. The training is customised accordingly.
Experienced Microsoft trainer
Over 15 years of Microsoft 365 training experience. Always up-to-date with the latest Excel features.
Is the Excel training right for you?
Whether you are a beginner or have been using Excel for years: we have a programme that perfectly matches your level and role.
Administration & secretarial
Learn to work efficiently with tables, formatting and calculations. Save time every day with smart use of shortcuts, fill handle and AutoSum.
HR professionals
Work with date and time functions for leave calculations, use VLOOKUP for employee data and protect sensitive worksheets.
Managers & team leads
Build convincing reports with pivot tables and charts. Analyse team data and present results clearly to stakeholders.
Finance professionals
From financial models to macro automation: the two-day Financials programme covers everything you need, from formulas to what-if analyses.
Everything you need to know
Approach
The training combines short theory sessions with extensive hands-on exercises. We use recognisable examples from your own work environment, so you can apply what you have learned that very same day.
Levels
We offer four levels: Basics, Intermediate 1, Intermediate 2 and Expert. In addition, there are industry-specific programmes for Human Resources, Managers/Team Leads and Financials. Together we determine the best fit in the preliminary meeting.
Tailored
Virtually every Excel training we deliver is customised. We combine topics from different levels and programmes into one training that precisely matches the daily practice of your team.
Excel version
We train by default in the latest version of Microsoft Excel (Microsoft 365), including modern features such as XLOOKUP, dynamic array formulas, Power Query and Python in Excel. Does your organisation use an older version? No problem: we adapt the training accordingly and clearly indicate which features are version-specific.
Materials & follow-up
After the training each participant receives a comprehensive summary with examples and exercises. If you have questions after the training, you can always reach out to us.
From request to result
Every Excel training is carefully prepared and tailored to your organisation.
Introduction
A short conversation to understand your needs, target audience, industry and current Excel level. No obligation.
Custom design
We design a programme with examples and exercises from your own work environment and industry.
Deliver training
Interactive, practical and lively. Online or on-site. Immediately applicable tips and techniques.
Follow-up
Summary, exercise files and the option for follow-up. So that what you have learned sticks.
What participants say
"Very instructive training delivered with great enthusiasm. Interactive, space for sharing own cases and lots of helpful tips and tricks I can use right away."
"Got lots of information about smarter ways to accomplish the same things. There was a big difference in levels in the workplace, but the trainer handled this flexibly."
"The Excel training was perfectly tailored. We now build our financial reports in half the time. The tips on pivot tables and keyboard shortcuts were a real eye-opener."
Everything about the Microsoft Excel training
We offer four levels: Basics, Intermediate 1, Intermediate 2 and Expert. Additionally, there are industry-specific programmes for Human Resources, Managers/Team Leads and Financials. Together we determine the best fit in the preliminary meeting.
That depends on the chosen level. No prior knowledge is needed for the basics training. For Intermediate 1, basic Excel knowledge is recommended. For Intermediate 2 and Expert, more experience with formulas and tables is needed. We assess the skill level in the preliminary meeting.
A standard Excel training takes one day. The Excel for Financials training spans two days. A half day or multi-day programme is also possible. We tailor the duration to your needs.
We train by default in the latest version of Microsoft Excel (Microsoft 365), including modern features such as XLOOKUP, dynamic array formulas and Power Query. Does your organisation use an older version such as Excel 2019 or 2021? No problem: we adapt the training accordingly and indicate which features are version-specific.
Absolutely. Virtually every training is tailored. We combine topics from different levels and industry programmes into one training that precisely matches your daily practice.
Yes, all our Excel trainings are available in-company, at your location or online. We fully tailor content, examples and exercises to your organisation, industry and job function.
Certainly. Excel combined with Copilot, or Excel with Power BI? We are happy to create a custom programme. Get in touch to discuss the possibilities.
Book the Microsoft Excel training for your team
Fill in the form on our contact page or call directly. We will get in touch within two business days to discuss your needs. No obligation.