---
title: "Budget in Excel: practice the formulas behind a budget | PracticeExcel"
description: "Practice the formulas behind a budget in a live spreadsheet. Money left after the bills, monthly amounts, spending per category, a running balance and a savings goal."
canonical_url: "https://practiceexcelonline.com/practice/budget-in-excel"
locale: en
meta:
  "og:description": "Practice the formulas behind a budget in a live spreadsheet. Money left after the bills, monthly amounts, spending per category, a running balance and a savings goal."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~QnVkZ2V0IGluIEV4Y2VsOiBwcmFjdGljZSB0aGUgZm9ybXVsYXMgYmVoaW5kIGEgYnVkZ2V0%2Cdescription_~UHJhY3RpY2UgdGhlIGZvcm11bGFzIGJlaGluZCBhIGJ1ZGdldCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQuIE1vbmV5IGxlZnQgYWZ0ZXIgdGhlIGJpbGxzLCBtb250aGx5IGFtb3VudHMsIHNwZW5kaW5nIHBlciBjYXRlZ29yeSwgYSBydW5uaW5nIGJhbGFuY2UgYW5kIGEgc2F2aW5ncyBnb2FsLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSXRlbSIsIlBlciBtb250aCJdfSx7Im4iOjIsImNlbGxzIjpbIkluY29tZSBhZnRlciB0YXgiLCI4MDAwIl19LHsibiI6MywiY2VsbHMiOlsiUmVudCIsIjMwMDAiXX0seyJuIjo0LCJjZWxscyI6WyJFbGVjdHJpY2l0eSBhbmQgaGVhdGluZyIsIjYwMCJdfSx7Im4iOjUsImNlbGxzIjpbIlRyYW5zcG9ydGF0aW9uIiwiNDAwIl19LHsibiI6OSwiY2VsbHMiOlsiTGVmdCBhZnRlciB0aGUgYmlsbHMiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9idWRnZXQtaW4tZXhjZWwi%2Cs_ACuCgZOINUbA46jJ.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Budget in Excel: practice the formulas behind a budget | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~QnVkZ2V0IGluIEV4Y2VsOiBwcmFjdGljZSB0aGUgZm9ybXVsYXMgYmVoaW5kIGEgYnVkZ2V0%2Cdescription_~UHJhY3RpY2UgdGhlIGZvcm11bGFzIGJlaGluZCBhIGJ1ZGdldCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQuIE1vbmV5IGxlZnQgYWZ0ZXIgdGhlIGJpbGxzLCBtb250aGx5IGFtb3VudHMsIHNwZW5kaW5nIHBlciBjYXRlZ29yeSwgYSBydW5uaW5nIGJhbGFuY2UgYW5kIGEgc2F2aW5ncyBnb2FsLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSXRlbSIsIlBlciBtb250aCJdfSx7Im4iOjIsImNlbGxzIjpbIkluY29tZSBhZnRlciB0YXgiLCI4MDAwIl19LHsibiI6MywiY2VsbHMiOlsiUmVudCIsIjMwMDAiXX0seyJuIjo0LCJjZWxscyI6WyJFbGVjdHJpY2l0eSBhbmQgaGVhdGluZyIsIjYwMCJdfSx7Im4iOjUsImNlbGxzIjpbIlRyYW5zcG9ydGF0aW9uIiwiNDAwIl19LHsibiI6OSwiY2VsbHMiOlsiTGVmdCBhZnRlciB0aGUgYmlsbHMiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9idWRnZXQtaW4tZXhjZWwi%2Cs_ACuCgZOINUbA46jJ.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **Budget practice exercises**

The formulas behind a household budget: what is left after the bills, yearly bills turned into monthly amounts, spending per category, a running balance and how many months it takes to save up for something.

[**Start the first exercise**](https://practiceexcelonline.com/practice/budget-in-excel/monthly-budget-left-over)

1. [**1****What is left after the bills**In B9, work out how much is left each month after the fixed bills: the income in B2 minus all the bills in B3:B8. Subtract one SUM instead of each bill on its own.](https://practiceexcelonline.com/practice/budget-in-excel/monthly-budget-left-over)
2. [**2****Yearly and quarterly bills per month****Premium**In D2, turn the amount in B2 into a monthly amount: divide yearly bills by 12 and quarterly bills by 3, and keep monthly bills as they are. Put one IF inside another.](https://practiceexcelonline.com/practice/budget-in-excel/yearly-bills-per-month)
3. [**3****Spending per category with SUMIF****Premium**In F2, total the amounts for the category in E2 with SUMIF. Lock the two ranges with $, so the formula still covers the whole list when you fill it down to F4.](https://practiceexcelonline.com/practice/budget-in-excel/budget-spending-by-category)
4. [**4****A running balance****Premium**In D3, work out the balance after the paycheck: the balance in the row above plus what came in, minus what went out. Leave the references unlocked, so the formula works when you fill it down.](https://practiceexcelonline.com/practice/budget-in-excel/running-balance)
5. [**5****Months to a savings goal with ROUNDUP****Premium**In D2, work out how many months it takes to save up for the vacation. Divide the price by the monthly savings and round up with ROUNDUP. Part of a month still means waiting a whole extra month.](https://practiceexcelonline.com/practice/budget-in-excel/savings-goal-months)

## **Read the guide**

- [**Excel budget template: free download and the formulas behind it**](https://practiceexcelonline.com/learn/excel-budget-template)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/budget-in-excel#webpage","description":"Practice the formulas behind a budget in a live spreadsheet. Money left after the bills, monthly amounts, spending per category, a running balance and a savings goal.","name":"Budget in Excel: practice the formulas behind a budget","url":"https://practiceexcelonline.com/practice/budget-in-excel","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/budget-in-excel#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/budget-in-excel"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/budget-in-excel#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"Budget in Excel: practice the formulas behind a budget","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.