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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
