Skip to content
Need to learn or teach remotely? Check out our new resources to help you work, learn or teach from anywhere.

8. Extensions: Track Your Monthly Expenses

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.

Sort Your Expense Data

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.

Calculate Your Monthly Savings Balance

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.

Instructions

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