Excel Formula Efficiency 5: Helper Cell Speed Up Calculation





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Feb 24, 2009

See how to use a Helper Cell to remove a time consuming (expensive) section of your formula to speed up calculations.

When can you use a helper cell?
1) When the section of the formula is used in a formula that you are going to copy to other cells
2) The cell references are absolute
3) The section of the formula delivers a single value (not an array of values).

Learn how to speed up slow calculating spreadsheets with formulas that calculate faster. See many methods to speed up your spreadsheet decrease the amount of time it takes for the formulas to calculate. The tricks you see are from a White Paper called Improving Performance in Excel 2007. In this video series you will see tricks for both Excel 2003 and Excel 2007. Many of the large formulas in this series involve multi-conditional multiple criteria calculations that slow down the spreadsheet (worksheet, workbook).


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...