Teaching your dog to stay calm around guests starts with prevention (see this blog post for details on the whys and hows). Once prevention is in place, your dog will be ready to learn new, courteous habits.
Before you begin working with actual guests, your dog needs some foundation skills:
Volunteered Eye Contact. In a quiet room, put your dog on leash and reward him with a treat every time he looks at your face.
Volunteered Sit or Down. Each day, count out 25 treats. Feed him one every time you see him choose to sit/down on his own. We want all 25 gone by the end of the day. You can also practice this on leash.
It's very important that your dog volunteer these behaviors without you asking for them. When your dog can earn 10 treats in 30 seconds, move to a more distracting room. When he can earn 10 treats in 30 seconds in that room, he's ready to practice the same behaviors with a guest present! The goal is that your dog pays more attention to you than to your guest.
Keep using your prevention! Although your dog’s been learning that he gets good things for paying attention to you, his behavior won’t change overnight. Keep him on leash or behind a baby gate to prevent this behavior.
Distance is your best friend. Your dog should notice the guest, but not completely loose his marbles. The farther he is from the guest, the easier it will be for him to remember his good manners.
Wait. Resist the temptation to call his name or ask him to sit/down. Just wait for him to volunteer the behavior. Remember, you can move farther away from the guest if he's having a hard time.
Use an extra yummy treat AND verbal praise when he volunteers eye contact or a sit/down.
Ask your guest to completely ignore the dog.
Over time, your dog will be able to move closer and closer to the guest without jumping.
BONUS: one of my favorite tools for teaching dogs to relax despite excitement is Dr. Karen Overall’s Protocol for Relaxation.
To fast track his training, bring him out for a few minutes of training when your guest arrives and then return him to his crate with a yummy stuffed Kong or chew until your guest leaves.