For enterprise environments really nothing compares to MS. The whole suite of power apps shoots productivity through the roof. Power query, power automate, power apps, BI, etc. With Python integration I can do even more, I can automate most things and set up automations for non savvy peers.
By enterprise I just mean any business that deals with a lot of data, I work for a company with 15 people and we'd need probably 5 more if we were running on Google. 😂😂
I have the exact opposite experience, honestly, running the IT of a 120 employee company. MS is too bloated with legacy systems, while I find Google very purposeful engineered to get the job done. I very much believe it's more of a habit thing than anything else.
Would need 5 more people to run everything on MS compared to Google.
I do concede that sometimes it feels like MS began doing their stuff in the 90s, while Google began with theirs in the early 10s; some basic functionality Google haven't gotten around to yet.
I can see a company of 120 needing 5 more IT staff to effectively utilize Microsoft productivity infrastructure, but you would likely be able to either cut that employee count down to 100, or more positively, have the same 120 people handling the productivity of 150 employees, increasing your company's output and profit.
More knowledge work is required to make effective use of the entire Microsoft stack, but in the enterprise, nothing comes close for multiplying user productivity.
Heh, our company is bigger but I guess we don't use spreadsheets the way you do. At least on the dev side basic functionality is fine, and our core business runs on real databases and stuff like AWS quicksight.
Yeah most of our ERP dumps data into an Azure database, but we frequently pull queries for ad hoc reporting/analysis into Excel as well as maintained BI reports.
The real issue is a lot of our SaaS isn't fully integrated like that so we have to csv dump data that loads into other queries and we pull from that 🙃 But those csv dumps are set with automations so it's mostly hands-off, just a little janky lol.
Excel has never once shot slicers over the spreadsheet (something I have had happen on several occasions in Google Sheets). And it has issues with formatting tables in Docs - basically it takes way longer to get something that looks half as good.
Shit, I totally missed that. This is for reals a Google Workspace ad that I only modified the text of. I wouldn't have used this particular ad if I had seen that. Apologies for any implication on the people in the picture!!
Oh, it is just a pretty terrible set of tools if you need to do anything that is semi professional (build a complex spreadsheet or a presentation you can show in public, for example).
Uh what do you mean by "complex" here? That's what apps script is for. I have a spreadsheet that processes my gmail inbox using regular expressions. Try that in Excel.