Apple Updates Pages, Numbers, and Keynote With New Features for iOS 15 and macOS Monterey

[sdz]

wow Pivot tables! Cool stuff.
Numbers gets more professional by the year.

 

[cgsnipinva]

Pivot tables... finally? Am I dreaming?
We're now in a BI era though, but it's a start.

True - but the table and graphing capabilities tied to this make Numbers pretty good some simple BI. Given the target audience I think this is pretty solid.

 

[Pixol]

I love these apps. After switching to Apple about a year ago, these apps are MAJOR benefits of sticking with Apple. They make everything easier, for no cost. And I don't have to store everything on a web browser.

 

[Pixol]

Pivottables added! No mention in article! Stop the presses, and rewrite the article

Technically Numbers has had Categories for a while, Pivot Tables by another name. People just never realized it.

 

[ministerman]

So...i guess i'm hosed? My Mac Mini did an auto update, and now I have these newer versions of Pages and Keynote...but...it says it requires OS Monterey to use. But I don't have Monterey...because...well...it's not out yet. So now I can't open up ANY pages or keynote file. What the heck do I do? I use both of these for my job daily, and I can't open up things I was working on earlier.

 

[Pixol]

So...i guess i'm hosed? My Mac Mini did an auto update, and now I have these newer versions of Pages and Keynote...but...it says it requires OS Monterey to use. But I don't have Monterey...because...well...it's not out yet. So now I can't open up ANY pages or keynote file. What the heck do I do? I use both of these for my job daily, and I can't open up things I was working on earlier.

Monterey is only required for certain functions. The apps don’t require Monterey to work. Big Sur is compatible.

 

[sub150]

Technically Numbers has had Categories for a while, Pivot Tables by another name. People just never realized it.

Not the same...that only allowed you to sort via categories.

 

[SalisburySam]

Feel free to use. MR won't accept icns file as an upload, but you can convert from these png's.

Beautifully done, and thank you for sharing them!

 

[cgsnipinva]

I was playing with the new numbers last night and just realized they enhanced filtering - which I use alot - this is a big improvement. Along with Pivot tables, Numbers is really shaping up.

 

[cgsnipinva]

Not the same...that only allowed you to sort via categories.

I think categories is still available - so now you have both.

 

[cgsnipinva]

You realize the name "PivotTable" was trademarked, meaning no one else could use that name? The functionality was not patented. It's been around for decades, and Apple could have implemented this before the software giant LibreOffice did in 2013 (/sarcasm).

I could rattle off 100 features Excel has that Apple could add, but at the end of the day Numbers is a completely bare bones application.

I would not agree Numbers is bare bones. Many of the features you reference are those added for Excel to work with MS Power BI - which is a different use case than traditional spreadsheets. Numbers has about the same formula coverage and now includes pivot tables and multiple select filters with search. There are really a handful of features that are in Excel that are not in Numbers that I think are material - text to column, remove duplicates, groupings, sparklines, and some additional charting capabilities.

Hardly "100 hundred features" as a gap.

 

[jackster12]

What I want to know -- and have wanted to know for many, many versions now -- is why they removed the ability to drag in descriptive URLs and have never restored it. It's the first thing I check with every update.

That is...

 

[cgsnipinva]

That would be a good feature to add to iWork.

 

[gcoghill]

Can anyone confirm that files edited in this new 11.2 version will be compatible with macOS 10.14 and Numbers 10.2 on Mac?

I skipped the prior iOS version out of paranoia, but was told here that the files were compatible. My iOS devices are still currently on iOS 14.