Archive | November, 2012

Tame your computer – a sticky start

23 Nov

Wouldn’t it be great to have certain programs such as Outlook or – my favourite! – Sticky Notes (more about that later) start automatically when you turn on your PC?

Here’s how:

  1. Click the Start button (or press the WIN key).
  2. In the search box type Sticky Notes (actually, just typing Sticky will be enough) or the name of the program you would like to start automatically.
  3. Right-click the program and select Open file location.
  4. Click the Start button (or press WIN), click All Programs.
  5. In the list of programs right-click the Startup folder (the list is alphabetical, so as long as you are not dyslexic you should be fine) and select Open.
  6. Right-click and drag the program from the first window into the Startup folder and select Create Shortcuts here.

Next time you turn on your PC your favourite program(s) will have launched by the time you get back with your first cuppa!

By the way, Sticky Notes are like little Post-it Notes (but less expensive!) and I use them to write my to-do lists. They are very user-friendly, but if you are struggling to get to grips with them, just give a shout.

Tame your computer – 100% easy money

17 Nov

Recently, I was working at a client’s site and was confronted with a dinky little keyboard that is supposed to relieve the symptoms of Repetitive Strain Injury (RSI). As you probably know, many people develop RSI in their mouse hand because of the constant movement back and forth from the mouse to the keyboard.

OK, keyboard shortcuts can help, but the problem is that not a lot of people know them! Hence my mission. Here are two more of what I believe to be intuitive ones for Excel.

  1. To apply percent format : press CTRL+SHIFT+%
  2. To apply currency format : press CTRL+SHIFT+$

By the way, although you type a dollar sign, the currency style applied will depend on the regional settings for currency in your Control Panel. So for our British readers this means pounds sterling.

Tame your computer – find a needle in a haystack

9 Nov

OpenText document management software products reduce time spent reviewing documents, helping you find your way through the version chaos. Searching in Livelink is easy. Just above the search bar there are some great (sometimes unnoticed) buttons that can help you find a needle in a haystack.  For example, if you know the item you are looking for is an Excel file you can tell Livelink to display Excel files only in the search result.

Here’s how:

  1. Click on the Select Searchable Type button (indicated by a star).
  2. Select the item type you are looking for.
  3. Click the Go button. (Pressing the ENTER key won’t work.)

If you want to refine your search, simply type one or more search terms (the words or phrase that best describe the information you want to find) into the search bar and click on the Go button or press the ENTER key. (Don’t forget the double quotes – “ ” – if you are using a fixed sequence of one or more words, such as “finding items you added”. Or combine it with any of the other useful buttons, such as Select Creator to find only those Excel files added by you and/or the Select Modification Time Period button to find only those Excel files added by you but modified by anybody else in the past month or so.

Tame your computer – make downloads a doddle

2 Nov

Microsoft’s security paranoia blocks automatic download of pictures, which means that beautiful e-cards like the ones designed by nativeBrand or the quirky weekly newsletter of Innocent (yes, I do use email for private use as well) end up looking weird. OK, I can of course download the pictures when I’m reading the message, but why not change the automatic download settings once and for all?

Here’s how:

In Outlook 2003-2007:

  1. On the Tools menu, click Trust Center, and then click Automatic Download.
  2. Untick the Don’t download pictures automatically in HTML e-mail messages or RSS items check box.

In Outlook 2010:

  1. Click on the File tab.
  2. Click the Options button.
  3. In the left pane, click on the Trust Center category.
  4. At the right side of the dialogue box, click on the Trust Center Settings button.
  5. Untick the Don’t download pictures automatically in HTML e-mail messages or RSS items check box.

With special thanks to Michael O’Shea of KEEP Consulting for the inspiration for this week’s tip!