Excel keyboard shortcut - CTRL+1

Hold down Ctrl and press 1. This opens the format cells dialog box.

Knowledge worker?

Are you a knowledge worker?
Then make sure you know stuff!

Lots of stuff.
A huge range of stuff.

Excel Shortcut - Insert Today's Date

Like a lot of engineers, I live and die by Excel. There are a handful of essential keyboard shortcuts, but they are hard to learn. It seems easier for some reason to learn shortcuts one by one. So I will occasionally post the ones that I think make me more productive.

Ctrl + ;  (Hold down the Control key and press the semicolon key at the same time).
This inserts today's date in the current cell. Cool.

Cool PDF tools

I know - your boss won’t pay for full adobe acrobat to edit and fix pdfs. Don’t grizzle there are lots of free tools that will do the same jobs. The three I find best are:

1) Bullzip – for creating pdfs. It appears in your list of printers. (Windows) http://www.bullzip.com/products/pdf/info.php

2) PDFsam for splitting, merging, rotating and visual reorganising files http://www.pdfsam.org/ (free, open source Windows and Mac)

3) NitroPDF for converting pdfs to excel, word, extract images and edit pdfs. (Windows) http://www.nitropdf.com/

   Bullzip and pdfsam require the installation of ghostscript a free open source tool.

Let me know in the comments if you have found something better that you have been using for a while.