5 Cool Tips and Tricks of Data Validation in Excel
While working on Excel Reports, there are several scenarios where we wanted to restrict entries of invalid data. Be it Text, Dates, Numbers. Data Validation in Excel is an awesome feature that helps us to avoid entries based on certain criteria. In this tutorial, I will show you 5 Cool Tips and Tricks of Data Validation in Excel. Here, I have show you the implementation of functions while creating a Data Validation criteria. These tips and tricks are applicable across all versions of Excel. Be it Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365.
00:00 Start
02:12 Avoid Blank Cell in Excel
06:09 Avoid Duplicate Entry in Excel
09:13 Avoid Weekend Dates in Excel
12:36 Avoid Space in Text in Excel
15:45 Allow only Capital Letters in Excel
📂 Download the file: https://futureinhands.com/youtube/assets/132_5_Cool_Tips_and_Tricks_of_Data_Validation_in_Excel.zip
📚 WHAT YOU WILL LEARN:
Excel Data Validation
Excel Data Validation in Hindi
Data Validation Formula in Excel
Data Validation for Dates in Excel
Data Validation for Text in Excel
Data Validation Formula in Excel
Data Validation Advanced Excel
How to use Data Validation in Excel
Advanced Excel Tutorial
Excel Tips and Tricks
🌏 Install Telegram App: https://telegram.org/apps
💡 Join our Telegram Channel: https://t.me/futureinhands
💡 Join our Telegram Group: https://t.me/futureinhandsclub
📚 Want to see more awesome content like this as soon as it is published: https://goo.gl/K99P4j
☕ If you find my videos useful and would like to support me, you can buy me a coffee – https://www.buymeacoffee.com/VivekanandaS
👮♂ ABOUT VIVEKANANDA SINHA:
An MCA Professional and a Microsoft Certified Microsoft Office Specialist, Vivekananda is working as a Chief Mentor and currently heading Future in Hands. He worked with the Top corporates like Mphasis, Motherson Group with 10+ years of industry exposure. He received several Best Trainer Awards from corporates for Microsoft Office based workshops. He facilitated 100000+ professionals from 500+ companies like Taj Group, ICAI, British Council, BSI, NIIT, IndiaMart, MetLife, Mahindra and lots more from Executive level to Sr. Management. Learners say his sessions are like magic shows.
🌐 LinkedIn Profile: https://www.linkedin.com/in/vivekananda-sinha/
🎤 GEARS, I USED TO CREATE THIS TUTORIAL
Screen Recorder: https://amzn.to/2MrJYkl
Microphone: https://amzn.to/3odwYwT
Camera: https://amzn.to/351Uc1p
🎼 MUSIC IN THIS VIDEO
Music by https://youtube.com/ikson
🌐 Lines on Village taken from https://www.shayaritracks.com/2020/11/gaon-par-shayari-apna-gaon.html
🌐 SHARE, SUPPORT, SUBSCRIBE !!!
Subscribe: https://goo.gl/K99P4j
YouTube: https://www.youtube.com/futureinhands
Twitter: https://twitter.com/MyFutureinhands
Facebook: http://www.facebook.com/futureinhands
Facebook Myself: https://www.facebook.com/vivekananda.sinha
Instagram: https://www.instagram.com/vivekanandasinha
LinkedIn: https://linkedin.com/company/future-in-hands
LinkedIn Myself: https://www.linkedin.com/in/vivekananda-sinha
Website: http://futureinhands.com
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice
