Articles in the Productivity Category
Productivity »
Great article that shows how to use some simple techniques to do in-cell graphing in Excel. I find this a really simple way to align data with a graphical presentation of such, sometime it’s just too hard to get the data to align with the information you are graphing when using a true Excel chart. This appears to be a great little work around.
It uses a REPT function in Excel that I didn’t even know existed. The purpose of this function is to repeat a string a certain number of times. The function accepts 2 parameters…
=REPT(string to …
Productivity »
Here is a nice document which popped up in my reader today about Facebook, a social network. If the whole social network concept is new then here are a few steps you can follow to get up and running. Facebook appears to have some of the largest growth in this environment right now, so if you had to pick one, I would pick this.
Productivity, Web »
There is a side to this story I haven’t seen much about, and that is “why can’t microsoft lock down their own search”?
The way I see it is that search really is an integral part of the operating system, in the same way that file management (like being able to save a document) is part of the file system. By saving a file on my computer I am using the functionality of the OS to manage the location and indexing of the file on the disk. Similarly when I go …
Productivity »
Today I had a task of taking a bunch of data supplied to me in tab delimited format and plugging this into a SQL database. There are of course a few ways to handle this sort of data, however one of things I do regularly is use string concatenation in Excel to build the insert statements required for a task like this.
So next time you are given a list of some sort and need to insert it into a database, try this:
Import the data into excel in whatever way …

Jay McCormack