Probing single-particle and collective states in atomic nuclei with Coulomb excitation