Track Your Monthly Expenses

Learn how to use a spreadsheet to track your monthly expenses.

Course objectives

As you complete this course, you'll learn and practice the following digital skills, terms, and concepts:

Digital Skills	Terms and Concepts
Open and name a spreadsheet	Spreadsheet
Navigate a spreadsheet	Cell
Edit the contents of cells in a spreadsheet	Row
Make a table in a spreadsheet	Column
Use a spreadsheet formula	Table
Format a spreadsheet	Budget
	Heading

Course curriculum

These lessons are included in your course:

1. Introduction to Track Your Monthly Expenses
2. List Items and Costs
3. List Categories and Determine Frequency
4. Create Column Headings
5. Add Up Your Expenses
6. Track Your Monthly Expenses Wrap-Up
7. Assessment
1. Instructions
2. Track More Monthly Expenses by Adding Sheets
3. Sort Your Expense Data
4. Use Data Validation to Create a Drop-Down Menu
5. Calculate Your Monthly Savings Balance
6. Calculate Expense by Category
7. Highlight Data with Conditional Formatting
8. Reflection

About this course

$24.99
15 lessons

Course outcomes

This course will teach you to draft something similar to these example student outcomes.

Who is this courses for?

This course is designed to help those who are new to technology to (1) develop a basic understanding of Google Sheets and (2) learn how to use a spreadsheet application to track monthly expenses.

Buy now

What is Google Sheets?

Google Sheets is an online spreadsheet app that lets you create, format, and collaborate on spreadsheets in real-time and from any device.

How much does Google Sheets cost?

Google Sheets is free for personal use. Businesses, schools, and individuals needing professional features and improved capabilities can choose between a variety of paid Google Workspace plans.