I use both Office for Mac and Windows all the time and Office for Mac is pretty reliable IMO. They pretty much have feature parity. Which features are you missing?
Have you tried using PowerQuery for instance? It's only one of the things available in Windows only. Same if you try to work with the Data Model. (I'm not sure for Macros & VBAs but can guess they are also mostly not functional)
Again, not very common for the 99%, but if you are an Excel power user you should know about those, especially about PQ.
I believe that is a good thing. I used to work at Microsoft and many of their own employees hate Access and wish Microsoft would have replaced it with Foxpro when they bought that back in the 90s.