How to train an excited dog to walk with a leash

Does having a dog at home that gets so excited that it gets out of control as soon as you leave give you a headache? Every time you lead it out, it feels like a fierce tug of war game,