Playback Speed:
Transcript

In this extension, you will reorganize your expenses using data sorting.

Data sorting allows you to rank the costs of your expense items from most to least or list your expense categories in alphabetical order.

To sort your expenses, you will rank the costs of your expense items from most to least, and put your expense categories in alphabetical order.

Rank your costs from most to least by sorting the data.

First, select the range of cells that contains all four columns of your spreadsheet table including each heading.

Apply data sorting.

A box appears that allows you to customize your sorting.

Next, sort your costs from most to least or least to most.

You can sort from A to Z or Z to A. A refers to the lowest number, and Z refers to the highest.

See the ranking of your costs from most to least.

Notice that the information in your other columns -- Item, Category, and Frequency -- has also been sorted to correspond to the new order of costs in the Cost column.

The spreadsheet automatically arranges all your data, so it remains consistent and all of your costs still correspond to the correct categories.

You can sort the data in any of your columns.

For example, put your categories in alphabetical order to make items easier to find.

To do this, apply data sorting to the category column instead of the cost column.

Your categories are now listed in alphabetical order.

Data sorting makes your expense data easier to interpret and helps you make good decisions about saving and spending money.

Now, it’s your turn. Rank your costs from most to least, and arrange your categories in alphabetical order.

Choose an Extension
Track More Monthly Expenses by Adding Sheets

Students add a sheet to their spreadsheet to extend their budget from month to month.

Students use data sorting to reorganize their expenses.

Use Data Validation to Create a Drop-Down Menu

Students use data validation to organize their expense categories in a dropdown menu.

Students use a spreadsheet formula to calculate their monthly balance.

Calculate Expense by Category

Students use a spreadsheet formula to calculate the total cost of each of their expense categories.

Highlight Data with Conditional Formatting

Students use conditional formatting to highlight selected parts of their expense data.

See more extensions

## Instructions

Choose one of the extension videos below to learn additional skills and continue working on the project started in the main lesson.