Learnit Training
Course Excel data validation, Functions & formulas
  • Improve the consistency and accuracy of your Excel lists
  • Easily apply Gegegevensvalidatie
  • Set up features and formulas for even better validation
  • Prevent input errors and data contamination
  • Get even more out of your Excel data

Improve the consistency and accuracy of your Excel lists and get even more out of your data? Follow the 1-day course Excel data validation, features & formulas of Learnit.

Yes, I want to know more

"Good course for beginners, even if you don't have anything to do with computers. A child can do the laundry! "-Rating: 8.6

learnit Excel Basic

Course Excel data validation, Functions & formulas

Keep your Excel lists consistent and correct

If you work with multiple people in an Excel list, the risk of data contamination is great. After all, everyone has their own way of entering data. For example, if a report digit or percentage is to be filled in, it is useful if the range can be limited to 10 or 100%. Data validation in Excel helps keep your data consistent and accurate by preventing or resolving input errors. This way your Excel list remains pure and the data is still suitable for further editing. Find out how to apply data validation in the 1-day Excel Data validation course, features & formulas.

Features & Formulas

If you work with multiple people in an Excel list, the risk of data contamination is great. After all, everyone has their own way of entering data. For example, if a report digit or percentage is to be filled in, it is useful if the range can be limited to 10 or 100%. Data validation in Excel helps keep your data consistent and accurate by preventing or resolving input errors. This way your Excel list remains pure and the data is still suitable for further editing. Find out how to apply data validation in the 1-day Excel Data validation course, features & formulas.

Features & Formulas

In addition to working with data validation, a whole range of functions and formulas are also discussed to help you manipulate your data. Text functions to convert incorrectly imported data, search functions such as vertical search do not provide a solution and array functions that allow you to generate outcomes without many intermediate steps. Find out how to apply functions and formulas in the 1-day Excel Data validation course, features & formulas.

Content course Excel data validation, Functions & formulas

In the Excel training data validation, functions & formulas You learn in just one day everything about validating your Excel data and advanced functions are treated. The day begins with an introduction of data validation, where you learn the benefits and the ways to keep your data as pure as possible. Then you'll get started with text formulas, search and reference formulas, mathematical formulas, statistical formulas and array functions. In addition, you get countless practical tips and tricks from our Excel expert to get even more out of your Excel data.

Parts Excel-Training data validation, functions & formulas

In the Excel data validation course, features & formulas include the following topics:

What is Excel data validation?

The benefits of data validation, forms of data validation: list box, input message and error message, unique data with data validation and conditional list boxes in combination with the INDIRECT function.

Text formulas:

START LETTERS, UPPERCASE LETTERS, LENGTH FIND. SPEC, LEFT, RIGHT, SPACES. ERASING TEXT. MERGE, REPLACE, SUBSTITUTE, REPETITION

Finding and referencing data:

INDEX, COMPARE, INDIRECT, CONVERT

Statistical formulas:

AGGREGATE, GRADE. EQUAL, LARGEST, SMALLEST

Mathematical formulas:

ROUNDING, SUM. IF, SUMPRODUCT, conditional SUMPRODUCT

Array functions:

SUM, AVERAGE, transpose and INTERVAL

Target

The training Excel data validation, features & formulas is intended for experienced Excel users who want to learn more about data validation and to apply advanced features and formulas.

Lesmethodiek

Learnit offers the course Excel data validation, functions & formulas as classroom training and incompany training. The training takes place in small groups and is provided by an experienced trainer. Theory and practice assignments alternate, allowing you to put the scholar directly into practice. You can follow the training on your own laptop or on a practice laptop of Learnit Training. Afterwards, a Learnit certificate will be issued as proof of participation.

