It's functional, as far as the Mac version is concerned. But, MS has been pretty slow at making the Office suite fully feature compatible with the Windows version. Heck, it doesn't, and has never included a Mac version of Access.
But, after looking around a bit, it seems the latest Windows/Mac versions are nearly identical. Still, it's not easy to find sites that will attempt to compare feature compatibility, and not just talk about simple things like Ctrl+V vs. Command+V.
https://answers.microsoft.com/en-us/msoffice/forum/all/windows-to-mac-compatibility/84d8ae72-5776-4e2b-8345-a3506889b3ca