macOS limitations. time for Windows?

Been holding up posting here for a while until I felt I needed a common knowledge and expertise.

I have been refining my Excel knowledge for the last couple of months, running Excel on macOS.

As I've gotten into more "advanced" features/topics of Excel, it seems like I run into issues, just a couple of examples:

• FlashFill - has its own life
• Power Query - missing, from table/range
• Shortcuts - quirky
• etc.

I wonder at what point I should make the switch and how far I can get on macOS.

Wonder what you guys think or have done yourself?