10 Functions that Help you Crunch Text Strings in Excel

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

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?

6 Major Differences between Excel 2016 for Windows and Excel 2016 for MAC

1.Excel for MAC does not support PowerPivot.¬†Consequently, any pivot table based on the Excel Data Model will be unfilterable if the spreadsheet is opened by a MAC user. So will be any pivot table, that was created via the "Import from Microsoft Access Database" option as¬†Excel for MAC does not support OLEDB connections, either. It … Continue reading 6 Major Differences between Excel 2016 for Windows and Excel 2016 for MAC