Set Up Your Spreadsheet
Transcript
In this video, you will set up your spreadsheet.
Using a digital tool to track the cost of your items and calculate percentages can help you plan small-scale and large-scale purchases.
You will have a better idea of what you can expect to spend on your items.
You can organize your purchase plan by setting up your spreadsheet.
To begin, choose what you plan on purchasing.
You might need to buy supplies for school, a hobby, or another activity.
Or you might have an event you are helping your school organize that involves more than one purchase.
To start your spreadsheet, rename it to fit your purpose.
Then, add a heading to the first column in your spreadsheet.
Each heading should indicate the information that you will need to know when planning your purchases, such as “Item” for the items you plan to purchase...
and “Vendor” for the business you will make your purchase from.
Continue adding column headings to help you keep track of item details and the costs related to those items.
You can change, remove, or add to these headings as needed.
Next, change the color of the cells that contain the column headings.
This will add emphasis to your headings and separate them further from the purchase details you will add.
Instructions
- Choose your purpose for tracking spending.
- Add at least five column headings.
- Change the color of the cells with headings.