The electronic Schrödinger equation Eq. ( ) is in practice still not solvable for many-body systems, due to the presence of the electron-electron interaction Vel-el . The Green's function methods we discuss in this review aim at descriptions of single-or two-particle excited states. As most of the common formulations require information about the ground state electronic structure, we begin the discussion with effective single-particle methods for the ground state.