They are a great way of filling up their Spellcaster Rank meter to reach the next level, though be warned - brewing and drinking them can backfire and inflict a Curse.
Potions are brewed by your Spellcaster Sim using Alchemy or purchased and grant your Sim with certain effects when consumed.