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
Tag: Data Management
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 … Continue reading The DO’s of a Reporting Analyst
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. … Continue reading Let’s crunch this data in Excel