Data Validation Techniques in Microsoft Excel

Focused View

Janani Ravi

24:22

0 View

1. Introducing Data Validation Techniques in Microsoft Excel.mp4

00:25

2. Demo - Text Length Validation.mp4

01:54

3. Demo - Stop, Warning, and Information Alerts.mp4

02:24

4. Demo - Custom Text Validation Using a Formula.mp4

03:27

5. Demo - Number and Date Validation.mp4

02:24

6. Demo - Data Validation for Lists.mp4

03:27

7. Demo - Dynamic Drop-downs.mp4

01:08

8. Demo - INDEX and MATCH Functions to Build Dynamic Drop-downs.mp4

03:49

9. Demo - Configuring Dynamic Drop-downs.mp4

05:24

exercise.zip

Description

In this course, you will learn how to effectively set up data validation rules for text, numeric, and date data, and configure static and dynamic drop-down lists, helping to maintain accurate and reliable employee and organizational databases.

What You'll Learn?

Accurate data entry and validation are crucial for maintaining reliable datasets and ensuring data integrity in any organization.

In this course, Data Validation Techniques in Microsoft Excel, you'll learn how to set up robust data validation rules for different data types, implement custom validation rules, configure static and dynamic drop-down lists, and implement strategies to display error messages and alerts for data.

When you’re finished with this course, you’ll have the skills of data validation needed to better understand how you can use Excel to ensure the integrity of your data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Janani Ravi

Instructor's Courses

Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing high-quality content for technical skill development. Loonycorn is working on developing an engine (patent filed) to automate animations for presentations and educational content.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.