Quantum Chemistry and Dynamics of Excited States