Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.

You might go on believing that writing cryptic formulas in Google Sheets is unavoidable until you try LET. Once you've written even a handful of LET formulas, free from deeply nested functions, ...

I traded the static results of Flash Fill for dynamic formulas that update automatically.