How to use Data Validation in Excel full tutorial in Malayalam

🔥How to use Data Validation in Excel full tutorial in Malayalam🔥 Data Validation is a feature that allows you to control the type of data entered into your worksheet. It allows you to limit data entries to a selection from a drop down list and to restrict some data entries, such as dates or numbers outside of a predetermined range. Data Validation tools in Excel will help you to improve the accuracy of the data in your worksheet. In this video you'll also learn how to create Excel Drop down list, so the person who entering data can simply click a button and choose from a list of possible entries. In addition, in this video you'll learn how to edit data validation criteria, how to find invalid data, how to create input message and error alert, how to delete or clear data validation, how to see the cells which is done data validation, how to copy paste data validation etc. 🔔Please SUBSCRIBE this channel https://www.youtube.com/channel/UCaYPrGRd_VqHXFD9HIbu6ZQ Recent videos 📺 How to use DAVERAGE and DCOUNT Function? https://youtu.be/qJV8tWHlego How to calculate sum using DSum Function? https://youtu.be/5reFednJHlE How to create column chart in Excel? https://youtu.be/tKz-HqGJVuM How to create Pivot table in Excel? https://youtu.be/JP29TAwKiKU How to use SmartArt Graphic in Excel? https://youtu.be/u49Jn5FiafE How to insert Images, shapes, Icons and 3D Models in excel? https://youtu.be/9Eat9GI3poI How to apply Conditional Formatting in Excel? https://youtu.be/6Kpjg2yNco4 How to add cell styles in Excel? https://youtu.be/3rxAOjao6HY How to use Format Painter in Excel? https://youtu.be/WNIgH2DtCgg Entering Dates in Excel https://youtu.be/uOrRojSn2gM ⏰Timestamps: 00:00 Introduction 00:22 What is Data Validation? 01:06 How to create Data Validation? 02:14 Whole number Data Validation 03:59 Shortcut key for Data Validation 04:27 Date Data Validation 05:38 Text length Data Validation 07:23 Data Validation Drop down list 08:28 How to create Input message? 09:54 How to create Error Alert? 10:21 Stop Error Alert 11:32 Warning Error Alert 12:56 Information Error Alert 14:01 How to see Invalid data in Data Validation(Circle Invalid data) 14:36 How to remove the circle of Invalid data(Clear validation circles) 14:45 How to delete or clear Data Validation? 15:46 How to see the cells which is done Data Validation 16:16 How to Edit Data Validation criteria 18:26 How to copy paste Data Validation? 19:55 Shortcut key for Paste special #datavalidation #dropdownlist #dropdown #easy #excel #exceltutorial #malayalam #malayalamtutorial #tutorial #edit #easyexcel #inputmessage #error #erroralert #copypaste #youtube #youtubetutorial #msexcel