Probing magnetic excitations, fluctuations and correlation lengths by muon spin relaxation and rotation techniques