Changing calculation behavior and enabling full CPU usage can significantly reduce lag in large, formula-heavy spreadsheets.
Stop manually reformatting Excel spreadsheets. The Spill Manager add-in makes your formatting move dynamically with expanding arrays.
A little less #N/A drama goes a long way.