In this course you will learn how to perform data validation with Excel 2016. Learn to work in Excel effectively and reliably reducing your error rate.
This product is no longer in stock
Discover the useful and often unknown possibilities of the Excel 2016 Data Validation tool. Your mission is to fulfill one of the premises of a spreadsheet: to avoid errors in data processing. Learn to use an amazing tool that will increase your efficiency and reduce your error rate.
The first chapter of the course is dedicated to the most basic and frequently applied forms of this fabulous tool that is Excel data validation. We leave aside, and for a more exclusive treatment, the drop-down lists.
Introduction to data validation in Excel 2016 02:21
Validation of integers in Excel 2016 05:09
Validation of decimal numbers in Excel 2016 03:40
Validation of dates in Excel 2016 03:34
Validation of hours in Excel 2016 02:01
Validate data according to the length of the text in Excel 2016 04:04
Custom data validation in Excel 2016 06:29
Delete and fill in data validations with Excel 2016 00:40
This second section of the course is exclusively dedicated to the drop-down lists. This tool, which is a great unknown in the Excel universe, has been used by all on occasion in other computer programs.
Introduction to the drop-down lists in Excel 2016 03:24
What do you have to know about expandable in Excel 2016 03:10
More knowledge about expandable in Excel 2016 04:51
Drop-down lists with fixed items in Excel 2016 01:37
Deployable with fixed data lists in Excel 2016 03:17
Deployable with lists of variable data in Excel 2016 04:54
Deployable with form controls in Excel 2016 05:49
The dependent drop-down lists in Excel 2016 07:26
Build dependent drop-down lists in Excel 2016 09:25
To finish the course, in this last section we deal with some topics that have not been seen before or that are interesting complements to the main functionalities of the Data Validation tool.
Input messages as user help in Excel 2016 02:16
Error messages in Excel 2016 03:12
Circles for pointing errors in Excel 2016 01:18
Size: 186 MB
Formators: José Manuel Pomares
Content: 20 Videos
Duration: 1:18 hours
Software: Office, Office 2016, Excel, Excel 2016
Base Files: Yes Includes
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the program, to improve the content.
NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.
NO registration required!
1 Question(s) answered
If the question you have has not yet been answered here, use the form below to ask something about this addon.