Speeding up your Excel worksheets

Having complex formulas and repetitive cell references usually slows down the performance speed of your Excel application especially if the amount of calculations are huge. To make things fast and simple, the following tips could come of great help:

  • Start by reducing the number of cell references in every formula to the bare minimum unless it is unavoidable
  • Sorting the data before performing look ups and using the most efficient function will help reduce runtime. Preferably use user defined functions instead of arrays
  • Avoid using volatile functions, Excel usually recalculates with each function even if their is nothing to be recalculated.
  • Use more rows and columns to store immediate values. Avoid using complex formulas and arrays.
Share

SNETTSCOM is an IT company. We excel at providing solutions in systems integration, consultancy, outsourcing, applications development, networking and security. Aside from this, SNETTSCOM also specializes in creative design and marketing.