You should know basic programming upon exiting high school. Yeah, the sad state of K-12 curricula are something to lament another time.
So, what tool do you use to diff your spreadsheets? How do you ensure that there isn't a bug in a column of otherwise "identical" formulas? How do you ensure that whatever column you've filled with imported data still has this imported data in it? Where's your log that shows that you haven't unlocked some cells by mistake and messed them up "subtly"?
Spreadsheets provide a semblance of productivity and an illusion of efficiency. Once you go from fucking about with it to being serious, spreadsheets are a gift from hell. It takes very little to audit a couple pages of code. Good luck auditing a spreadsheet that has tens of thousands of cells filled with formulas.
Once you use spreadsheets in an auditable and professional way, you end up with a VBA script that starts with a blank slate and does everything you'd otherwise do by hand. At that point you may as well write it in Python and generate the xlsx, ods or maybe just pdf for printing/visualization.
Most people, evidently yourself included, use spreadsheets like if they were a magical object that's guaranteed to read your mind and do exactly what you want. It's all too easy to fuck up if you're not careful, and unfortunately Excel by default doesn't come with policies that prevent you from fucking up. How one earth can anyone be sure that your projections aren't just line noise? Excel promotes development with no process, where there's no assurance about anything. That's one little reason why our financial industry is so fucked up. People trust Excel results, no questions asked.