Microscopic dynamics and excited state properties of liquid water