Saturday, 29 September 2007

"Can you hear it?" Three Freeware Audio Applications

Winamp has long been a popular mp3 player developing a large user community. Members of this community submit a plethora of skins, plug-ins and other add-ons to the Winamp website. Winamp also offers support for iPods and other mp3 players, and functions as an adequate video player.

If you have ever made an audio mix CD from mp3 files, you have probably been annoyed to find that all the tracks play at different volume levels, spoiling that overall ambiance you wished to create with your selection of top tunes. If this problem is a source of vexation for you, try mp3gain. With this program you can quickly balance the levels of a selection of mp3 files, so as to further impress that prospective partner, work colleague, or friend with your eminently good taste.

The best freeware audio editor available is Audacity. It provides support for mp3 files - as well as a number of other formats - and offers enough editing features and effects to meet most user's needs. Unfortunately, Audacity does not support proprietary formats such as wma, but there are plenty of audio file converters available like dBpoweramp.

Friday, 28 September 2007

Keyboard shortcut of the week: Excel

Following on from the megapost of word-processing keyboard shortcuts from earlier this month, here is a selection of keyboard shortcuts for Microsoft Excel.
  • You can navigate around the grid of cells by using the cursor keys.
  • Hold down Ctrl and press Home to jump to the top right cell (A1).
  • Hold down Ctrl and End to jump to the last cell on the spreadsheet with any information in
  • If you wish to edit the contents of a cell press F2

As with word processing, you can hold down the Shift key to select: if you hold down Shift and press the right cursor key then you will select the current cell and the one to the right of it. If you continue to hold down the Shift key and press the down cursor key you will also select the two cells below the ones you already had selected. You can thus hold down the Shift key and press different cursor keys to select different rectangles of cells.

Many of the keyboard shortcuts that work for word processing also work in Excel: holding down Ctrl and pressing B selects bold text; Ctrl and C will copy text, etc.

Tuesday, 25 September 2007

Word to the wise: webmail woes

This is an issue that has cropped up a couple of times at the university where I work.

If you send yourself a document that you are working on, to continue working on it on another PC, remember to save the attached document onto that machine before you start to make changes to it. It is easy to forget this, open the document and start making changes. If you then hit the save icon it will not always save and when you then close whatever program you are editing the document in, your changes will be lost. This is particularly the case for documents accessed via webmail. If you remember to 'Save as' rather than just 'Save' you will be OK, because it will prompt you for a name and location where you wish to save it. Nevertheless, it is better to get into the good habit of copying the document you attached to the email onto the PC before you expend effort making alterations.

Sunday, 23 September 2007

Weekend website: What is this file?

So here is the scenario: you have been sent a file attached to an email. You double click on it - after making sure that it is not a virus or some other malicious file - and you are told that it is an 'unknown file type'. You need to find out what type of file it is, and what programs will open it.

To do this you look at the last few letters after the last '.', e.g. word documents will end with '.doc' (you may not see these extensions for file types that your installation of Windows recognises - to see them: double click on 'My Computer'; select 'Options' from the 'Tools' menu; select the 'View' tab and deselect 'Hide extensions for known file types'.)

So you know what extension the file has, but still don't know how to open it. There are a number of web sites that provide lists of know file extensions. All offer a search tool, so you can just type in a file's extension and find out what programs you need to open it. So here are a few such sites:
Check out this post for details of a website that will convert files to a type that you may be able to open with your existing software.

Friday, 21 September 2007

Keyboard shortcut of the week: Firefox

This week's keyboard shortcuts are all for Firefox - some of them may work in Internet Explorer. Recently, Microsoft have started copying features previously implemented by Mozilla in Firefox, possibly including the keyboard shortcuts. Please let me know which ones work in IE.

To cycle through your tabs rightwards: hold down Ctrl and press the Tab key.

To cycle through tabs leftwards: hold down Ctrl and Shift and press the Tab key.

To open a new tab: hold down Ctrl and press T.

To close the current tab: hold down Ctrl and press W.

To jump to the address bar - where you type in a web address: Press F6 (thanks to glytch for this one).

To open and close the Bookmarks tab: hold down Ctrl and press B (Note: if you are in a rich-text editor on a webpage this will select bold text instead.)

Wednesday, 19 September 2007

What to do when your PC hangs

So, your PC isn't doing anything, the screen is a mess, the hard-drive is whirring away. Is there anything you can do, rather than just reach for the reset button?

Here are my top tips for dealing with those times when Windows hangs.

Don't keep clicking things

Windows buffers (remembers) all these clicks and will implement them when it catches up, preventing you from continuing with what you want to do, and possibly causing havoc. Show a little bit of patience.

Check to see if your PC has crashed
Before you hit that reset button it is wise to check if your PC has actually crashed. To do this simply press the Caps Lock key, and check whether the Caps Lock light goes on or off; if it does then your Windows session may be recoverable. You may have to wait a few seconds to see a response.

Use the Task Manager
All recent versions of Windows have a built in application called 'Task Manager.' To run it simply hold down Ctrl and Alt, and press Delete (note: Windows 2000 users will then have to press the 'Task Manager' button on the dialog box that opens.)

As with all these tips, you will have to wait a while to see if it appears. When it does, check the 'Applications' tab to see if any of the programs you are running have a status of 'Not Responding.' If they are, click on one to highlight it then and click the 'End Task' button. Do this with any other programs that are not responding, then cross your fingers.

If Windows starts working again it is best to save all your work and restart the PC. A clean restart is always preferable to a nasty reset.

Making Windows run faster: upgrade your PC

Mo' Memory
One of the major causes of windows running slowly is a lack of physical memory (called RAM). When this physical memory becomes full, Windows shuffles the information used by inactive programs into a file on your hard-drive called a 'page file' (or sometimes a 'swap file'). This shuffling back and forth of information takes time and slows the operation of your PC down.

Buying and installing more RAM is one way to give your PC a speed boost. There are many different types of RAM available, and you have to install the one that is correct for your PC. You can use the Crucial Memory Advisor™ tool to find out what types of memory your PC supports (Crucial are a major supplier of memory with prices often cheaper than you will find elsewhere). If you need advice about installing your new RAM, check out the How to install RAM article at lifehacker.

Veni Video Vici
Many computers these days have video controller built onto the motherboard (the motherboard is the big circuit board in your PC that all the other devices connect to). If you have such a system, the PC will allocate part of the available RAM to your video hardware, thus making it unavailable for Windows. Also, some software - especially games - relies on a sizable amount of video memory being available. So, another way to give your PC a speed boost is to upgrade the video card. Check out Ryan Pollack's article How to Upgrade and Install a Video Card?

If you have inbuilt video hardware on your motherboard you may have to switch it off in the BIOS (this controls the hardware of your PC before Windows starts), in order to do this consult your manuals. Note: if you have lost the manual you may be able to download it from your PC manufacturer's website.

Pimp my PC
Of course the best upgrade to make your PC run faster is to replace the processor (also known as CPU) with a faster one. The CPU is analogous to the engine in a car, so the powerful it is, the faster the PC will run. Replacing the CPU is not a simple task and should be avoided by computer novices. Your PC may not support all processor types and the actual task of replacing a CPU can be rather fiddly. For this, it would be best to seek the advice of an expert.

Note for laptop users
Of these three upgrades, only the first really applies to you. Changing graphics and CPUs on laptops would either be impossible or expensive. From personal experience I warn you to never take your laptop apart, the manufacturers really jam everything in there, and the whole thing becomes some sort of fiendish puzzle.