Lesson 9. Making Interactive Spreadsheets

Lesson Files

APTS Pages Numbers Keynote > Lesson_09 > ju-jitsu-academy-09.numbers

APTS Pages Numbers Keynote > Lesson_09 > ju-jitsu-grading-idea.xls

APTS Pages Numbers Keynote > Lesson_09 > ju-jitsu-finished.numbers


This lesson takes approximately 60 minutes to complete.


Open and upgrade a Numbers spreadsheet

Open and edit an Excel workbook

Use dynamic data formats

Add conditional highlighting

Create and apply table styles

Secure spreadsheets with passwords

Spreadsheets can be expanded beyond performing simple arithmetic calculation to running tailored formulas for a myriad of programming-like functions. But, let’s pause here. If the thought of programming gives you a cold sweat, rest assured ...

Get Apple Pro Training Series: Pages, Numbers, and Keynote now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.