Author : Stefanos Daskalakis

Written on Dec, 02, 2015 by in | Leave a comment

How to speed up performance of Excel Reduce Operations The number of cell references and operations has the biggest impact on workbook performance, not the number of formulas. A few smaller helper formulas are usually more efficient than one enormous formula. If possible, avoid the use of the same formula repeatedly in multiple cells by taking it out and using …

Continue Reading...
Written on Nov, 11, 2015 by in | Leave a comment

This is a second blog in a four-part series dedicated to building efficient Excel models. Here, I’ll discuss some general recommendations for building lean and mean (and small) Excel models. Although you can build large Excel models, there are several reasons not to. Large Excel models containing multitudes of tables and columns are overkill for most analysis and consume large …

Continue Reading...
Written on Nov, 03, 2015 by in | Leave a comment

Building Efficient Excel Models (part 1 of 4) Recent economic developments across the globe have added to the uncertainty that fueled the recent stock market turbulence as demonstrated by the VIX above reflecting implied volatility of traded option contracts on S&P 500 stocks. The index peaked on Monday, August 24 (otherwise known as “Black Monday” due to the global sell-off …

Continue Reading...