From the course: Excel: Data Validation in Depth
Join today to access over 24,800 courses taught by industry experts.
Challenge: Apply data validation and messages - Microsoft Excel Tutorial
From the course: Excel: Data Validation in Depth
Challenge: Apply data validation and messages
(upbeat music) - [Instructor] Ready for a challenge? For an upcoming project, we want to ensure that when a user fills out number and party that it will only allow a whole number up to 15 people. It needs to have an error message that states the policy only allows a party that is 15 people or less. To ensure people are aware, we want to include an input message on the header labeled number of people. Give it a try and check out the next video to see how I solved it.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
(Locked)
Controlling data through data validation commands5m 1s
-
(Locked)
Using the Input tab3m 20s
-
(Locked)
Creating error alerts3m 42s
-
(Locked)
Controlling cells to only hold whole numbers5m 20s
-
(Locked)
Controlling cells to only certain text length3m 42s
-
(Locked)
Challenge: Apply data validation and messages31s
-
(Locked)
Solution: Apply data validation and messages1m 50s
-
(Locked)
-
-
-
-
-
-