The transcript will follow that audio as the video plays. Scroll and click on the transcript to jump to that part of the video.
2,065
Plays
63
Likes
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:
App Store Links: Apple Numbers
Show Links: Create a pivot table in Numbers on Mac
(3 comments posted)
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.
You made my day, Tim! I really do love them, so glad you thought it was fun.
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!
Recent Full Tutorials
All Recent TutorialsWe pride ourselves in our responsiveness, but please allow up to 24 hours for us to get back in touch. We are based in UK so there may be a time difference!
Drop us an email
Posting comments is restricted to ScreenCastsOnline members only.
Sign Up