I use edge for everything gotta love getting gas cards for just surfing the web and doing a few fun little quizzed. Since they started the points on edge I have earned 150 dollars worth of free gas.
I have used Office on the Mac for probably 15 years. Mind you, given my profession, arguments can be made if I’m a “Hardcore” Office guy. But it is a tool that’s part of my trade.
Largely, I find that anything that can be done on the Windows side can be done on the Mac side. There are a small handful of specifics I should mention. If someone builds a locked down document in Word, with selected areas that can be changed by anyone you are good. But if you need to edit the locked down portion, even if you have the password to do it, the prompt doesn’t come up like it does in Windows. For this, I simply have a VM with Windows, and it’s like a very mild inconvenience. I don’t know the specifics on this last one, but VBA Macros have awkward limitations. One of which is something having to do with querying multiple databases at the same time, and filtering through rows based off very specific parameters during a join? The wife told me about that one. You can run it on a Mac supposedly, but if something goes wrong you can’t debug it. My guess is Microsoft is overly leveraging the ability to expose outside data sets into Windows based on Win32 and they never bothered to create their implementation on Mac.
Even the iPad versions of these apps are pretty good. The one major caveat is Excel allows for the editing of Pivot Tables, but not the creation. Outside of that, I’m not aware of any hang ups there.
Within a year or so, just about all of the Microsoft 365 apps will be based on the same code base and use some sort of HTML-Front End wrapper for the different implementations of this. I believe that’s how “New Outlook” works today on Mac.
Any way, always feel free to reach out to the community. In my household, the only use for a Windows device is for gaming. That’s it. I personally loathe Windows and use it as an overarchitected boot loader for Steam.
OneDrive works as you would expect. All the other apps 99% work as you’d expect (for the overwhelmingly large part of the population). If I change a file outside of a Microsoft app, Onedrive notices it, and syncs changes up. File On Demand works as you would expect (i don’t use this feature now, but have for years. I prefer Spotlight to have everything indexed so I can always do a search to find documents).
But yeah, edge cases exist. I don’t think most of the population will ever run into them. Even if they do it’s an issue that might happen like 1 time per year. It’s far better than doing something in Google Docs, downloading it as a Word doc, then trying to copy and past the text into a company based template that some how makes everything fall apart no matter what platform you are on.