Tutorial Topics

Search for Tutorials Show All Tutorials Pricing About Us

Tags

Below are all the results for tag: "ipad apps"

Results (1)

Pivot Tables in Numbers

Date: 19th November 2021

Duration: 33:02

Show ref: SCOM1101

You may think pivot tables are for spreadsheet nerds, and there's some truth to that. Allison's goal, however, is to show you how enjoyable and useful they can be.

Now that Apple has finally brought pivot tables to Numbers, we can create them on our Macs, iPads, and even iPhones. Faced with a pile of data, pivot tables can help you can turn that mess into actionable information.

Allison uses data she's collected about solar energy generation and power consumption to demonstrate how to take a long spreadsheet and turn it into a simple 4x4 pivot table that answers the question, "Am I generating more power than I'm consuming?"