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

Ever been infected with a virus but not known what to do?  Well have no fear…PCToolbox is here…with a tutorial to help you remove the virus!

1. Firstly download the free version of Malwarebytes
2. Now you need to turn off System Restore. Use the following tutorials to aid you:
   For Windows 7
   For Vista
   For XP
3. Boot your machine into ‘Safe Mode’. This is done by restarting your computer and immediately when it starts to come on keep tapping F8 until you get a menu on the screen to choose Safe Mode.
4. Now install and run Malwarebytes. Remove whatever the software finds.
5. You may have to repeat step 4 a few times!
6. Now reboot your machine normally and run Malwarebytes 1 more time assuming it finds nothing
7. Turn ‘System Restore’ back on. Use the following tutorials to help you:
   For Windows
   For Vista
   For XP

Please Note – This tutorial is designed for those who are competent computer users. All PCToolbox advice is produced in the best interest of the reader to help maintain a healthy working machine and therefore cannot be held responsible for any problems that may occur. If you’re unsure about any of the above advice please contact your local IT Technician.

On the odd but very rare occasion you may have to turn off System Restore. System Restore is a component on Microsoft Windows operating systems which allows for the rolling back of system files, registry keys, installed programs, etc., to a previous state in the event of malfunctioning or failure. This tutorial will show you how to switch it on and off if you’re using Windows 7.

Turn Off System Restore in Windows 7

• Firstly, click the windows start orb and right-click on Computer. Then select ‘Properties’
  
• Select ‘System Protection’
  
• Click ‘Configure’
  
• Then select to turn-off system protection
  
• Finally Click OK, read the message and then click ‘Yes’ to continue
  

Turn System Restore On – Windows 7

• Firstly, click the windows start orb and right-click on Computer. Then select ‘Properties’
  
• Select ‘System Protection’
  
• Select ‘Restore system setting and previous versions of files’ and click OK
  

On the odd but very rare occasion you may have to turn off System Restore. System Restore is a component on Microsoft Windows operating systems which allows for the rolling back of system files, registry keys, installed programs, etc., to a previous state in the event of malfunctioning or failure. This tutorial will show you how to switch it on and off if you’re using Windows Vista.

Turn Off System Restore in Vista

• Firstly, click the windows start orb and right-click on Computer. Then select ‘Properties’
  
• Select ‘System Protection’
  
• Uncheck the drives and then to confirm click the “Turn System Restore Off” button.
  
  
• To finish click OK
  

Turn System Restore On – Vista

• Firstly, click the windows start orb and right-click on Computer. Then select ‘Properties
  
• Select ‘System Protection’
  
• Click in the box next to the drives to ensure it has a tick
  
• Click OK to confirm
  

On the odd but very rare occasion you may have to turn off System Restore. System Restore is a component on Microsoft Windows operating systems which allows for the rolling back of system files, registry keys, installed programs, etc., to a previous state in the event of malfunctioning or failure. This tutorial will show you how to switch it on and off if you’re using XP.

Turn Off System Restore in XP

• Click ‘Start’, then right-click ‘My Computer’ and select ‘Properties’
  
• Click the ‘System Restore’ tab. Then click in the box next to ‘Turn off System Restore’ so it does have a tick in it and click ‘OK’
  
• Read the message and click ‘Yes’ to continue
  

Turn System Restore On – XP

• Click ‘Start’, then right-click ‘My Computer’ and select ‘Properties’
• Click the ‘System Restore’ tab. Then click in the box next to ‘Turn off System Restore’ so it doesn’t have a tick in it and click ‘OK’