This article gives an overview on recent achievements in the theoretical description of electronic excitations in correlated many-body finite and extended systems. Using the random phase approximation we provide quantitative results for the electron-removal probability from fullerenes and small metal clusters. For extended systems, like solids and surfaces, it is shown how the random phase approximation can be implemented in ab-initio schemes for the calculation of the electronic and optical properties of materials.