Business analytics and running
Earlier this week a friend of mine came over. He is a Key Account Manager for a large, international company and he is in the process of preparing an internal Key Account presentation. I showed him the wonders of Excel to help him save time.One of the analysis I suggested that he include, is the... Continue Reading →
I do forecast modeling and scenario planning in Excel and it is quite simple: Be clear on your assumptions — typically top left in the worksheet Document your formulas by including a comment on input (column M below) Follow these two points and you can easily update your model, or do a handover to your... Continue Reading →
In several places I have worked, I have seen the need for a simple, regular report with key figures relevant to the execution of strategy. Strategy must be measurable and you have to follow-up regularly so you can respond quickly to any red flags. Simple, relevant and regular information, in the same format from week... Continue Reading →
I took all the MS Office courses I could get my hands during my first job. Getting up to speed with advanced Excel training from the start has been quite beneficial. I could hardly believe how useful it was — once I managed to convert the knitting-pattern of a baby sized sweater, with a complicated... Continue Reading →
