One of the classes that the GPS conducts deals with the use of spreadsheets in genealogy research. A website called CensusTools is mentioned in that class as a source of spreadsheets already constructed that are helpful in dealing with census data.
Dick Eastman, in his online newsletter, recently featured the same website. Dick's write-up is extensive and gives a good overview of the tools that Gary Minder has assembled. Actually, the spreadsheets cover more than just census data. Gary now has 40 spreadsheets for census, cemetery and passenger manifest data; and all of the downloads are free.
You can read Dick's article at http://tinyurl.com/y9ckp99.
You can visit Gary's site at http://www.censustools.com/