From StrategyWiki, the free strategy guide and walkthrough wiki

Here are the following spells found in the game:

[edit] PC Spells

Alohomora

This is one of the first spells in the game. It is used to open certain magically locked doors and chests. But more chests than doors.

Depulso

This does exactly what Flipendo does, e.g. hitting switches, pushing blocks and knocking down cauldrons.

Lumos

This spell is once again aimed at gargoyles. Then, the gargoyle will remove some wall cover for you to go through.

Rictusempra

If you don't have this, you will die. This spell is used to combat almost every enemy in the game.

Spongify

Spongify targets certain carpets and it temporary turns it into a substance that propels the user into the air.

Carpe Retractum

It's a good idea to give Ron Weasley this spell. This spell propels you to certain objects or certain objects to you. It can also open certain doors.

Lapifors

This spell targets a rabbit and lets you take control of it. It can eat through grass-filled holes and dig through packs of dirt. Only Hermoine can use this spell, however.

Dragonifors

This is another of Hermoine's new spells in the game. It targets a small dragon and gives you control of it. It can fly and breathe fire (from a flame ball).

Expecto Patrodum

Harry is the only one to use this spell and it's a good idea to give it to him. Since Rictusempra cannot harm Dementors, Expecto Patrodum does just that. But this spell needs to be charged up before using it.

Glacius

Only Harry can use this spell, which cools off Salamanders and their homes and freezes ice. You can also ride on an everlasting rollercoaster of ice; but be careful of falling off. You will die a horrible death doing so.

[edit] Console Spells

Note that you can only can carry two spells at a time.

Flipendo