Afterwards, a Learnit certificate will be issued as proof of participation.

  • Result course Excel data validation, Functions & formulas
  • After completing the training Excel data validation, Functions & formulas:
  • Do you know what data validation in Excel entails.
  • You know the statistical and mathematical formulas that help you understand your data.
  • You know how to use array functions.
  • You can get even more from your Excel lists by improving the consistency and correctness of your data.
  • Prior knowledge
  • To participate in the training Excel data validation, functions & formulas You must have followed at least the course Excel sequel.
  • Note
  • This training can be followed in different versions. Please indicate whether you are using Excel 2007, 2010, 2013 or 2016.
  • Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location

Duration

1 day

2 sessions

Price per day, excl. VAT

€ 475,- Online
€ 390,- Total, incl. VAT € 574,75
€ 471,90 Certificate After completing the training, a LEARNIT certificate will be issued as proof of participation.
Subscribe Quotation Download PDF Training Dates Sort by date Sort by place name

Live Online

Next Event


Wednesday 16 September 2020, 09:00-12:00

Online

Wednesday 17 February 2021, 10:00-17:00

Monday 22 March 2021, 10:00-17:00

  • Friday 30 April 2021, 10:00-17:00
  • We organiseren deze training ook online. Hiervoor maken we gebruik van Webbex of Zoom. Inloggen met Skype is ook mogelijk. Op verzoek kan deze training ook met Microsoft Teams worden georganiseerd.

Google references about learnit

Course Excel Data Validation, Functions & Formulas References

References

The course Excel Data Validation, Functions & Formulas has been assessed with an average of 8.4.

"I took the Office Basic Excel 2003 Course for 2 days. First of all the accessibility was very good (less than 10 minutes walk from Amsterdam Rai station. The course went well. There was a nice atmosphere and the explanations of the teachers were super! The nice thing is that if you have skills that are not discussed in the course, you can report them to the teacher, who will then look for the assignments for you, so you can learn them as well. All in all I had a great experience and learned a lot! - Assessment: 8.1

A. Gelijsteen, Klemko Techniek B.V. - Excel 2003 Basic

"Good course for beginners, even if you don't have anything to do with computers. A child can do laundry!" - Rating: 8.6

E. Veldman, MNO Vervat B.V. - Excel Basic

"Expert lecturer who can move quickly in practical situations." - Assessment: 8.1

I. Beuving - Excel Basic

E.J. Jonker, NV Nederlandse Gasunie - Excel Basic

"Sjoerd Jellema made the training 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 material, but also gets the group involved in the material to be treated. I have experienced the course as very practical, in which cases I brought along myself were also discussed. Because of this, the theory has been put into practice". - Assessment: 9.2

L. Poortman, Laurentius - Excel Continued

"Fortunately I didn't feel nitwit thanks to the trainer and the step-by-step method as well as the regular recapitulation. My 2 days have flown by and with my course book nearby, I feel pretty Exel-proof; can help our youth". - Assessment: 8.1

Marianne the Earl, Coty Prestige - Excel 2002 Basic

"I experienced the training as very instructive in a quiet pleasant environment and led by an expert teacher. Thank you." - Rating: 8.0

R. Terlouw, Zegro Centre Rotterdam - Excel 2003 Continued

"Never thought I could learn so much about these programs. I'm also very glad I followed them." - Rating: 9.0

P. Sahl, NUON - Excel Basic

"An independent, personalized course. Because of this, the Excel program has called upon me to think much more creatively about the possibilities of using Excel in my work". - Assessment: 8.4

F. Gommes, Movement of Mercy - Excel Basic

"The content of the Excell 2003 course was perfectly in line with my learning objectives. The individual way of teaching, i.e. getting started works very well. If you have any questions, you get specific help. The after-care is also very well arranged; you can still contact the teacher. - Rating: 9.0

M. Tjon Lim Sang, Ministry of Foreign Affairs - Excel 2003 Turning tables, formulas and functions

"Excellent teaching material, teacher with a good knowledge of Excel." - Rating: 8.0

M. Hutterd, Geas Energy Guard - Excel 2003 Expert

"A good course, a pleasant teacher, a lot of subjects that I personally use in my work." - Review: 7.9

P. De Vries - Nederlandse Gasunie N.V. - Excel Continued

