How Can I validate if a user is authorized to view certain data or not?

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?

How Do I Quickly Protect/Unprotect Worksheets in My Spreadsheet?

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?