How to review Excel Models for errors?
I did two banking internships and then moved to big tech. I cover revenue reporting, but it's 99% SQL & Python. I have a new manager that did 5 years at a top IB, and has no clue about SQL/Python but is very strong in Excel. As a result, all of the current infrastructure needs to have an Excel version to check outputs. Senior leadership loves this (as they also don't know tech skills beyond Excel), so politically I can't push back against this. Theseswanky, and cover things like sales target setting.
My problem is that I am not that great at reviewing work in Excel. I've created or updated models now twice where she would find a few formulae that don't tie or go down all the way. This is obviously no bueno. Does anyone have a structure or approach to review new models, or updated models for errors? I need to get up to speed very rapidly.