Excel: Data Validation in Depth

Focused View

Robin Hunt

2:01:14

198 View

01 - Introduction

01 - Understanding different validation methods.mp4

00:48

02 - 1. Types of Data Validation Commands for Data Entry

01 - Controlling data through data validation commands.mp4

05:01

02 - Using the Input tab.mp4

03:20

03 - Creating error alerts.mp4

03:42

04 - Controlling cells to only hold whole numbers.mp4

05:20

05 - Controlling cells to only certain text length.mp4

03:42

06 - Challenge Apply data validation and messages.mp4

00:31

07 - Solution Apply data validation and messages.mp4

01:50

03 - 2. Implementing Data Validation for Specific Cells

01 - Creating drop-down lists.mp4

03:53

02 - Naming data in Excel for validation.mp4

05:05

03 - Multitiered lists.mp4

05:10

04 - Changing lists and limitations.mp4

06:06

05 - Challenge Create lists and drop-downs.mp4

00:22

06 - Solution Create lists and drop-downs.mp4

02:06

04 - 3. Creating Valid Data for Lists and Calculations

01 - Drop-downs and VLOOKUPs.mp4

06:26

02 - Drop-downs and XLOOKUPs.mp4

04:25

03 - Using IFERROR for clean values.mp4

04:54

04 - Using 3D references to reduce manual calculation.mp4

06:58

05 - Leverage custom functions for data validation.mp4

06:41

06 - Challenge 3D reference challenge.mp4

00:22

07 - Solution 3D reference challenge.mp4

02:47

05 - 4. Validating Dates and Times

01 - Validating dates with data validation.mp4

03:05

02 - Validating times with data validation.mp4

05:52

06 - 5. Other Data Validation Techniques

01 - Requiring entries to be unique.mp4

04:39

02 - Find data validation in a workbook.mp4

01:53

03 - Formula auditing to validate data.mp4

03:35

04 - Removing data validation.mp4

02:29

07 - 6. Data Validation Techniques for Data in Power Query

01 - Creating data sets from your validated data.mp4

04:43

02 - Dealing with duplicated data.mp4

02:42

03 - Dealing with bad data and types.mp4

05:14

04 - Using data validation to find invalid data..mp4

03:07

05 - Using Column profile and quality to confirm values.mp4

03:48

08 - 7. Continuing Your Excel Data Validation Learning Journey

01 - Next steps and additional resources.mp4

00:38

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Excel

Robin Hunt

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.