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
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

![Excel Tutorial for Beginners [Made Easy]
β¬οΈ Download the example file here and follow along: https://bit.ly/beginner24file
π©βπ« Advanced Excel Formulas course: https://bit.ly/formulas24course
π©βπ« Excel Tables course: https://bit.ly/tables24course
Excel is the key to unlocking limitless opportunities. Itβs a skill that can elevate your career, manage your finances like a pro, and turn raw data into powerful insights. In this video, weβll cover everything from the basics right through to tools most Excel users never learn, which holds them back. Weβll start with navigating the interface, entering data, including some shortcuts, as well as formulas and functions, Formatting, including Conditional Formatting, Sorting & Filtering, Data Cleaning, Tables, Charts and PivotTables, and all in well under half an hour.
π Useful Excel materials mentioned in this video:
- Excel Shortcuts for Windows & Mac: https://youtu.be/TmzEOze_HHs
- How to Store Data the Right Way: https://youtu.be/CNlw1-Vh4cE
- PivotTable Tricks That Will Change the Way You Excel: https://youtu.be/187xEPVg1Gc
LEARN MORE
π° EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
β² TIMESTAMPS
0:00 What youre going to learn
0:47 Understanding the Excel interface
1:56 How to enter and navigate data
4:08 Every beginner needs to know this trick
4:40 How to create formulas and functions
6:20 Why & how to use $ (Dollar) sign in formulas
7:27 LIMITED OFFER
7:56 Simple & conditional formatting
10:03 How to sort & filter data
11:47 How to delete duplicates
12:21 Why you need to use Excel tables
14:34 LIMITED OFFER
14:47 Different types of charts and their purpose
17:37 One of the most useful Excel tools (PivotTables)
19:25 Slicers to filter PivotTable data
#Excel #ExcelTutorial #ExcelForBeginners Excel Tutorial for Beginners [Made Easy]](https://i.ytimg.com/vi/fzdn1vcHPsA/mqdefault.jpg)








