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
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips https://www.youtube.com/watch?v=6v2aj1GE3fg
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY https://www.youtube.com/watch?v=uCmmuScmxQk
Teams Online Course Promotion https://www.youtube.com/watch?v=KJgxWOqdZHE
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total https://www.youtube.com/watch?v=KSaM8JAVnSo
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting https://www.youtube.com/watch?v=qFnHYfn6yNs
Excel - Filter a PivotTable with a Timeline https://www.youtube.com/watch?v=FIKqdUC92f4
PivotTables - 3 Annoying Things FIXED! https://www.youtube.com/watch?v=U746wZCrq6k
Excel Add Sparklines on a Separate Worksheet https://www.youtube.com/watch?v=163KG9gImPI
Excel Chart Maps used with the Geography Data Type https://www.youtube.com/watch?v=iQvapFfAoEE
Excel Concatenate Text and Dates with the TEXT function https://www.youtube.com/watch?v=hljBSRnKZp4
Tasks by Planner in Teams - Recurring Tasks - New Feature https://www.youtube.com/watch?v=byV-dsWCrU0
Excel - Insert a blank row after every row or every Nth row https://www.youtube.com/watch?v=FPu3nJBwgEc

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!