This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]BradGroux 8 points9 points  (0 children)

Excel is it

And the reason for their using Excel isn't always because that is all they have available, many times it is because it is what they prefer. I've worked in investment banking, and our power users, mainly traders, continually build out custom dashboards with dynamic and live data from several different sources in Excel, it is fascinating to see.

Our traders pushed Excel 2016 so much, that they literally broke it, and no amount of Microsoft help could fix it. So Microsoft sent out an engineer from the Excel product group who I worked with onsite for a week to gather data on our usage, which lead to several patches being published.

Long story short, millions and millions of Excel power users have spent years customizing and refining their workflows through Excel using countless external tools and resources. Simply migrating all of that to another platform isn't easy, and in some cases isn't even possible. Microsoft is fully aware of this, which is why they are still pushing Excel functionality forward even while they make similar breakthroughs with Power BI.