Can I run a linear regression 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?

How Can I Quickly Zap the Formulas in a cell range?

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?

Top 3 Handy Features of Excel 2016

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

Top 3 Excel functions you can use to forecast sales

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

10 Best Practices of Spreadsheet Management

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

How Do I Quickly Re-filter and Export Camera Tool Views to PowerPoint Slides?

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?