Cmd-shift-G in finder. (In an open file dialog, typing '~' or '/' will also bring up the same 'go to folder' dialog.)