Apple Training Series: iWork ’09

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