Most of the spells listed below provide utility in serveral ways.
the only Alteration perk that improve these spells is Stability
Candlelight: One of the two Lighting spells which can be found or bought in the game. Upon use your character will charge the spell, after releasing the trigger you'll release a sphere of light from your hand (*Note only one sphere can be aktive at a time*) which will fellow you around while providing light for 60 seconds. If you picked up the Alteration Duel Casting the duration can be increased to 120 seconds if you Duel cast it. Novice level
Equilibrium: A Special spell in the sense that you can only buy it from Tolfdir at The College of Winterhold. Upon use you'll start to convert 25 health into 25 magicka pr second (*Note you can comitt suicide if you overuse the spell*) Novice level
Magelight: The Second lighting spell which can be found or bought from magic stores in game. Upon use your character will charge the spell, after releasing the trigger a sphere of light will be fired from your hand/hands toward the crosshair. The sphere will stick to any surface where it will provide light to the area around it. Apprentice level
Detect Life: A Utility spell you can earn by completing the quest called Infiltration for Stalleo who's located outside Treva's Watch. Using the spell will cause every Living being to emit Purple mist which only you can see (Can even see it through walls). Adept level
Telekinesis: A Utility spell which can be bought from magic stores in the game. Lets you basicly pick up items/objects from a distance. Adept level
Transmute: A Utility spell which can be found or bought from magic stores in the game. Lets you transmute Iron Ore into Silver Ore and Silver Ore into Gold Ore. The tome can be found inside the Halted Stream Camp Mine. Adept level
Water Breathing: A Utility Spell which can be found or bought from magic stores in the game. Lets you Breath underwater for 60 seconds. Adept level
Detect Dead: A Utility spell which can be bought from magic stores in the game. Works in a similar manner to Detect Life but only for Undeads. Expert level
Paralyze: A Utility spell Which can be Bought from magic stores in the game. Upon use your character will charge the spell, after releasing the trigger you'll fire a green orb toward your crosshair, those hit by the orb will be frozen in whatever position they had before being hit for 10 seconds without the Stability perk. Can be used for offence or. . . .Comedy <.< Expert level
Mass Paralysis: A Area of Effect version of Paralyze. Unlike the other spells where there is a charge before cast, you're not able to move unless you finish the spell or give up, which in turn makes you vulnerable to attacks, since you're reguire to charge with both hands. After completing the spell any NPC, friend or foe will be frozen in whatever position they were in before being effected by the spell for 10 seconds without the Stability perk. Master level
How to unlock: Upon reaching 100 in the Alteration Tree you can talk to Tolfdir at The College of Winterhold to start the quest called Alteration Ritual Spell, After completing the quest you can buy the spell tome from Tolfdir.