But the excel-boundedness is exactly my point. Several sheets are so large they have been split into three files, referencing each other or external sources via power query. I'm not even saying it's good like it is, but it's just the status quo. I don't see any viable way to turn away from Excel in the short term, which is why I seek solutions.
And knowing where which function or button is in Excel IS knowing Excel, and programming formulas, VB macros and power queries is knowing Excel too. It has been a cornerstone in this company for the past 20 years. These people aren't IT people, Their core skills and how they bring value to the company lie somewhere else, and that's perfectly fine too. but I cannot expect them to just change the software they're been relying on for years just because I say so.
But the excel-boundedness is exactly my point. Several sheets are so large they have been split into three files, referencing each other or external sources via power query. I'm not even saying it's good like it is, but it's just the status quo. I don't see any viable way to turn away from Excel in the short term, which is why I seek solutions.
And knowing where which function or button is in Excel IS knowing Excel, and programming formulas, VB macros and power queries is knowing Excel too. It has been a cornerstone in this company for the past 20 years. These people aren't IT people, Their core skills and how they bring value to the company lie somewhere else, and that's perfectly fine too. but I cannot expect them to just change the software they're been relying on for years just because I say so.