No, please do not recommend Carnegie. It is a fine specimen of cargo cult.

Much better is to learn psychology, courses are available free on Coursera, Udacity and EDx.

I don't think it's a cargo cult at all. It gives actionable advice on how to get along with people and not be a douchebag.

You can spend your time doing a psychology course, but I'm not sure that would make you a more affable person.

Yes, read this book. Very important if you want to learn about people.