Molecular Excitation Dynamics and Relaxation: Quantum Theory and Spectroscopy