Excel Data Validation Controls : Sinhala ▶ Excel Basics - Episode 04(Sinhalen)

⬇ Download Workfile from here: https://drive.google.com/open?id=1e1O... The tutorial explains how to do Data Validation in Excel: create a validation rule for numbers, dates or text values, make data validation lists, copy data validation to other cells, find invalid entries, fix and remove data validation. When setting up a workbook for your users, you may often want to control information input into specific cells to make sure all data entries are accurate and consistent. Among other things, you may want to allow only particular data type such as numbers or dates in a cell, or limit numbers to a certain range and text to a given length. You may even want to provide a predefined list of acceptable entries to eliminate possible mistakes. Excel Data Validation allows you to do all these things in all versions of Microsoft Excel 2016, 20013, 2010 and lower. What is data validation in Excel? How to add data validation in Excel Excel data validation examples Whole numbers and decimals Date and time validation Text length Excel data validation list (drop-down) Custom data validation rules How to edit Excel validation rules How to copy Excel validation rule to other cells How to find data validation in Excel How to remove data validation in Excel How to use data validation in Excel - tips & tricks Excel Data Validation not working Learn Microsoft Excel and Microsoft Power BI in Sinhala with this group. We will be teaching Excel from Basic to Advance in a very simple form. excel tutorial excel vlookup excel dashboard excel formulas and functions excel shortcut keys excel basic for beginners excel tricks power BI tutorials for beginners power bi tutorial power bi dashboard power bi tutorial advance power bi dax power query Also you can connect with me on Below Channels. FaceBook : https://www.facebook.com/Excel-and-Po... LinkedIn :   / kasun-manchanayake-fmva™-cba-mos-4756a532   Web : www.dubaipowerbi.com We will be covering these areas from our excel and Power BI tutorials series. My Online Courses 1. The Beginner's Guide to Excel - Excel Basics Tutorial 2. Advanced Excel Formulas and Functions (8 Hours) 3. Analyzing Data with Excel Power Query, Power Pivot and DAX (20 Hours) 4. Excel Data Visualization in Depth (5 Hours) 5. Excel PivotTables in Depth (5 Hours) 6. Analyzing and Visualizing Data with Microsoft Power BI (20 Hours) 7. Excel Master Class 8. Excel Dashbaords Course 8. Financial Reporting with Power BI 9. HR Analytics with Power BI Text Functions Logical Functions Information Functions Date and Time Functions Lookup and Reference Functions Math and Trig Functions Statistical Functions Database Functions Financial Functions Engineering Functions Cube Functions Web Functions Excel Dashboards INDEX + MATCH CONDITIONAL FORMATTING CONCATENATE VLOOKUP SUMIF, COUNTIF, AVERAGEIF IF STATEMENTS HLOOKUP XLOOKUP SUM, COUNT, AVERAGE PIVOT CHARTS DATA VALIDATION CONDITIONAL FORMATTING VBA MACRO DASHBOARDS DROPDOWNLIST #exceltutorialsinhalen #excelvlookup #exceldashboard