💰 Personal Finance Dashboard in Excel | Budget, Expense & Savings Tracker | Step-by-Step Tutorial, by Vizspire on YouTube. 27 min 16 s.
- Video length
- 27 min 16 s
- Time to do it
- 45 minutes
- Difficulty
- Medium
- Steps
- 9
What you need
Steps
Open a new workbook and paste your transactions into one sheet. Give the range a clear header row and remove blank rows, merged cells and totals so pivot tables read it cleanly.
Select the data range and insert a pivot table on a new sheet. Add Month to Rows, then drag Income and Expense amounts into Values so each month shows both figures.
Build a second pivot table for expenses by category and a third for income by category. Keep each pivot on its own helper sheet so the dashboard sheet stays clean.
Create a dashboard sheet and sketch the layout: KPI cards across the top, a monthly income vs expense chart in the middle, and category and savings charts below.
Make KPI cards for Income, Expenses, Net Savings, Savings Rate and Budget Utilization. Use SUMIFS or GETPIVOTDATA formulas linked to cells so the numbers update with your data.
Insert pivot charts from your pivot tables: a clustered column chart for monthly income vs expense, a pie or bar chart for expense categories, and a line chart for savings goals.
Format each chart: remove gridlines, set a consistent color per category, add data labels where useful and size charts to fit the layout grid.
Add slicers for Month, Category and Account. Connect each slicer to all pivot tables with Report Connections so one click filters the whole dashboard.
Test the dashboard by picking a month in the slicer and checking that every KPI and chart changes. Add a Refresh All button or note so new data flows through.
Tips and common mistakes
Convert your transaction range into an Excel Table first, so new rows are picked up when you refresh the pivots.
Keep raw data, pivot tables and the dashboard on separate sheets to avoid broken layouts.
Use Report Connections on every slicer, or some charts will ignore the filter and show wrong totals.
Save a copy before heavy formatting so you can return to a clean version if a chart breaks.
Questions
Do I need a paid template to do this?
No. You can build the whole dashboard from your own transaction list using pivot tables, formulas and slicers. A ready-made template only saves time.
Why do my charts not change when I click a slicer?
The slicer is probably connected to only one pivot table. Right-click the slicer, choose Report Connections and tick every pivot table used by the dashboard.
How do I add next month's transactions?
Add the rows inside your Excel Table, then click Refresh All on the Data tab. The pivot tables and KPI formulas will pick up the new data.
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.
