Electronic Excitations In Metals And Semiconductors: Ab Initio Studies Of Realistic Many-Particle Systems