// TECH TRENDS // contain a mixture of letters, numbers and special characters and making use of password managers can help you to store this information safely.

Also, spreadsheet access should be limited to a need-to-know basis; not every employee needs full editing rights to the document. By using rolebased permissions, managers can assign view-only or comment access as needed and review the permissions on a regular basis, especially when team members make changes. With cloud-based platforms like Microsoft 365 and Google Workspace, this process can be made simple, offering greater visibility and control over shared files.

Encryption: The invisible armour protecting businesses

Encryption is also another viable security method which can be used to further protect spreadsheets. SMEs need to educate their employees on the importance of encryption as well as inform them of the practical applications of its usage, such as BitBlocker for Windows, as well as FileVault for MacOS, which can be used for files that are stored locally on computers or laptops.

Applying key management practices for cloudbased encryption software is essential. For SMES handling sensitive data, exploring specialised third-party file encryption software that offers advanced encryption algorithms and precise control over encryption settings may be worth investing in.

Maintaining the accuracy and integrity of the data stored within spreadsheets is vital for making the correct decisions. SMEs should move beyond basic rules for data and protection and start thinking about implementing more complex techniques. This includes using custom formulas and specific criteria within data settings in order to strengthen data integrity rules, which can prevent potentially malicious data entries.

By also utilising the built-in form features of spreadsheet software or integrating with form builders, such as Google Forms, can provide a controlled approach to data input, which will minimise manual errors and ensure a more

FOR SMES, DATA IS KING. IT IS THE CORE FRAMEWORK THAT DRIVES A BUSINESS, AND IF THIS INFORMATION ENDS UP IN THE WRONG HANDS, THE CONSEQUENCES WILL BE SEVERE.

Intelligent SME. tech

15