The "fantasy" spells, such as turning into a mythical being (e.g. Vampire, mermaid, wolf etc.) do not work, sorry. You cannot use magic to change your physical self or to do the impossible.
I hope you will discover other kinds of magic that interest you though.
(I may have not explained this very well, so feel free to correct me).