"No pressure that you have to be at the same pace as fellow students who might be faster, think of classroom training. If necessary, the help of a trainer is present and he will come as soon as you ask for it". - Rating: 8.0

Marjan Lof, Yarden Funeral Insurances N.V. - Excel Turning tables, formulas and functions

"A very professional traing, excellent applicability and easy to follow." - Assessment: 9.1

A. Hannink, Camposol - Excel Basic

"Again a good training with a lot of content that can be put into practice, also had extra exercises from the excellent trainer Sjoerd Jellema". - Rating: 9.0

Eddie Ederveen, Vion Scherpenzeel B.V. - Excel Continued

"Highly educational training with a good individual approach that suits the student." - Assessment: 9.4

Inge Leerintveld, Roma Service Cinemas - Excel Revolving tables, formulas and functions

M. Benschop - Excel Continued

"The course I took allowed me to set my own pace. It also allowed me to pay more attention to certain chapters than to other parts of the teaching material, which were less applicable to me. I have experienced this way of following a course as very enjoyable". - Review: 7.9

P. Sleurink, Prorail - Excel Basic

"The Excel 2010 VBA Course gives a good start on Macros and its programming!" - Review: 7.8

Tuncay Sahin - Excel VBA

"If you have problems with excel in practice, take this course. In addition to the regular course material, there is plenty of time to deal with your own practical examples". - Rating: 8.0

Koen Smelter, Euler Hermes Credit Insurances - Excel 2002 Continued

"A. Effendi, Plan-it by Praxis B.V. - "This is the right solution for anyone looking for a tailor-made training course. The groups are not large and the trainer is sufficiently qualified. You can indicate your learning goals in advance and we will advise you which course suits you best. The teaching material is to the point and ends with a case that you have to solve to see if what you have learned can be applied. At least I learned what I wanted to know and that's what it's all about, after all." Rating: 8.0."

- Excel Expert

"The teacher takes the time and explains well." - Rating: 8.0

I. Bojovich, Robert Walters - Excel Basic

"A nice way to work your way through the material. A book with clear instructions and a teacher in the background answering questions!" - Rating: 9.0

J. Coesmans - Excel Continued

"I learned the many possibilities and applications during the 2-day training, so that working with Excel has become much more attractive". - Review: 7.9

T. Chain, The Royal Bank of Scotland N.V. - Excel 2003 Continued

"You'll learn the basic skills of Excel in two days." - Assessment: 7.3

R. in Green, Cofely. - Excel Basic

"It's nice to be able to work at your own pace and ask specific questions when you get stuck." - Assessment: 7.4

P. Raven, Municipality of Almere - Excel 2003 Continued

"Hans gives you, as a student, the feeling that you can learn Excel very well, even if you are more visually oriented or more alpha than beta, which is very nice". - Rating: 9.0

M. Poelmann, TU Delft - Excel Basic

“Learnit is een echte goede training organisatie, wat ik goed vind is dat je ook de boek meekrijgt en dan kan je altijd oefenen.” - Be­oor­de­ling: 8.7

Abrar Hussain, Haags Werk Bedrijf - Excel Vervolg

"No pressure that you have to be at the same pace as fellow students who might be faster, think of classroom training. If necessary, the help of a trainer is present and he will come as soon as you ask for it". - Rating: 8.0

Marjan Lof, Yarden Funeral Insurances N.V. - Excel Turning tables, formulas and functions

S. of Tournai - Excel 2010

“'In het webinar draaitabellen wordt goed en duidelijk uitgelegd wat je met draaitabellen kunt doen. Als je nog nooit een draaitabel gemaakt hebt, dan heb je veel aan deze webinar. Het is ook fijn dat je rechtstreeks vragen kunt stellen, die vervolgens meteen behandeld worden.'” - Be­oor­de­ling: 9.0

N. Albers, Multisol Raambekleding - Gratis webinar Draaitabellen in Excel 2010 en 2013

"Nice training, lots of learning and everything at your own pace." - Rating: 10.0

