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?
Visualizing statistical results in Excel has just become easier as the latest version enables you to create "Histogram" and "Pareto" charts (+ a bunch others) 2.Power Pivot Add-In is integrated, which essentially means that: (a) you do not have to install it separately as it was the case with Excel 2013 and Excel 2010 (b) you will see … Continue reading Top 3 Handy Features of Excel 2016
Well, I didn't need to predict sales but segment sizes for the upcoming 3 periods of the Markstrat simulation game we were playing as part of the Strategic Marketing class I was taking. Still, it works pretty much the same way - you use the numerical historic data you have in order to make a prediction … Continue reading Top 3 Excel functions you can use to forecast sales
Assuming Excel is your play tool and that you need to handle data worth of 30,000 rows + in order to produce your analyses, below are some tips that could help improve and optimize your spreadsheet usage: 1. Do change the default csv connection properties! • Prompt for file on refresh: achieves nothing but render … Continue reading 10 Best Practices of Spreadsheet Management
What the heck is Excel Camera Tool? Excel's camera tool is a pretty handy button that allows you to make interactive pictures of your data! It comes especially handy when you need to copy Excel data that falls in non-adjacent ranges (since the camera tool generates an interactive picture, outline grouping can be used to … Continue reading How Do I Quickly Re-filter and Export Camera Tool Views to PowerPoint Slides?