I think Excel Tables make a ton of sense, especially if you're using PowerQuery or other built-in data connections to populate the sheet.

But for Google sheets, I've yet to find something as flexible and maintainable as map/lambda -- especially when I'm doing things that are pretty... egregiously hacky, but better suited to gsheets than excel (I still prefer Google's realtime collaboration to Microsoft's).