What version of Excel are you really using?
Knowing the precise version of Excel can save hours or days of frustration. I remember when my circle of friends were all turning 18, getting their driver’s licence and buying a car. In suburban Melbourne, no car meant no social life. After one of my close friends got her licence and brought a second-hand car, I […]
Continue readingRecording the history of a cell’s value
Here’s the situation. You’ve got a spreadsheet where you’d like to track the changes to some cell values over time. Maybe they’re stock prices, or exchange rates or input parameters to a model. Whatever. But when you change the value tomorrow, you want a record of what that value was last week.The Curse of Excel’s Track Changes FeatureThe first […]
Continue reading