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 dropdown 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 dropdown 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
Excel PivotTable Percentage of Row Totals and Five Awesome Tips • Excel PivotTable Percentage of Row ...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY • Excel Tiered Conditional Formatting w...
Teams Online Course Promotion • Teams Online Course Promotion
Excel PivotTables Percentages Grand Total, Parent Row Total, and Parent Total • Excel PivotTables Percentages Grand...
Excel Turn on Multiple Filters in a PivotTable Allow multiple filters per field Setting • Excel Turn on Multiple Filters in a...
Excel Filter a PivotTable with a Timeline • Excel Filter a PivotTable with a Ti...
PivotTables 3 Annoying Things FIXED! • PivotTables 3 Annoying Things FIXED!
Excel Add Sparklines on a Separate Worksheet • Excel Add Sparklines on a Separate Wo...
Excel Chart Maps used with the Geography Data Type • Excel Chart Maps used with the Geogra...
Excel Concatenate Text and Dates with the TEXT function • Excel Concatenate Text and Dates with...
Tasks by Planner in Teams Recurring Tasks New Feature • Tasks by Planner in Teams Recurring...
Excel Insert a blank row after every row or every Nth row • Excel Insert a blank row after ever...
And make sure you subscribe to my channel!
EQUIPMENT USED
○ My camera – https://amzn.to/3vdgF5E
○ Microphone https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights https://amzn.to/3vaxyy5
○ Dual monitor mount stand https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount https://amzn.to/3g96FGj
○ Boom Arm https://amzn.to/3g8cNi6
SOFTWARE USED
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
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!