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.