Seeing the big picture

With a big dataset, it's easy to miss the forest for the trees. Summary functions zoom out: MAX and MIN for the extremes, AVERAGE and MEDIAN for the middle, COUNTIF and SUMIF to slice by a condition.

Once you know the high-level story, you know where to dig.