Re: Use early Microsoft formats where possible for interchange
SUMPRODUCT was a major improvement; there's no end to the fancy results you can get by abusing it. But otherwise, yes, most Office "improvements" have been garbage since 1997, the ribbon being the absolute #1.
I guess they have to make noticeable changes to the interface to convince people to pay for the new version, which does... exactly the same thing as the old version. But for more money.