Many-Body Approach to Electronic Excitations