Grrrr, learn
EDIT: Ok, decided to help a bit. Is it a target point spell (like impale)? You can make it so the caster moves a bit a time till he reaches the target point, and you can order him to play the animation you want. Also, for ignoring doodads, water etc. there is an action 'Unit - Turn off collision' or something. Then turn it on again at the end. Make it invulnerable at the begining so you can use 'Unit - Damage area' and then make it vulnerable at the end. Otherwise, the damage area spell would damage the caster also. There is one slight problem, that spell would damage allies too. If you don't want it to damage allies, then make a unit group of enemies in a wanted radius, then do a 'Unit Group - Pick every unit in.....' and damage each unit one by one.