Wizards are like iphones. Whereas iphones have an app for that, Wizards have a spell for that. Really, they do. At least they did in pre-4e editions. Of course having the right spell for the job when you need it can be the problematic part. That said there are goodly sets of spells that can replace entire party members if used with sufficient intelligent application.
Art from Magicka (you should sense a theme by now. Don't worry if you don't like it, it will pass)