My high school math teacher taught me one my most valued lessons, and that was simply to "show your workings" when doing any type of formula-based calculation. 

Like most people who work in events, MS Excel is one of the most important tools in my project management toolbox.  However, I am constantly frustrated by the amount of time spent deciphering formulas and auditing spreadsheets simply because there are no workings recorded.  And it's not like there is a lack of space to make a couple of comments or notes, especially considering that in each worksheet since Excel 2007;

  • There are 16,384 columns and 1,048,576 rows...
  • That makes 17,179,869,184 cells!

So if you are like me and like to save your precious time, then perhaps consider a couple of those space cells and "show your workings!".

Thanks, Mr Holland!

 

0 comment(s)