Has google sheets filled out the lambda helper functions yet? If so that could narrow the gap.
Passing around vba based xlsm is really awful, so if google sheets has lambdas they can probably get a lead with google sheets queey language over filter.
Groupby and pivotby are the new excel alternative, but if they filled out lambdas, then does that keave VBA and power query as the only reasons for Excel?