Excel 2016 course Validation of data

CURS-70

In this course you will learn how to perform data validation with Excel 2016. Learn to work in Excel with efficiency and reliability

Description


Information from: Excel 2016: Data validation
In this course you will learn how to perform data validation with Excel 2016. Learn to work in Excel with efficiency and reliability


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.

Data validation to avoid errors in Excel 2016
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


Data validation as drop-down lists in Excel 2016
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


More complementary options to data validation
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

Technical data:

Format: .MP4
Resolution: 1280x720p
Size: 186 MB
Spanish Language
Formators: José Manuel Pomares
Content: 20 Videos
Duration: 1:18 hours
Software: Office, Office 2016, Excel, Excel 2016
Base Files: Yes Includes


See Intro


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.

Download area



Contraseña/Password: www.intarcesoft.com.ve

Base File


Author's Website


Pagina Principal

If you like or help this article. Support the developers by buying this material.

Follow us on our social networks


  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.

OS Windows XP o superior
RAM 256 MB
License Freeware
Language Only Spanish
File Size 186 MB
Developer Video2Brain
Grade 
03/28/2017

Excelente

Muy bueno el curso lo recomendamos

Write your review!

Write a review

Excel 2016 course Validation of data

Excel 2016 course Validation of data

In this course you will learn how to perform data validation with Excel 2016. Learn to work in Excel with efficiency and reliability

Ask a question

NO registration required!

If the question you have has not yet been answered here, use the form below to ask something about this addon.

(optional)
*(Required to be notified when an answer is available)

If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form

RelatedProducts