|
Quote: |
|
|
Originally Posted by hhk  |
|
|
|
|
Anyone get a pre-release version and try it? Opinions? I've been trying to use iWork for over a year and find that I still miss Excel, especially Pivot Tables. |
|
|
|
|
By contrast, I was tasked today to rework a very simply Excel spreadsheet - something I've done hundreds of times in the past. But a half-hour into it, my blood pressure was rising... (this is the Office 2008 version). Stupidly simple things keep fouling up the layout... invisible indentations, inexplicably display of ## symbols instead of formula results or even plain text, etc. (and yes, I know - I think - most of the tricks).
ANYway... as to your issue with
Pivot Tables, you may not be aware that Numbers in
iWork '09 has something that approximates this:
|
Quote: |
|
|
|
|
Numbers receives a wealth of feature updates this time around. A far more user-friendly take on pivot tables, known as Table Categories, makes it really easy to take flat-data tables and better organise them.
For users intimidated by Microsoft Excel's pivot-table wizard (and I'll include myself there), Apple's reworking is a breath of fresh air. You simply right-click the relevant column you want to sort by, and choose the "Categorise by this Column" option. You're not limited to one category, though and can keep adding or re-ordering categories and sub-categories to you liking. (Guardian UK, 22 Jan 2009) |
|
|
|
|
And... with iWork '11 coming out any... ummm...
month now, you might want to give the Trial version a shot when it becomes available.
.
Linear Mode
