I was shown this at an MSDN event and use it regularly since. You can open a CMD prompt at the current location from windows explorer, simply by typing in the folder address bar, then hit return.

Navigate to location

Type “cmd” into the address bar as shown below

The cmd window will open up at the same folder location

This is equivalent to the more familiar [Shift]+Right Clicking in the explorer window and Open command window here