Reorganizing table data


show more Reorganizing table data provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Reorganizing table data

Numbers provides a number of tools to help you reorganize data in a table. Let's check out the Sorting and Filtering options available in Numbers '09 using our 2006-2008 Sales Data. Now the first step is to select the table. To do that, you can click anywhere in the table itself or select it from the Sheets pane. You will notice this table has already been organized using Categories. But what if we wanted to view listings of Condos only in a particular price range and we wanted to view the results in ascending or descending order? No problem. With the table selected, click the Reorganize button. From here, you will notice two additional sections aside from Categories for Filtering and Sorting.

We will start with Filtering. To show Condos only, we need to choose the Type column and have it display Condo. So in the Filter section, click the button currently showing Choose a column and select Type. Next for the criteria, we want it to be Condo so IS, which is the default, is perf...

Reorganizing table data
Video duration: 3m 7s 3h 53m Beginner

Viewers:

Reorganizing table data provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...