Tag Archives: msword

Refreshers of the Day #sql #excel #word

Posted on by

Updating a column to null in SQL

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls872.htm

Updating columns in general

http://www.w3schools.com/sql/sql_update.asp

Deleting rows in general

http://www.w3schools.com/sql/sql_delete.asp

Copying visible cells only from a filtered excel sheet

http://office.microsoft.com/en-us/excel-help/copy-visible-cells-only-HA010244…

Find and Replace Carriage Returns

http://uk.answers.yahoo.com/question/index?qid=20070929072105AAjHDWu

Nerdy "Aha" moment

Posted on by

Today is one of those days where I felt useful though I am not nearly as nerdy as some of the other programmers here. One of them was working on documentation and having trouble with font styles. I mentioned to him that if he used the built-in heading font styles in his document, he could add a table of contents to the top of the document and it would be auto-populated based on the heading styles. I got “wows” from him and the programmer sitting next to him.

I thought he was going to say, “Duh.”