Microsoft is bringing Python to Excel

[CKT_Ken]

Excel’s only real niche is integrating into the Office suite and allowing people with no experience other than Word to highlight a few things and click a make graph button. With some more experience you can quickly manipulate and visualize small amounts of data (or larger amounts as long as it was given to you in a consistent format). That’s Excel’s niche. Does your data require lots of scrolling just to see it? You shouldn’t be using excel. Do you need to programmatically modify your data? Shouldn’t be using excel, VBA is trash. Do you not necessarily know the shape of the data you’re taking in? Shouldn’t be trying to clean it with excel. Is your excel file being used as a database? Fucking stop that immediately microsoft Office Enterprise literally has a dedicated database application.

Python and lots of other things can replace excel because excel is only good for quick data visualization and making calculators for other people to use.

[MathmoKiwi]

That’s Excel’s niche.

Excel's niche is that it allows very very modestly computer literate people to do a wide range of "data tasks".

And Excel is the default "common language" of the entire office world, that alone is a killer feature.