Google Sheets Beginners: Data Validation (34)

The ability to create drop-down menus and restrictions in your Google Sheet, can streamline your work and stop mistakes. In this tutorial, we will dive into the basics of data validation in Google Sheets.

In this tutorial, I'll cover,

00:00 Intro 00:17 Accessing the data validation menu 00:41 What does each part do? 01:12 What can I choose to use data validation for? 02:10 Criteria - List from a range in your Google Sheet. 04:49 Criteria - List of items not in your Google Sheet. 05:18 Criteria - Having to choose a Date. 06:29 Criteria - Choosing numbers between a range. 08:14 Removing Data Validation

While understanding the basics of Data Validation is quite simple, it can also be beneficial to go more in-depth with Data Validation. Click on the link below to find the Data Validation Series:

https://youtube.com/playlist?list=PLSDEbLgMgqvoVQA73Erj_Gky2K11v-CHh

Here is a link to the accompanying post The Monster Guide to Data Validation in Google Sheets, it has more explanations and links to resources for you! https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=DMDg5CnGF8Q