Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.
Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.
Invest in stocks if you can research and continuously monitor them; otherwise, consider index funds or robo-advisors. Only use money for stock investment that you won't need for at least five years ...