How many add-on are missing from MAC excel (s&p IQ ect...)

So im majoring in finance and I need to buy a new laptop. My previous laptop was a Lenovo X1 Carbon. Im conflicted on weather to buy the new MBP M1 or the new X1 Carbon 9th gen. I have only used Mac occasionally but I have heard excel isn't the best on it but, there have been announcements that Office has now been optimized for Mac. Additionally I have heard that S&P IQ isn't available on Mac Excel and that the Bloomberg Terminal doesn't work as well on Mac (my school offers remote access to the thermal). Im looking to do a fair amount of model building. In short which one do you guys recommend and which should I buy. Thank you.