Excel – Introduction to Data Validation techniques

Understanding how Data Validation can be applied and then used to control what values can be entered into a cell.

Prerequisites
A good working knowledge of Excel.

Course outline

• Demonstrating Data Validation controls
• Understanding the Data Validation dialog box
• Modifying existing Data Validation controls
• Creating Data Validation from scratch
• Working with lists

The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.