Question: how to make calculations in excel faster?
Answer: Try using “faster formulas” Not all formulas are created equal, and some of them simply run slower than the others. ... 
Avoid volatile formulas. ... 
Avoid large ranges. ... 
Replace formulas with values. ... 
Avoid conditional formatting. ... 
Decrease the number of worksheets. ... 
Use multi-threaded calculation. ... 
Use 64bit version of Excel.