It has often been the case in the course of my assignments that I've had to do quite some data prep in Excel before I could have a clean dataset to crunch. If you also need to do this in Excel, below are 10 functions that I have found indispensable. The datasets I'm going to … Continue reading 10 Functions that Help you Crunch Text Strings in Excel
Anyone survived a statistics course at uni without running a linear regression in SPSS? Come forward, please Joke aside, linear regression is such a basic and fundamental forecasting tool that it is being taught across a range of bachelor and master programmes. Yet, all too often, very little is explained how you could use it … Continue reading Can I run a linear regression in Excel?
When I was working as a Reporting Analyst, I was responsible for generating the monthly EMEA Delivery Management scorecards, whose results would get discussed in a day-long meetings between all senior management members One of the major issues with these scorecards when I inherited them was that there was no consistent way of regularly feeding … Continue reading How Can I Quickly Zap the Formulas in a cell range?