Magnetic States and Excitations of Complex Spin Systems