There is no reason that iPad software won't be as sophisticated as current desktop applications like Excel. What makes iPad really interesting to me is that we may be able to invent new ways to interact with software. The iWork (Numbers) demo in the iPad keynote shows some possibilities directly relevant to your point about Excel.
http://events.apple.com.edgesuite.net/1001q3f8hhr/event/inde... [starts at 1:05:40]