<p>In this course you will learn how to prevent input errors using data validation and how to apply advanced Excel formulas: text, lookup, statistical and mathematical formulas and array functions.</p>
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.
Keep your Excel lists clean
When several people work in an Excel file, errors soon creep into the data. Everyone has their own way of entering data, and you see that reflected in inconsistent lists. With data validation you limit the input to what makes sense. Think of a figure between 1 and 10 or a percentage up to 100. That way your data remains usable for further processing.
Advanced functions and formulas
In addition to data validation, we cover a broad range of functions and formulas. You will work with text functions to convert incorrectly imported data, with lookup functions for when VLOOKUP does not provide the answer, and with array functions that generate results in one go without intermediate steps. Along the way, the trainer shares plenty of practical tips to help you get even more out of your Excel data. By the end of the course you will be able to manage your files better, prevent errors and build more complex calculations in a clear, structured way.
For teams and organisations. If your department works in shared Excel files, we also run this course in-company. Everyone then learns the same way of restricting input and building formulas, and in consultation with you, we work with examples from your own practice.
After this course you can set up data validation independently and prevent input errors in your Excel lists. You work smoothly with text formulas to clean up data and with lookup and reference formulas that go beyond VLOOKUP. You apply statistical and mathematical formulas to larger datasets and you know how to use array functions to carry out several operations in a single formula. Your Excel files are cleaner, more intelligently structured and you work considerably faster.
This course is intended for experienced Excel users who want to keep their lists consistent and expand their knowledge of functions and formulas. You regularly work with larger datasets, share files with colleagues and want to prevent input errors. Whether you work in finance, administration or analysis: if you find that standard formulas no longer get you there, this is the course for you. Also useful if you often import data from other systems.
The course is also suitable if you create forms or templates that colleagues use, for example in planning, HR, purchasing, sales support or project administration, and you want the data in them to remain usable.
The course is classroom-based and taught in small groups. This leaves plenty of room for questions and your own examples. The trainer alternates short explanations with practical exercises, so that you apply what you have learned straight away in Excel. You work with recognisable examples and pick up tips and tricks along the way that you can use directly in your own work. Would you rather work through this material with your whole team? An in-company version is also possible.
You have Excel experience at the level of the Excel Intermediate course. You work comfortably with basic formulas, you know functions such as VLOOKUP and IF, and you feel at home with larger worksheets. Not sure about your level? Just get in touch and we will look together at which course suits you best.
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
"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."
“LearnIt is the right place to follow a course. Everything is arranged down to the last detail, all kinds of questions can be raised and there is always a suitable answer. A great experience!”
“Do you want to get more out of Excel in your daily work? Then this is a good step in the right direction!”
"Useful and interesting course!"
“Even if you only have basic knowledge and experience, you can learn a great deal from this course. Learning tricks that can make your work easier and give you a better overview.”
“I can do far more with Excel than before; I can conjure up database functions, pivot tables and charts in no time.”
“A good course for laying a structured foundation for working with and programming in VBA.”
"A good, committed trainer who tries to offer knowledge that matches the level and the questions of the participants"
"Excellent, professional training course with plenty of 'tips & tricks' for every starting level."
“Clear and straightforward course book, the level is good, a pleasant trainer who explains things clearly and anticipates at the right moments. The pace of the lessons is good, a very professional trainer. Instructive, in other words!”
“I sincerely recommend it, training at a good level with very carefully prepared materials.”
“The Excel course for beginners is a practical, useful and pleasant course to take. Afterwards you can take the course material home with you, so you can use it as a reference. The training group is not too large, and the trainer has a very good command of the subject. If I take another computer training course in future, I will certainly look at what Learnit has to offer.”
“A clear and complete course, given by a highly competent trainer who conveys the course material in a clear and structured way.”
"A very pleasant and efficient way to master the material under expert guidance at a superb location."
“Good basic training. I use the programme regularly myself, but I learned plenty of handy tips&tricks that will certainly make day-to-day use easier.”
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“A pleasant way of picking out from the complete set of course materials only those subjects you are interested in, without being worn out by matters you have no interest in.”
“I learnt a lot from it and in an enjoyable way. Thanks Dirk.”
"The teaching method is very pleasant. You can discuss the problems you encounter at work at length during the course and arrive at a solution together with the trainer. Learnit informed me quickly and clearly about the course. I am very satisfied. I have also recommended you to my colleagues, several of whom are going to take a course."
“It is an excellent course with clear course materials. I learned a great deal from it.”
“'Highly instructive. Directly applicable in practice. An enthusiastic trainer with clear and personal explanations.'”
“Clear, easy-to-follow course with personal guidance.”
"A. Hannink, Camposol - "Good basic and follow-up courses with a professional teacher and good course materials." - Rating: 8.3"
“The training is clear and easy to follow at any level.”
“Sjoerd Jellema made the course personal by explaining the material with exercises, which I then applied myself. Sjoerd is a pleasant course leader who has a good command of the subject matter but also carries the group along with the material being covered. I found the course very practical, and cases I brought along myself were also dealt with. This brought the theory to life in practice.”
“The trainer takes the time and explains things well.”
“A revelation: the structure of the learning, the guidance and, as a result, the outcome. With a well-catered lunch – an example for anyone giving courses.”
“Doing is learning”
“Macros are very applicable to your own working situation. A very good course that fits your personal needs well.”
"Good, comprehensive course, clear materials, highly recommended!"
“This training really is worth recommending: a small group of people, a serious teacher and I learned a lot.”
"An expert trainer who can quickly put himself in the position of real-life situations."
“Good course, you get a lot of practical information that you can really put to use.”
“Discovering new applications from start to finish. Excel opens up a whole new world for you.”
“In two days you learn to apply the basic skills of Excel properly”
"Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."
“This training really is worth recommending: a small group of people, a serious teacher and I learned a lot.”
"A.M. Rooyakkers-Smits, Makro Amsterdam - "The course is clear and well structured. Everyone can work at their own pace and level." Rating: 7.3."
"Good, I learnt a lot of things that I can use in my work."
“Very good that courses are offered in this way! Useful explanation of pivot tables in Excel so you can start using them yourself as quickly as possible!”
“The Excel 2007 basics course I took at Learnit in Groningen gave me, in two intensive days, a great many tools that I can use on a daily basis. The result exceeded my expectations. In two days, the Excel 2007 shortcut on my desktop has gone from being a link to gibberish to a calculation programme in which, alongside ordinary sums, I can also produce and save minimums, maximums, charts and averages.”
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"
“A pleasant way of working through the material. A book with clear instructions and a trainer in the background who answers questions!”
“Good teaching method. Plenty of material. Very satisfied with Learnit.”
“The trainer was highly driven and motivated. Excellent explanations and good interaction with me as the knowledge recipient. Sufficient depth, excellent course.”
“I found it an enjoyable and instructive course, with plenty of handy tips and facts about Excel, and I also learned a lot more about functions, pivot tables and VLOOKUP.”
“I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”
“The independent way of working really appeals to me in this course concept. You can also bring along problems from your daily practice, which then get attention.”
“Instructive”
“I have been working with Excel for quite some time. However, I had no idea of everything you can do with it. I would recommend this course to any novice like me! Do it!!”
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.
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.
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.
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.
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.
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.
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.
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.
Unable to attend? Let us know as soon as possible. We will look for a suitable solution together and reschedule you to another date free of charge, provided you cancel in time. You can find the cancellation conditions on our website.
Yes, afterwards you receive a Learnit certificate as proof of participation. It is a useful addition to your CV and shows that you have expanded your Excel skills in a targeted way.
You can book easily via our website. Choose a date that suits you and complete the booking form. Do you have questions or would you prefer to discuss things by phone? Then contact our course advisers, who will be happy to help.
You will find the current price at the top right of the course page.