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 …

The DO’s of a Reporting Analyst

Amazed as I am at how much time has passed since I first wrote the article below and how much more varied experience I've been able to gather since then, I've yet to discover a case where most of these tips wouldn't prove relevant It has now been 6 months since I started studying at …

Let’s crunch this data in Excel

But how do we get it there in the first place? There are a couple of options - choosing the best one for your case will very much depend on the volume of data you need to analyse and the data infrastructure that your company provides. So far I've used: 1. Import from text (a.k.a. …