Excited states of molecules from Green's function perturbation techniques