For typical 8-bit sound effects, use FX Hammer. This tutorial will help you learn how to use it.
For more advanced sound effects, i.e. sample sounds, follow this tutorial. This is the sole reason I downloaded Audacity on my laptop.
