Numbers is essential, because it understands dates, better handles CSV files, and doesn't corrupt long numeric UIDs.

But, you're right: Excel is for the complicated stuff. I recommend Numbers to the vast majority of users in our company, who mainly want to organize tabular data, and will never do any calculations with it. The financial folks are welcome to knock themselves out with their Excel wizardry. That separation of concern / purpose works well for both.