Update: Part 2 of this article can be found here.

Using spreadsheets to analyze numerical or well-categorized data is relatively straightforward. It might not be easy necessarily, but at least you normally know exactly what to do. If you have ever been faced with open-ended text responses, perhaps from a survey, emailed questions or feedback forms, you know how tricky it can be to make sense of it.

The problems are many. Non-standard formatting, having to manually read each response to understand its content, variable length, and those are just the first that come to mind.

What we need is some way to drill down automatically to see if there are any common patterns, and therefore have an immediate starting point to start interpreting the responses.

Read the rest of this entry »

Excel: Duplicate and Copy Cell content using AutoFill

Posted by Thomas On January - 12 - 2011

This time I’m going to show you how to quickly copy or duplicate cell content using a drag’n’drop-feature. This feature allows you to drag content from one cell to another, filling in values, series or copying formulas.

Click-Drag’n’Drop, or AutoFill

Read the rest of this entry »

Purge Stalled Print Jobs [Quick Tip]

Posted by Thomas On January - 11 - 2011

Don’t you just hate it when your printer messes up? I most certainly do. Every once in a while, a document gets stuck in the spooler system and no documents will print. And if you don’t catch it right away you end up with a stack of documents piling up in your print queue.

You may of course unplug the printer, cut power and pray that this will let you to delete the stuck file from the queue. However, Sometimes even that won’t do you any good. What then? Do you reboot the computer?

Well, There might just be one more thing to try, first…

Purge Stalled Print Jobs … manually

Read the rest of this entry »

Delete Empty Directories and Subdirectories [How To]

Posted by Rich On January - 10 - 2011

Recently, I asked iTunes to organize my music directory (getting music from different sources other than just the iTunes store left it a little messy and I decided I’d let iTunes do its thing) and it did a great job; however, it left a bunch of empty directories. Although these empty directories didn’t pose any performance impact, they just looked… messy and I decided I’d delete them. I started doing this one by one and soon realized I had over 50 empty directories and sub directories. Being lazy, I decided to run a command to remove these directories. I’ve done this a lot in Linux so I figured it was easy; well, not quite, but it’s also not that hard. In this guide, I’ll show you what I did and hope you can find this useful in some way.

Read the rest of this entry »

Speed Up your Computer using Striped Volumes [How-To]

Posted by Thomas On January - 7 - 2011

If you are looking for a way to speed up your computers read and write speed and you like taking chances, then Striped Volumes are the way to go.

A striped volume uses the free space on more than one physical hard disk to create a bigger volume. Unlike a spanned volume, a striped volume writes across all volumes in the stripe in small blocks, distributing the load across the disks in the volume.

How does it work ?

Read the rest of this entry »

How To Easily Handle PC Sound Card Problems

Posted by Guest Post On January - 6 - 2011

In this guest post, James Ricketts discusses how to handle PC sound card problems. Find out more about James at the end of this post.

You just double-clicked your favorite song, turned the volume up, but guess what – there is no audio! You wait wondering what the cause could be, but still no luck. Your speaker simply refuses to produce any sound.

You frantically scan your sound file for a virus and the scan results show everything is clear. Your computer is new, so the cause cannot be a faulty sound card, or incorrect entries in the windows registry.

Read the rest of this entry »


Computer tips in your inbox
Sign up for the Windows Guides newsletter to get PC tips and access to free Windows books (More details)

Subscribe now
Popular Guides

See which sites have been visited on your PC (even if private browsing mode is used)

Create a Windows 7 System Repair Disc

Best Free Anti-malware

Hibernate vs. Sleep vs. Shut-Down

i3, i5, and i7; Dual, Quad, Hexa Core Processors. How to they Differ?

Intel's Ivy Bridge Processor: new Features

Windows Guides on Facebook