3 ms·
> anything more complicated I'd rather do in a proper programming language. Yes you can. Most people cannot or don't want to. Programming is just a skill used
by okanat 3y ago
> anything more complicated I'd rather do in a proper programming language.
Yes you can. Most people cannot or don't want to. Programming is just a skill used to reach an end and if your job description doesn't require it, you skip it.
Excel democratizes the data analysis better than any open source alternatives and programming languages. It is easier to use and relatively less buggy than all of the open source and proprietary alternatives. When one really needs programming, VBA is there and it provides a much shallower learning curve for the curious.
From a corporate point of view MS Office has unmatched integration with Windows, Active Directory, Sharepoint, SQLServer and many other programs. A huge amount of financial, management and engineering software tightly integrates with Microsoft software to provide functionality like automatic BOM dumps to Excel and then integrating that with manufacturing, currency conversion. The developers of such software are pretty content with it, especially due to long-term backwards compatibility MS provides for their APIs for all their products.
- tracker1 3y agoWhile I do think the likes of Jupyter use will become more common in time for a lot of what Excel does, I do agree. It's far ahead of alternatives... it isn't any one feature, it's the sum of all the one feature(s) used across a given org. A lot of it is entropy and entrenched knowledge.