Excel: Data Validation in Depth/ with Robin Hunt.

Format:

Video

Author/Creator:

Hunt, Robin, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Physical Description:

1 online resource

Place of Publication:

Carpenteria, CA: linkedin.com, 2023.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Learn how to optimize Excel data validation functions and techniques to help ensure data accuracy and consistency in data sets and reports.

Data validation is a process that occurs within the way data is entered but also as it is extracted from data systems via reporting methods. As the old computer science saying goes, "garbage in/garbage out," and this course shows Excel power users how to optimize Excel data validation functions and techniques in order to help ensure data accuracy and consistency in data sets and reports. Excel's powerful functions for data validation help eliminate hassles-or worse-that can occur when data inputs are poorly regulated and produce inaccurate data outcomes. Instructor Robin Hunt covers: the types of data validation commands for data entry in Excel; implementing data validation for specific cells; leveraging functions for creating valid data for lists and calculations; validating dates and times; non-standard data validation techniques; and data validation techniques for data in Power Query.

Participant:

Presenter: Robin Hunt

Notes:

5/23/2023

Access Restriction:

Restricted for use by site license.