+233 54 123 9290
support@festman.io
Select a Language
.png)
.png)
Microsoft Excel: Data Validation
Microsoft Excel: Data Validation
(3)
382
Students
11
Lectures
Thomas Festus Cudjoe
Instructor
What Will You Learn?
About This Course
With Excel's data validation tools, you can control how users enter data into workbooks, ensuring that data is consistent and accurate. You can control dates, times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes.
In this course, we will explore how the data validation tools in Excel can be used to set dropdown lists and control numeric, text, date, and avoid duplicate entries.
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence.
He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics.
At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.
Recent Reviews
See what students are saying about the course.
More Reviews
Abdul- Rahman Amadu
11 Jan 2024
Esther Adebola Ayanfe
18 Aug 2023
Mutaru Musah
3 Oct 2023
Curriculum Overview
This course includes 1 modules, 11 lessons, and 0:01 hours of materials.
Data validation
11 Parts | 0:01 Hours
Download sample practice file
Download sample practice file and follow along with the videos
Study Duration
1 Minutes
Attachments
0
Course Introduction
Volume
15.92 MB
Creating drop down list
Volume
22.20 MB
Creating expandable drop down list
Volume
20.95 MB
Decimal number controls
Volume
12.97 MB
Whole numbers control
Volume
16.61 MB
Date restrictions
Volume
19.47 MB
Text restrictions
Volume
18.64 MB
Custom option: Using formula to prevent duplicate entries
Free
Volume
16.86 MB
Error alerts and input message
Volume
17.20 MB
Course conclusion
Volume
5.02 MB
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type
Course Certificate
4.75
3 Reviews
Content Quality (4.7)
Instructor Skills (4.7)
Value for Money (4.7)
Support Quality (5)
Abdul- Rahman Amadu
11 Jan 2024 08:49 am
Mutaru Musah
3 Oct 2023 12:58 am
Esther Adebola Ayanfe
18 Aug 2023 09:50 pm
Course Specifications
Sections
1
Lessons
11
Capacity
Unlimited
Duration
0:40 Hours
Students
382
Created Date
12 Apr 2023
Updated Date
13 Dec 2025
.png)
.png)
Send Course as Gift
Send as a gift to friends
You are viewing
Microsoft Excel: Data Validation
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Contact Us
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
.png)
.png)
Reply to Comment