Spreadsheet Duplicates in Excel 2007

Is there any easy way to check a spreadsheet for duplicates in Excel 2007?

• Yes, open up Excel 2007
• Click the Home tab
• Choose Conditional Formatting
• Highlight Cells Rules
• Click Duplicate Values
• Click OK

Excel will highlight the duplicates for you so that you can delete them / change them.

Outlook 2007 with Business Contact Manager

What is Business Contact Manager?

Business Contact Manager allows the user to store contact information, however, it offers so much more. Business Contact Manager can:

• Organise prospect and customer information in one place
• Manage sales leads and opportunities
• Create, personalise and track direct marketing campaigns
• Centralise project information and task management.

For full details see http://office.microsoft.com/en-gb/contactmanager

iGoogle

What's iGoogle?

iGoogle is your own personalised Google page. You will need to have a Google account. Once logged in you can choose to add items to your page that you regularly look at such as weather, news, rss feeds.

Once logged in click on "Add stuff" and choose what you want to fill your iGoogle page. Every time you login you will see your personalised page.

Choose from:

• Tools eg To Do
• Communication eg Google Calendar
• Fun & Games - eg PacMan
• Finance - eg Google Finance Portfolios
• Sports - eg ESPN.com
• Lifestyle -eg MoviesTechnology
• Technology - eg Tech Stuff
• Politics - eg Political Quote of the Day

Visit www.google.com/ig to find out more and set up your own iGoogle page.

Splashup

I'm looking for free photo editor software, any ideas?

Yes, try Splashup.com it's a photo editor.

You need to install Adobe Flash Player if you don't have it already.

It describes itself as "a powerful editing tool and photo manager. With the features professionals use and novices want, it's easy to use, works in real-time and allows you to edit many images at once. "

Free PDF Printer

I need to convert something to PDF - is there a free program on the internet?

Yes, there are a few just search on the internet for "free PDF printer".

Bullzip Free PDF Printer is a good program which is simple to install and PDFs can be password protected. It also runs on Windows Vista.

http://www.bullzip.com/products/pdf/info.php

Apple iPhone Hard Reset

How do I carry out a hard reset on my iPhone?

Hold down the circular button at the bottom and at the same time the off / on button on the top right of your iPhone! Ignore the slide to power off and then hold down the off / on button to turn it back on again.

Installing a new font

How do I install a new font on my PC?

You will need to go to your Control Panel which can be accessed from the Start menu.

So, click Start, Control Panel and Fonts then File, Install New Font.

Choose the location where the fonts are that you want to install and the list of fonts available in that location will show in the box.

Highlight these and choose OK. Your new fonts will be installed and ready to use.

Shorten URLs for Twitter

I'm using Twitter and need to add a link - is there any way I can shorten the link - Tweets are only 140 characters long?

Yes, visit www.tinyurl.com and enter in your link eg http://softwareandsupport.blogspot.com/ and tinyurl will make it much shorter - give it a try.

You can also use http://twitpwr.com

Apple's iPod Touch for the US Military

According to an article on Newsweek, the US military are now using Apple's iPod Touch to connect with each other, translate languages and show video messages to villagers.