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.
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.
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.
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.