O'Reilly logo

Apple Pro Training Series: Pages, Numbers, and Keynote by Mark Wood

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required