Writing Excel formulas efficiently

Writing Excel formulas efficiently

31 May 2014

One of the repeating problems I've noticed recently are formulas that are not written efficiently. Efficiency means writing formulas that are quick to write, easy to update, and intuitive.

This article describes some techniques for writing efficient formulas, including:

  • Absolute vs Relative references.
  • Named ranges.
  • Excel tables.
  • Column number and row number arguments.