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

Time

This lesson takes approximately 60 minutes to complete.

Goals

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 O’Reilly online learning.

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