Even when Pages completely changed when they redid the engine for web, iOS and Mac, Pages stayed predictable. If you turn invisibles on, you basically know everything of what’s happening at all times.
I spend most of my professional life designing and dealing with spreadsheets and Numbers’ table-based paradigm is simply orders of magnitude more elegant that Excel’s everything-is-a-sheet approach. Why? I can modify tables (inserting row and columns, changing attributes, & cetera) without affecting other tables.
The one thing I miss and that infuriates me is Numbers’ lack of iterative solutions to circular references. Circular references are bad, you say, and I agree, but unfortunately in corporate finance they’re unavoidable when creating business plans because short-term debt depends on interest to be paid and interest to be paid depends on short-term debt. That means that Numbers can only take me so far until I have to export to .xlsx and then slog it out with Excel from then on. It’s a real pity they keep adding useless (to me) features such as collaborative editing and so forth when adding this functionality would take the whole application from being a toy to being a professional instrument.
One can hope, I guess.
You can also use it as basis for a pivot table so excel can make you a much better overview of your data.
Numbers will happily shift down tables to make room, but Excel won’t.
Array formulas are another sort-of alternative for Numbers’ tables, but there, too, the implementation could be better. You can’t insert a row ‘inside’ a range of rows covered by an array formula, for example.
My point was that in Excel this is an afterthought, whereas in Numbers it’s a consequence of how the application is devised from first principles.
Coincidentally, at this very moment I am re-creating an old paper form for another department in the company. They need it as a PDF.
The people from the department sent me their best effort as a Word document. It's a disaster of mismatched styles, misaligned boxes, things that get cut off for no discernible reason, and stuff that won't print right because it's past Word's margins.
I'm almost done re-creating it in Pages, from which I'll output a PDF. It's gone swimmingly.
Pages isn't yet a replacement for every single little thing that Word does, but for the things it does do, it works well, quickly, predictably, and fast. But that may be Word's downfall: It took the kitchen sink route and became a mess.
Pages is a good basic word processor for those who are interested in processing words. It's less "powerful" at doing all the thousand other things that people use Word for that they should probably do in Acrobat.