Skip to content

1. Introduction to Track Your Monthly Expenses
attachment
Students can submit work

Playback Speed:
Transcript

Digitally tracking your expenses is an effective way to organize your personal finances and manage your money.

In this lesson, you will use a spreadsheet to list and categorize your monthly expenses.

Your expenses include all the things you spend your money on each month from necessary items like housing, food, and transportation, to one-time purchases such as a concert ticket or a new jacket.

Spreadsheets make financial decision-making less complicated and more accurate.

They help you collect, organize, sort, and store data, so you can manage your finances more easily.

Tracking your expenses is the first step in building a budget.

This plan for spending and saving money can be used to save more, spend less, and live better.

As you complete this project in Google Sheets, you will learn the basic structure of a spreadsheet, use a spreadsheet to list and categorize your expenses, and use a spreadsheet formula to calculate the sum total of your expenses.

This lesson uses Google Sheets, but you could use these skills with any spreadsheet application.

To work on this lesson, sign in to your Google account.

Open a new tab in your browser, and navigate to Google dot com.

If you are not signed in, do so now.

If you do not have a Google account, pause the video and create one.

To begin, create a new spreadsheet in Google Sheets and give it a title.

Then, move on to the next video to list the items and costs of your expenses.

Now, it’s your turn. sign in to your Google account, open a new spreadsheet, and name your spreadsheet.

Next
Instructions
  1. Sign in to your Google account.
  2. Open a new spreadsheet.
  3. Name your spreadsheet.
Shared work attachment
URL not accepted. Please paste a link to a Scratch project. URL not accepted. Please paste a link from google.com (such as a Google Doc). You don't appear to be signed in. Please refresh the page and try again. Something went wrong. Please refresh the page and try again.

This project will be shared with your teachers

Students can submit their work on this page. View their submitted work on the student progress page of My Classes.

Students can submit their work on this page.

Students: sign in to submit your work.
Teachers: sign in to view submitted work.