Link to my Excel file: https://github.com/alexsington/Data-Sets/blob/main/Data%20Validation%20Tutorial.xlsx
More Excel tutorials: https://www.youtube.com/watch?v=1WzT6B-1a0M&list=PL--VcdVemBcVQaErCLBJBdzPqdeIfhsyg
Python data analysis tutorials: https://www.youtube.com/watch?v=bfyKi44eix4&list=PL--VcdVemBcUsfTAYWTqqqkLi_ZsBJrLi
This video teaches the basics of the data validation dropdown list, which is an extremely useful tool for creating dynamic dashboards in Microsoft Excel. While dropdown are simple to implement, they must be created correctly -- using data from tables and dynamic array inputs. These simple additions to your dropdown list will future-proof your work -- meaning that your report will update automatically with new data without any work on your part.
