Sorry, with all due respect you are the first person who has ever claimed that Office doesn't work on a Mac. In fact, Office on Mac is notorious for being BETTER than on Windows, even Microsoft employees say so themselves.
Excel doesn't even have Power Query!