Use the REPT function to create quick charts

Wouldn't it be great if you didn't have to embed a chart in a spreadsheet to get a graphical comparison?

You can, by using Excel's REPT (REPeaT) funtion.

Here is an example from ZDNET Asia. It's just part of the article, so scroll down a little.

To keep employees informed of their progress, you might keep a worksheet like the one inFigure A, which tracks the completion rates of assigned tasks.

Figure A 

Just listing the completion rates, however, makes it hard to compare one task with another. It's easier to monitor results when they are presented graphically. Follow these steps.

1. Select D2:C11.
2. Enter the following formula (Figure B):
   =REPT("|",C2*100)

Figure B 

3. Press Ctrl + Enter.

The comparative results are now shown graphically, as shown in Figure C.

Figure C 

(Note that you can use any symbol for "|" in the formula. )

You can relocate your default folder

Image via WikipediaWUGNET

You can relocate your own folders easily.
If you want to move your stuff, check this out.

• Click your username at the top right of the Start menu to open your profile.
  
• Right-click Documents and choose Properties.
  
• Then click Location | Move and select the new location, or even create it at this time. You'll be asked if you want to move your documents;
  
• click Yes.
  

Don't try this with the Public folder, though: There's a Location tab, but no Move button.

Extend Your Vista Activation

Image via Wikipedia

WUGNET

Are you testing out Vista's features and compatibility but not sure if you want to go ahead and activate it?
Microsoft has built a software licensing manager into the new OS that lets you extend the activation period. Very understanding for Microsoft, considering so many have returned to XP Pro after buying a machine withh Vista installed.
At the Start menu's search bar, simply type "slmgr -rearm" to get another 30 days.
There is a maximum number of times you can "rearm" the software licensing manager.You can do rearm a maximum of three times before Microsoft blocks further extension periods.

Once you're locked out, that's it. You have to call Microsoft to unlock your computer or take it into a shop.