pctoolbox.co.uk

A couple of months ago we received our copy of Office 2010, so it must be about time we start blogging about it!  Sparklines is a new Excel feature which we’ve been impressed with. Basically they’re miniature charts that fit into a single Excel cell to allow the user to view individual trends at a glance.  A feature such as this is ideal when managing money, e.g. to assess how expenditure for different items has varied over a year.

Here’s how to create Sparklines:

1. Click on the ‘Insert’ tab and locate the ‘Sparklines’ box
   
2. Next you must select the type of Sparkline you wish to use by clicking on either Line, Column or Win/Loss
3. Finally in the ‘Create Sparklines Box’ you need to select your data range and location range
   

A neat feature I’m sure you’ll all agree

Over the next few weeks we’re doing a series on passwords!  It is always important to have a good password.  Having a strong password makes it even harder for any hacker to get into your private accounts and information, etc.

Here are some good ways to ensure you have a good quality password:

• Length – It is ideal to have a long password.  By long we mean at least 8 letters long but if possible even longer!  Generally, the longer it is the harder it is the hack.  Many systems now also allow for spaces in your password.  Therefore it may be a good idea to invent a long phrase rather than a word.
• Use the whole keyboard – It is a great idea to use letters, numbers and symbols in your password.  The greater the variety of keys the harder it is for an attacker to break into your account.  Surveys have shown that having a 15 character password using both letters and numbers is far stronger than having an 8 character password with just letters.  In fact it’s 33,000 times stronger!
• Make it memorable – It is essential that your password is really easy for you to remember!  However, it is also essential that other people, even your friends, wont be able to guess it easily!

Finally, check out the quality of your password with the Microsoft Password Checker!

This week..passwording your Outlook PST file. The best way to secure your computer, let alone your PST file is to have user accounts with passwords, particularly in XP and Vista. However, if you want to add another layer of protection to your emails, calendar and contact details then you can with the following steps

1. Right Click on PST folder name in outlook, unless you have changed it this will be called “Personal Folders”
2. Choose “Properties” from the menu
3. Choose “Advanced” at the bottom
4. Choose “Change Password”
5. Leave the old password blank and just enter the password you wish to use in the”New Password” and “Verify Password” boxes.
6. Done! Now when you open Outlook you will be asked for a password, just don’t forget what it is!

Hope that is useful.