Applied many-body methods in spectroscopy and electronic structure