Rosetta Stone is a decent product bit depending on your goal not necessarily the best. I've used most products on the market and prefer Michel Thomas when it comes to strictly speaking a language. It's audio only so you don't get the instruction in reading/writing the target language.
Check out "How To Learn Any Language" by Barry Farber. It's a good read w lots of great tips.