Computer Tutorials for Beginners

Linking to other Excel Worksheets  - You can put the answer to a formula on a different worksheet. It doesn't have to go into the same sheet you're working on. For example, think back to the exam marks spreadsheet we did earlier. We had a spreadsheet that had the average scores for the students. Below that we had each exam mark as a letter of the alphabet: A, B, C, etc. The spreadsheet we created was this one below: Instead of putting all those Grades on the same Sheet, we could have put them on Sheet2 of the Workbook. If you want to put a formula on a different work sheet, you have to set a reference to the Sheet that contains the numbers going into the formula. An example might clear things up. Start a new spreadsheet In cell A1 of   Sheet1   enter the number 4 In cell A2 of   Sheet1   enter the number 5 Click on   Sheet2   at the bottom of the spreadsheet Click inside cell A1 of   Sheet2 Click inside the formula ba...

Outlook Express Stationery - Brighten up your Emails  - You can brighten up your emails with the use Outlook Express Stationery. This usually consists of a background image, and formatted font. It's very easy to add Stationery to your emails. Try the following. Open up Outlook Express, and click the icon for " Create Mail ". This will open up a new email, with its own menu bar From the   New Message   menu bar, click   Format   and make sure that "Rich Text (HTML)" is selected: NOTE: If you use Rich Text, it means your emails will be sent using HTML. This means you can do all the fancy formatting you want (bulltes, italics, Bold, etc). However, a lot of people don't like to receive emails that have been formatted using HTML, because there are some security issues involved. For example, some dangerous JavaScript can be executed in the background, if you receive HTML emails. If you use Plain Text, then potential for harm is greatly reduced. You can...

Sorting Images in Windows 7  -In the previous section, you learned how to add information to an image. In this section, you'll se what you can do with all this information. This comes under the topic of Sorting. First, though, change your View slider from  Tiles  to  Details : When you arrange the window to Details view, your screen should look like this one: We now have a list of images with the Name, Date, Tags, Size and Ratings showing. These headings can all be used to sort your images. Click on the Ratings, for example, and you'll see a dropdown box: You can choose to display only images with 1, 2, 3, 4 or 5 stars. All you need to do is to check each box. The ones not checked will then be hidden: Here, we're choosing to display only 1 and 2 star images, perhaps with a view to deleting them. (To delete an image, right-click. From the menu that appears, select  Delete . Or choose  Rename  to change the name of the image....

Beginners Guide to going Wireless -Belkin F5D7230uk4 54Mbps Broadband Wireless Router  - The Belkin F5D7230uk4 54Mbps Broadband Wireless Router is for those who have a Cable broadband connection. Use with : Belkin F5D7050uk 54Mbps USB 2.0 Wireless G Adapter: Review Setting up a router for use with Cable broadband can be a tricky affair. This is because your cable provider will have the address of your ethernet card. This is unique, so you can't just plug your cable modem in to the router and expect it to work. You need something called MAC Address spoofing. This is when the router pretends to be your ethernet card. Belkin claim to have you up and running with this router in under 3 minutes. Which is a big plus point! For those users with children in the house, the Belkin F5D7230uk4 wireless router comes with Parental Control settings. This is built in to the router, and you get a free 6 months trial. You can set which web sites or services you don't want th...

Beginners Guide to going Wireless - Belkin Wireless G+ MIMO Modem Router -The Belkin Wireless G+ MIMO Modem Router is for those who have an ADSL connection. Here's a nice picture of the Belkin, though. Use with : Wireless G+ MIMO USB ADAPTOR Review The Belkin Wireless G+ MIMO Modem Router is quite easy to set up for novice wireless users, which can be a big plus. It produces great wireless results from 1 to 25 metres in range. But only when used with the Wireless G+ MIMO USB Adaptor above. It can be difficult to get a Centrino laptop to communicate with this router. And when you do, the results are not that impressive. Sometimes won't pick up a signal at all over wider ranges with a Centrino laptop. One other negative point is that it doesn't ask you to set up WEP/WPA security, so you have to set this up manually in the confuguration pages. This is relatively straightforward, though. Antennas are fixed in place on the router, so you can't unscr...

Secure your PC -Online Banking - Essential Security Measures      - Online banking is quite a handy way to keep track of your finances. You simply log on through your bank's website, and you can do things like set up standing orders, transfer money to people or other accounts, and order cheque books. Online banking also allows you to get financial deals that are just not on offer in the offline world. For convenience sake, you can't beat an online bank! However, this popularity of online banking has not gone unnoticed by the criminal fraternity. We'll show you some popular attacks on your money, and what you can do to prevent them. Phishing One of the most common ways that a criminal will attempt to part you with your money is through something known as Phishing. Phishing is pronounced FISH-ING. It's the Internet's equivalent of this popular sport. The fisherman is a criminal, the bait is usually an email that attempts to panic you into action, and...