ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template) @MyOnlineTrainingHub
ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template)  @MyOnlineTrainingHub
Uploaded January 2024 | Updated November 2026, 3 days ago
A personal budget spreadsheet in Excel that tracks every one of your bank accounts in one place.
➑️ Download and customize a FREE automated personal budget template here: bit.ly/pbtemplate2024

🎬 MORE FREE EXCEL TEMPLATES, full playlist here: bit.ly/templates26playlist

You'll build it from scratch in the video, starting with your income and expense categories. Then you enter what you plan to spend for the year and paste in your bank transactions, tagging each one with a category. Power Query does the rest of the work, combining those three tables into one dataset that feeds the dashboard.

The finished dashboard shows your expenses against budget by category, and your income and spending month by month. Underneath sits a personal profit and loss statement with a green tick or a red cross against every line, so you can see which categories went over without reading a single number. A timeline slicer at the top filters the whole report to any date range you want.

After that, the monthly job takes a couple of minutes: copy your bank statement into the transactions table, tag each row with a category, and click Refresh All.

Works in Excel for Microsoft 365, Excel 2021, 2019 and 2016. The icons on the dashboard come from Insert - Icons, which needs Microsoft 365, but any image will do instead.

If you want to know what's under the hood before you start: Excel Tables, data validation drop-down lists, Power Query to reshape and combine the data, PivotCharts, a PivotTable with calculated fields and calculated items, conditional formatting icons, and GETPIVOTDATA for the headline figures.

LEARN MORE
===========

πŸ“° EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy

πŸ’¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS
==============
0:00 What you can expect
0:37 Requirements & bonus
1:07 Creating lists of income and expenses
2:58 Preparing the budget
4:17 Recording actual spend
5:53 Recap and important information
6:28 How to gather and clean data
10:40 How to merge tables
13:18 How to analyze data & create report
25:40 Renaming PivotTables
26:07 Inserting a timeline slicer
27:37 Simplify data with this feature
29:08 Surplus or deficit

#PersonalBudget #BudgetTracker #ExcelTutorial
ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template)Build a Self-Updating Leaderboard in Excel (Free Template)Excel Tutorial for Beginners [Made Easy]From Excel to Power BI in 12 Minutes (Beginner Essentials)The Excel Functions for Dynamic Reports & Dashboards (File Included)Prepare Personalized WhatsApp Messages in ExcelExcel Expert Teaches Boss a Lesson!From Excel File to Mobile App in Under 10 Minutes | GlideBuild a Self-Updating Excel Invoice & Tracker (Free Template) | No Add-InsHow to Get Microsoft Excel for Free (Legally) in 2025Build an Excel Pricing Calculator with What-If Analysis (FREE Template)Pros Use This Technique to Avoid PivotTables
MyOnlineTrainingHub |

ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER