Рет қаралды 61,557
How to Make Drop Down List/Menu Using Data Validation in Excel Bangla.
Here i will show you how to make drop down data validation list or menu in excel bangla tutorial.
This is the first part of Data Validation bangla tutorial. I will deliver 20+ tutorial here.
Data validation is a feature available in Microsoft Excel. It allows you to do the following:
a. Make a list of the entries that restricts the values allowed in a cell.
b. Create a prompt message explaining the kind of data allowed in a cell.
c. Create messages that appear when incorrect data has been entered.
d. Check for incorrect entries by using the Auditing toolbar.
e. Set a range of numeric values that can be entered in a cell.
f. Determine if an entry is valid based on calculation in another cell.
In Excel, the data validation feature helps you control what can be entered in your worksheet.
Data validation means checking the accuracy and quality of source data before using, importing or otherwise processing data. Different types of validation can be performed depending on destination constraints or objectives. Data validation is a form of data cleansing.
I think you have enjoyed this video.
If this tutorial really helps you, please #like, #comment, #subscribe and #share with your close friends.
............................................................................
..............Subscribe to Get More Videos...........
www.youtube.co...
............................................................................
Project File : goo.gl/iHNT76
..................................................................................................
Most Favorite Videos
MS Excel Bangla Tutorial Playlist :
Microsoft Excel Super Tips & Tricks: Must Know: goo.gl/5qSphJ
IF Function in MS Excel Bangla: goo.gl/jY76m4
Microsoft Excel Essential Course for Beginners: goo.gl/7EX1hk
Microsoft Excel Intermediate Course: goo.gl/iatnNz
Microsoft Excel Advanced Course: goo.gl/WFrvzU
Microsoft Excel Formulas & Functions: goo.gl/7Da7oZ
Microsoft Excel Pivot Table Magic: goo.gl/NGp13W
Microsoft Word Essential Course: goo.gl/SVXefG
..................................................................................................
.................Social Media.................
Twitter : / cumamun
Google+ : plus.google.co...
LinkenIn : / abdulla-al-mamun-172629b4
Instagram: / al-mamun36
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► bit.ly/OffTMDes...
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks. .
.................................................................................................
.................Social Media.................
Facebook Page : / mamunacademy4u
Facebook Group : / mamunacademy
Google+ : plus.google.co...
LinkedIn : / abdulla-al-mamun-172629b4
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► bit.ly/OffTMDes...
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.