Electronic structure and collective excitations in correlated materials : frequency and time domain perspectives