Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.
Excel isn't hard, just learn the right tricks early enough.