Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

encryption excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Encryption in Excel

Encryption in Excel

ResolvedVersion 2003

Elaine has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Encryption in Excel

I need to send sensitive data to different sites. Which is the safest encryption within excel, I have looked in tools after save as and in advanced and their are several different types of encryption. I need something secure but easily accessible to the end user.
Thanks

RE: Encryption in Excel

Hi Elaine, thanks for your query. This is a tough one to advise one because of course the second we recommend something it will be decrypted, your data read and you'll be very annoyed with us! So a couple of things: a) nothing is bulletproof, but password protecting your data (Tools - Options - Security) satisfies most users within a company, b) if you are sending your data to different sites ask IT whether they use a VPN (Virtual Private Network) to do so and c) if you need to go further the most widespread data encryption tool is PGP (Pretty Good Privacy) which you can read about here:

http://en.wikipedia.org/wiki/Pretty_Good_Privacy

Hope this helps,

Anthony

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.