O'Reilly logo

Apple Training Series: iWork ’09 by Richard Harrington

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

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

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