I would stick with Excel for the time being. It's possible, but iWorks is apparently the replacement for Appleworks (which probably means no more development for Appleworks). And iWorks, as yet, is not even capable of doing what Appleworks can.
In the meantime, Excel is probably the way to go. Hopefully iWorks catches up, it shows promise. For now though, it is limited in its capabilities.