Chapter 15. Advanced Spreadsheets

Lesson Files

Lessons > Lesson_15 > 15_Team_Roster.numbers

Lessons > Lesson_15 > 15_Time_Log.numbers

Lessons > Lesson_15 > 15_College_Savings.numbers


This lesson takes approximately 60 minutes to complete.


Freeze a header row

Organize a table using categories and subcategories

Format a table with styles

Filter table data

Change the formatting of cells for special data types

Locate functions with the Function Browser

Replace placeholder arguments in a function

In the two previous lessons, we used tables to organize data and analyze and sort information. In this lesson, we’ll take data analysis a step further, and dive into the finer points of filtering, categorizing, summarizing, and calculating with Numbers ...

Get Apple Training Series: iWork ’09 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.