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

Time

This lesson takes approximately 60 minutes to complete.

Goals

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

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