How Can I Quickly Zap the Formulas in a cell range?

When I was working as a Reporting Analyst, I was responsible for generating the monthly EMEA Delivery Management scorecards, whose results would get discussed in a day-long meetings between all senior management members One of the major issues with these scorecards when I inherited them was that there was no consistent way of regularly feeding … Continue reading How Can I Quickly Zap the Formulas in a cell range?

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?