W. Weaver, Scania Production Meppel B.V. - Excel Continued

"It's nice to be able to work at your own pace and ask specific questions when you get stuck." - Assessment: 7.4

P. Raven, Municipality of Almere - Excel 2003 Continued

"The training is clear and easy for any level to follow." - Rating: 9.0

Saskia Benit, Waste Energy Company - Excel Basic

"A clear training that's very easy to follow. Highly recommended for anyone working in sales." - Rating: 8.0

Tim Lam, Coty Prestige - Excel 2002 Basic

"A must for anyone who wants to master the basics of Excel. Excellent teaching material which can be used at home and at work as a reference work. Because of the clear and well constructed lesson material, this is an excellent self-study". - Assessment: 9.4

A. Vermeulen, DMN Machinefabriek Noordwijkerhout BV - Excel Basic

"The teaching method is very pleasant. You can discuss the problems you encounter at work extensively during the course and come to a solution with the teacher. Learnit informed me quickly and well about the course. I am very satisfied. I have also recommended you to my colleagues, some of whom are also going to take a course". - Rating: 9.0

G.Wolf, Thalens Nederland B.V. - Excel Continued

"It was an instructive course and you could learn everything at your own pace." - Review: 7.9

J. Beards, Spithorst - Excel Basic

"Very professional trainer, good teaching material, good clear assignments and cases which challenge you and motivate you to come to the solutions. Room for questions from your own organisation! Super fun instructive training, therefore difficulty to stop at the end of the training days! Thank you!"

- Excel Basic / Expert

"The course is very clear, you work at your own pace and are immediately given guidance in case of questions. I think it's very accessible for everyone, even people with an exam fear because it doesn't indicate how much substance you should have treated. Of course you are supposed to go through as much leather as possible but the pressure isn't there while you're taking all the material". - Assessment: 9.1

V. Edens, Gasunie - Excel Basic

"Excel is generally < 20% in mogelijkheden gebruikt hetgeen het kan gezien de kosten van het pakket is het aan te bevelen wat de 100% mogelijkheden zijn.” - Be­oor­de­ling:  7.1

"I learned the many possibilities and applications during the 2-day training, so that working with Excel has become much more attractive". - Review: 7.9

T. Chain, The Royal Bank of Scotland N.V. - Excel 2003 Continued

Paul Sangen, Unica Installation Group B.V. - Excel 2010

"A simple basic Excel course that you can master in a short time with Excel by means of personal guidance and a course folder. This tool will have to serve to make you more and more proficient with Excel in the future". - Assessment: 7.4

H. Berkelder, CTH - Excel 2003 Basic

- Excel Continued

"Good training to broaden excel's knowledge and expertise, and opportunities for good reflection of applicability in the workplace." - Rating: 7.8

S. van de Ven, Royal Peijnenburg B.V. - Excel PowerPivot

"Learnit hooked us up with the right trainer. Our training need was not standard training and this was well understood by Nick. Everyone we spoke to from Learnit was pleasant. We're very happy with your professionalism and flexibility". - Assessment: 9.4

L. van Eekelen, VU Amsterdam - Excel Revolving tables, formulas and functions

"The Excel 2007 follow-up course is well set up; interesting topics and applications that can be used immediately at work after practice". - Assessment: 8.1

M. Benschop - Excel Continued

"A good addition to an Excel user's knowledge, even if you've been using it on your PC for years. There are many more possibilities, which are well indicated by the instructor." - Rating: 8.0

C. J. van Veldhuizen - Excel 2010

"Nice training in which everything is clearly explained, but in which you also have to think for yourself. Everyone can work at their own pace." - Rating: 8.5

K. Villalba Weber - Excel 2003 Basic

"The Excel 2007 follow-up course is well set up; interesting topics and applications that can be used immediately at work after practice". - Assessment: 8.1

M. Benschop - Excel Continued

"A good course to regain and increase knowledge on valuable Excel skills to make worklife easier and faster." - Rating: 8.0

Bart Verdoorn, Marchon - Excel Expert