Data validation is a powerful tool to prepare forms in MS Excel, LibreOffice Calc and other spreadsheet programs. We can define some cells to have allowed values only from a certain range of values defined elsewhere in the sheet. For example, to define a type of something. Then, we can have also subtypes with allowed ranges automatically assigned for the selected type.
This video is part of Riga Technical University course DIP217 "Application programming", officially released here on YouTube by its author with the encouragement of the department's head.
On this page of the site you can watch the video online Using validation in spreadsheet programs with a duration of hours minute second in good quality, which was uploaded by the user Igors Mihailovs 18 September 2019, share the link with friends and acquaintances, this video has already been watched 7 times on youtube and it was liked by 0 viewers. Enjoy your viewing!