This post walks through multiple regression, regressing effects to quantify the coefficient collapse, and mediation analysis to formally decompose why it happens.

A survivor's guide to write a decent PhD thesis

Can I calculate correlation value from data and regression's beta coefficients? YES