Data analysis in Numbers

Numbers’ newest feature – pivot tables – is a powerful data analysis tool.

Kenny Hemphill

IT WILL TAKE 45 minutes YOU WILL LEARN How to use pivot tables in Numbers YOU’LL NEED Numbers 11.2 or later While Numbers surpasses Microsoft’s Excel in some areas, it is lacking in others. Excel, ahem, excels at slicing and dicing data and allowing you to build scenarios. While Numbers doesn’t… until now that is. The most recent version of Numbers on Mac, iOS and iPadOS supports pivot tables. And in case you don’t spend your days knee-deep in spreadsheets, pivot tables are tables that allow you to ‘pivot’ data from another table. So, if for example, you have a table that records widgets sales, you might have columns for the type of widget, date sold, price they sold for, quantity and sales office responsible. Each row would be one…

You're reading a preview of

APC (Digital) - 1 Issue, March 2022

DiscountMags is a licensed distributor (not a publisher) of the above content and Publication through Zinio LLC. Accordingly, we have no editorial control over the Publications. Any opinions, advice, statements, services, offers or other information or content expressed or made available by third parties, including those made in Publications offered on our website, are those of the respective author(s) or publisher(s) and not of DiscountMags. DiscountMags does not guarantee the accuracy, completeness, truthfulness, or usefulness of all or any portion of any publication or any services or offers made by third parties, nor will we be liable for any loss or damage caused by your reliance on information contained in any Publication, or your use of services offered, or your acceptance of any offers made through the Service or the Publications. For content removal requests, please contact Zinio.