Theoretical spectroscopy of realistic condensed matter systems