Excel Gegevensvalidatie, Functies & Formules incompany
A one-day course just for your group. You choose the date and the place, and the trainer tailors the content to your practice beforehand.
NRTO quality mark
- Tailored: matched to the level and goals of your team
- Trainers from the field, who do the work themselves
- At your premises, at ours or online, on a date that suits you
- In Dutch or English, in the language of your choice
What the course covers
Do you work on the same files together with colleagues? Then you will recognise this: everyone enters data in their own way and before you know it your list is polluted. Data validation keeps your data clean and consistent. In this course you will learn how to go about this and how to get much more out of your data with advanced functions and formulas. Practical, immediately applicable and focused on the challenges you come across in your work.
Lees het volledige programma van Excel Gegevensvalidatie, Functies & Formules
How an in-company course works
- RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
- AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
- The courseOn the day and at the place you chose, with course materials for every participant.
- AfterwardsEvery participant receives a certificate of attendance.
Practical information
- Duration
- Ééndaagse
- Group
- Only your own people
- Location
- At your office, at one of our locations or online
- Date
- You choose
- Language
- Dutch or English
- Included
- Course materials and a certificate of attendance
- Price
- Vaste prijs per groep, in een offerte op maat
Wat deelnemers zeggen over Excel Gegevensvalidatie, Functies & Formules
"If you want to do anything with data validation, this course comes highly recommended. After this course you will have learned a great deal about validating data."
Veelgestelde vragen over Excel Gegevensvalidatie, Functies & Formules incompany
Waar vindt de incompany training Excel Gegevensvalidatie, Functies & Formules plaats?
Wherever suits you: at your office, at one of our training locations or online. You also choose the date.
Can the content be tailored to our organisation?
Yes. Before the course we discuss with you what the group can already do, where things go wrong in practice and what should be different afterwards. The trainer uses examples and exercises from your own work.
How large can the group be?
That depends on the course. For a skills course we prefer to work with a small group, so that everyone can really practise. If more people are involved, we schedule several groups or set up a fixed programme.
Wat kost Excel Gegevensvalidatie, Functies & Formules incompany?
Je krijgt een vaste prijs voor de hele groep, in een offerte op maat. Met een groep is dat voordeliger dan iedereen los inschrijven.
Can the course be delivered in English?
Yes. For in-company courses we deliver the training in the language of your choice, Dutch or English. Mention it in your request.
Do participants receive a certificate?
Yes, every participant receives a certificate of attendance afterwards.
How do I request a quote?
Via the quote form: state the course, the number of participants and roughly where and when you would like it. An adviser will then contact you.
What will I learn in this course?
You will learn how to prevent input errors in Excel using data validation and how to apply advanced functions and formulas. Think of drop-down lists, error messages, text functions, lookup and reference functions such as INDEX and MATCH, statistical functions and array functions. You will pick up plenty of practical tips to make your work in Excel more efficient.
Who is this course for?
The course is intended for experienced Excel users who regularly work with larger files and want to expand their knowledge of formulas. You often work together with colleagues in the same lists or import data from other systems. You want to prevent errors and get more out of your data.
What prior knowledge do I need?
You are at the level of the Excel Intermediate course. You work fluently with basic formulas, know functions such as VLOOKUP and IF and feel at home with larger worksheets. Not sure? Get in touch and we will work out together which level suits you.
What does the course look like?
We start with an introduction to data validation and its benefits. After that, you will work in turn with text formulas, lookup and reference formulas, statistical and mathematical formulas and array functions. Short explanations alternate with practical exercises throughout, so you apply what you have learnt straight away.
What is the delivery format?
The course is classroom-based and taught in a small group. This leaves plenty of room for questions and your own examples. Would you rather train with your whole team? You can also take this course in-company.
Who teaches the course?
The course is delivered by an experienced Excel trainer from Learnit. Our trainers have extensive practical experience and know exactly which pitfalls you come across in practice. They adapt their explanations to the level and working situation of the participants.
What do I get after the course?
You go home with practical knowledge that you can apply directly to your own Excel files. You also receive a Learnit certificate as proof of participation. You can reuse the examples and exercises later for reference.
How can I prepare?
No real preparation is needed. It is useful, though, to think in advance about Excel files or issues from your own work that you are struggling with. You can bring these along during the course, so that the trainer can help you specifically.
Excel Gegevensvalidatie, Functies & Formules voor jullie team?
Request a quotation without obligation and you will hear from an adviser soon.