Nanoscale magnetism, Kondo effect and spin excitations