Create a Budget in Google Sheets
- Free
- Certificate included
- Course certificate
- 7 hours
Create a Budget in Google Sheets is a lesson from Google's Applied Digital Skills programme, hosted on the Google for Education learning site. It teaches you to make financial decisions by researching costs and comparing spending in a spreadsheet. The lesson runs through making a long-term spending decision, researching and collecting data, adding rows and duplicating formulas, using data and formulas to inform a decision, and developing a budget, with extension activities on researching car loans and planning a vacation. Google lists the duration as 7 hours (7 to 9 hours on the lesson card), names Sheets, Search and Maps as the digital tools, and lists conditional formulas, data analysis and organising data as the skills.
The stated audience is middle-school and high-school students, and optional teaching materials are included for classrooms. Applied Digital Skills describes its video lessons as free of charge, and the lesson page shows a credential for completion. Nothing on the page states a level, so none is recorded.
What you’ll learn
- Research and compare costs to make a long-term spending decision
- Collect and organise data in a spreadsheet and duplicate formulas across rows
- Apply basic and advanced formulas such as SUMIF to calculate costs
- Use spreadsheet data to inform a decision and develop a budget
Who it’s for
Students and teachers using Google Sheets in class, and adults who want a guided first budget in a spreadsheet. Written for a school audience, so it is not aimed at working professionals.
Source: Google Skillshop (opens in a new tab) · Verified · Report a change
More free Google courses
Every Google course we have verified, with cost and certificate terms compared.
BusinessAll free business courses
Free and free-to-audit business courses from every provider, ranked.