Excel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate steps.
I wasn't aware that Google has a different one. I have never used more than simple sums and differences in Google sheets. Can you give an example where Google offers better, incompatible functionality?
For example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now.
