Data analysis in Numbers
Numbers’ newest feature – pivot tables – is a powerful data analysis tool
IT WILL TAKE
> 45 minutes
YOU WILL LEARN
> How to use pivot tables in Numbers
YOU’LL NEED
> Numbers 11.2 or later
Genius tip!
The values field defaults to summing the values in the data type, but you can make it show the average, the number of records, the maximum, or minimum.
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.