3 ms·
I don't think you can improve Excel too much, but you could the ecosystem around it: Microsoft should integrate a package manager. Not something public, but som
by Devasta 5y ago
I don't think you can improve Excel too much, but you could the ecosystem around it: Microsoft should integrate a package manager. Not something public, but something companies can privately maintain and publish packages to, that would contain common functions for their specific business.
If I could have a way to download a macro to a spreadsheet that would automate database connection for certain data sets, that would be huge, and since it'd be centralized corps could even have critical sheets functions managed by version control.
Mission critical excel spreadsheets run huge sections of large corps, we can discourage it or provide tools to better manage it.
- willhslade 5y agoYou should be able to do this with Git, Git-XL and a function to Export / Import BAS files from within Excel
- magicalhippo 5y ago> I don't think you can improve Excel too much Clearly you've not used an international version of Excel. They translate all the function names, replacing the English ones, and of course not just for display. No, this gets saved in the file. So in my view, they could improve Excel an immense amount just there. Then we can talk about how it won't even obey things like an explicit "format this cell as text" command.
- baq 5y agojust today found out you can't create a histogram out of a pivot table. what. i mean, i wasn't even mad. i just sat there, stared at the thing and had a suddenly empty mind slowly filling with wtfs.
- yayr 5y agothere is a reason, why tools like Tableau and Power BI exist. Excel fails at building stable solutions for presenting or modeling data. Actually, it also fails at stably and effectively preparing and transforming data for more complex scenarios. It is great for freestyle. But people want to use it for more...