Most new managers aren’t prepared to lead — but with the right training and support, they can thrive.