Free Video Tutorial: Pivot Tables in Numbers - Apple Mac, iPad & iPhone Tutorials from ScreenCastsOnline

Tutorial Topics

Search for Tutorials Show All Tutorials Free Membership About Us

Tutorial Description

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?"

The full tutorial covers:

  • Pivot Tables on macOS [00:02:36]
  • First Pivot [00:04:39]
  • Formatting Date for Summary [00:09:04]
  • Pivot Tables Refresh [00:10:27]
  • Filters [00:11:25]
  • Summarize By [00:14:06]
  • Pivot Tables on iPad [00:15:44]
  • Fill Down on iPad [00:16:47]
  • Pivot Table Chart [00:20:19]
  • Create Table for Source Data [00:22:22]
  • Pivot Table Snapshots [00:22:55]
  • Pivot Tables on iPhone [00:26:13]
  • Conditional Filters [00:28:56]
  • Why Not Just Use Filters? [00:30:42]

App Store Links: Apple Numbers

Show Links: Create a pivot table in Numbers on Mac

Video Tutorial Comments

(3 comments posted)

Tim Stringer

Thanks for an excellent screencast! Allison did a masterful job of taking a potentially daunting topic and making it accessible…and even fun. I'm already putting pivot tables to good use in Numbers.

Reply

Allison Sheridan

You made my day, Tim! I really do love them, so glad you thought it was fun.

Robert Roughton

After years of being locked in the Excel hell when needing pivot tables, at last, they come to Mac. Great tutorial that I'm sure will encourage people to use them!

Posting comments is restricted to ScreenCastsOnline members only.

Sign Up