For a small business without a dedicated IT team, simply hire a IT contractor to harden the tenant (MFA etc…), have them review every six months and be done with it and focus your resources on running your business.
How do you know that they wouldnt be more productive if they were using Windows and Office bundle all the time?
Im also a logistics consultant… try to parse a multi-million line orderlines extract in Google Sheets compared to excel.
I’m also on Mac but to be honest it’s a challenge - there are still enough industry specific tools that are windows only so I have to run a parallels VM to get by.
And the biggest problem I have is managing revisions with multiple editors. If I were talking to Microsoft about strategy, this would be the thing I’d suggest. I know it’s common to use Sharepoint for collaboration, but it’s such a Frankenstein’d system that it’s going to be a problem for everyone sooner or later.
Clients will send you their PowerPoint template and want you to use it. They will send you their complex spreadsheets riddled with VBA macros and you will need to fix them. They will invite you to a Teams site because that's where their project updates go. I just don't see how you can avoid it as a consulting company!
For things like Excel - We can say it's 'bad' but I've not seen anything do the job it does better. And besides, even if it was bad, it doesn't matter - as a consultant you need to use it because your clients probably want your workings as part of the deliverables, and if it's on Google Sheets they often won't want that.
Don’t know what to tell you.
Honestly, I’m less interested in how things work on day one. When systems are fresh or new, it’s easier to keep working. The mess always ends up happening after things have had time to accumulate cruft. Working on a collaborative manuscript in the current Microsoft shared system is normally a nightmare.
Trying to manage/accept/reject edits and revisions between different people is still difficult. That is unless you can use a source code repository like GitHub. But good luck trying to convince people to do that. Sadly, this means that emailing files around is still the easiest way to keep things straight.