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.

Most Excel spreadsheets don't fail because of bad formulas—they fail because the data was never structured properly in the first place. What looks like a table is often just a formatted grid, and that ...