•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do you audit your Excel models?
I am talking about the more advanced Excel models. Like 10+ sheets with multiple sources and maybe been around for a few years. How do you know if the model is doing what it should?
In my experience as a controller for almost 20 years I simply don't audit the model unless I notice that the result is wrong. But I mean... with thoussands of connections and one little mistake can have huge consequences. I feel like there should be a way to see if everything is correct.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#google sheets
#Excel models
#audit
#sheets
#multiple sources
#connections
#controller
#results
#advanced
#mistake
#model correctness
#consequences
#experience