25th May is approaching fast and so is GDPR. For those of you who are not yet aware - GDPR is a EU-wide regulation on the handling of privacy data A potential implication for all data analysts is that they may have to take extra precautions as to who can access the data they provide … Continue reading How Can I validate if a user is authorized to view certain data or not?
Analysis is finished! You've got all your pivot tables in place, now all you need to do is prep your spreadsheet for your audience - i.e. people should not be able to view your calculation tabs and edit your analysis tabs 🙂 Easy, peasy! Just hide and protect! Yet, if you have a couple of … Continue reading How Do I Quickly Protect/Unprotect Worksheets in My Spreadsheet?