Looks like this already got covered! Ninja's right, your best bet for animation (though I would like to have more animation based threads, discussions, and tutorials here!) is in ROM Hacking. Right now, there just isn't the demand for it in A&D, since so little of us actually animate scratch work.
I hope you find what you're looking for though. Animation is really tough, especially in the beginning stages. For what it's worth, whenever I animate something pixilated, I hand draw in the changes to the previous image on a new layer. Stuff like transitional or pre-made effects aren't really made for pixel art, so most of the time they're pointless anyway. Draw in what you want the attack to look like, and use your frame speed to make adjustments.