How to Make a Budget on Excel
Today, we're going to learn how to create a budget using Excel. A budget helps us plan how we spend and save our money. This video is perfect for kids who want to learn how to manage their money better. Let's get started!
In this video, you’ll learn:
Opening Excel - First, open Excel on your computer. You'll see a blank spreadsheet with rows and columns.
Setting Up Income - In cell A1, type 'Income' and in cell B1, type 'Amount'. This helps us keep track of where our money comes from and how much we have. Then, in cell A2, type 'Allowance' and in cell B2, type '$10'.
Listing Expenses - Next, we'll list our expenses. In cell A4, type 'Expenses' and in cell B4, type 'Amount'. Expenses are things we spend money on. For example, in cell A5, type 'Candy' and in cell B5, type '$2'.
Planning Savings - Now, let's plan our savings. In cell A6, type 'Saving' and in cell B6, type '$3'.
Calculating Net Income - To find out how much money we have left after spending and saving, in cell A8, type 'Net Income'. In cell B8, type the formula =B2-B5-B6 and press Enter.
Adjusting Your Budget - If you decide to save more, you might spend less on candy. Change the amount in cell B6 to '$5' and see how your Net Income changes.
Saving for a Goal - Imagine you want to buy a toy that costs $20. In cell A10, type 'Toy Cost' and in cell B10, type '$20'. In cell A11, type 'Weekly Saving' and in cell B11, type '$3'. In cell A12, type 'Weeks to Save' and in cell B12, type =B10/B11 and press Enter.
By the end of this video, you'll know how to create a simple budget in Excel and understand how to plan for your spending and saving.