How to create a dynamic budget planner in Excel using Scribe! #excel #spreadsheets #scribe, by Excelbychris on YouTube. 1 min 22 s.
- Video length
- 1 min 22 s
- Time to do it
- 30 minutes
- Difficulty
- Easy
- Steps
- 9
What you need
Steps
Open a blank Excel workbook and name the first sheet Budget. In row 1, type headers across the columns: Category, Planned, Actual, Difference.
List your income sources and expense categories down column A, one per row. Group income at the top and expenses below it.
Enter your planned amounts in column B and your real spending in column C as the month goes on.
In the first Difference cell, type =C2-B2 and press Enter. Drag the fill handle down to copy the formula to every row.
Add a Total row under the income block. Use =SUM(B2:B6) and =SUM(C2:C6) so totals update when you change any figure.
Add a second Total row for expenses the same way. Then in a new cell, subtract total expenses from total income to show what is left.
Select your data range and press Ctrl+T to turn it into an Excel table. New rows you add will pick up the formulas automatically.
Format the money columns: select them, right-click, choose Format Cells, then Currency. Colour negative Difference values red with conditional formatting.
Save the file as Budget.xlsx. Each month, copy the sheet, clear the Actual column and keep the Planned figures as your template.
Tips and common mistakes
Use an Excel table rather than plain cells so totals and formulas expand when you add rows.
Keep planned and actual amounts in separate columns so you can see where you overspent.
Lock the header row with View, Freeze Panes so labels stay visible as you scroll.
Do not type numbers as text with currency symbols; format the cells instead so SUM works.
Questions
Do I need Scribe to make this budget planner?
No. Scribe only records the steps into a written guide. You can build the whole sheet in Excel by hand.
How do I make the totals update automatically?
Use SUM formulas or an Excel table. Both recalculate as soon as you change a planned or actual amount.
Can I reuse the sheet every month?
Yes. Right-click the sheet tab, choose Move or Copy, tick Create a copy, then clear the Actual column for the new month.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
