filmov
tv
Excel - Data Validation with the INDIRECT Function - Excel Advanced
Показать описание
Data Validation is a great way to make certain only certain information gets entered into Excel. For example, you don't want a department column and someone typing Human Resources and later typing HR. Same for Countries. USA and U.S. are the same country, but with data analysis, they are different. You can do Data Validation with numbers and text. In this example, we are using a validation list. A drop-down arrow appears, and only the items listed can be selected. We will use the Indirect function with a table. The Indirect function allows records added to the table to be included in the drop-down list.
Chapters/Bookmarks
0:00 Intro
0:12 Data Validation explained
0:37 Remove Duplicates
1:08 Create a Table
1:40 Data Validation on a Table
3:00 INDIRECT Function with Table
#chrismenardtraining #exceltraining #chrismenard
Title Watch Url
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
-- SOFTWARE USED ---------------------------------
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Chapters/Bookmarks
0:00 Intro
0:12 Data Validation explained
0:37 Remove Duplicates
1:08 Create a Table
1:40 Data Validation on a Table
3:00 INDIRECT Function with Table
#chrismenardtraining #exceltraining #chrismenard
Title Watch Url
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
-- SOFTWARE USED ---------------------------------
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
0:13:08
Advanced Excel - Data Validation and Drop-Down Lists
0:01:15
How to apply data validation to cells in Microsoft Excel
0:05:16
Excel - Data Validation with the INDIRECT Function - Excel Advanced
0:15:42
Create SMART Drop Down Lists in Excel (with Data Validation)
0:11:02
MS Excel - Data Validation
0:03:50
Excel Create Dependent Drop Down List Tutorial
0:14:16
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
0:11:57
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)
0:07:40
How to create Dependent Dropdown list in Excel? | Single & Multilevel list with INDIRECT() | CTA
0:03:58
Get 'ALL' Option in Excel Data Validation with this Crazy Trick 💡
0:07:20
Easy Dynamic Dependent Data Validation Two Ways
0:00:20
How to add Dropdown list in Excel? ( In 20 Seconds) | Data Validation trick #shorts #excel
0:01:00
Data Validation Drop Down List - Excel Tips - #youtubeshorts
0:08:37
Excel Drop Down List Tutorial
0:27:56
Data Validation In Excel | Excel Data Validation Tutorial | Excel For Beginners | Simplilearn
0:11:10
Dependent Drop Down List in Excel Tutorial
0:03:17
What is Data Validation | Excel
0:09:02
Data validation without duplicates - Excel Tricks
0:02:49
Quick Excel Tip: Edit Data Validation Rule for All Same Cells
0:30:43
Complete Data Validation in Excel Every Excel user must know this.
0:11:42
Quickly Create Multiple Dependent Drop-Down Lists in Microsoft Excel
0:00:57
Excel Data Validation || Excel Tips || Data Validation || How To
0:09:18
Data Validation | Data Validation in Excel | Excel Tutorial Part 16
0:31:06
Data Validation in Excel | Drop-down lists | FREE Excel Course
Комментарии