Chapter 15. Advanced Spreadsheets
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 ...