Collaboration with Sharepoint is I think the biggest issue with M365. It’s impossible to figure out where a file is stored… on your hard drive? One drive? Teams? Sharepoint?
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.
It's still better than anything else and the de-facto standard so you need it.
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.
Many of the 22-25 year old-ish people in a grad school class I was part of recently had no idea where a shared project document was or how to edit it outside of Office 365’s online editor. Many didn’t know that the “attachment” from email was actually a Sharepoint link and not a file. This becomes a problem when you need to use some features in the desktop Word program that aren’t in the online editor.
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.
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.