When you take your dog out for a walk how do you stop him from getting overly excited and stop him from making a high pitch yapping noise as soon as you depart the front door?

Okay first you don't yell at him, you have to be calm and rational, then if he is still yapping you slap him on the head, pull on the leash or collar and tell him to sit. If none of that works you can go to a store and get a harness, I know that your dog will listen better (from experience) or you can get a bark collar, whenever your dog barks it shocks him and he stops