Excel gurus love to tell you, "Always format your data as a table." While that's usually solid advice, it's not always the best move. In some scenarios, a simple range outperforms a table entirely.

Pivot Tables are meant to simplify (and partially automate) the ways you can organize and interpret the various data points in your spreadsheets. Think of it as a way to make either Excel or Sheets ...