Dynamic magnetic excitations in 3d and 4f atoms and clusters