Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Build Your Own Personal Budget Dashboard | Budget Spreadsheet | Personal Finance. That video is uploaded by Work Smarter Not Harder at 2020-12-19T07:00:31-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [mfPIx1whoAc]
| Name | Build Your Own Personal Budget Dashboard | Budget Spreadsheet | Personal Finance |
| Video Uploader | Video From Work Smarter Not Harder |
| Upload Date | This Video Uploaded At 19-12-2020 15:00:31 |
| Video Discription | ***MY #1 Selling Budget Template (NOT THE TEMPLATE IN THIS VIDEO)***** https://www.etsy.com/listing/1252378574/ This video, description This video will teach you how to build your own budget dashboard. This is part 2 of my Excel Budget Spreadsheet series. Even if you’ve never opened a spreadsheet before, I’ll walk you through how to build a personalized Budget Dashboard. Build it once and use it month after month and year after year. We’ll cover, briefly, how to create the log sheet (since this was covered in part 1). Then we’ll set up some progress bars, build a sweet pie graph that breaks down your expenses. We’ll also build some year to date charts that shows you how your trending month to month. Related Videos: · If you need to watch part 1 first: https://youtu.be/UAM1Ia5ZIp8 · If you don’t have Microsoft Excel, try my Google Sheets Budget Template (since Google sheets is free): https://www.youtube.com/watch?v=WRWg8mpIWpY Formulas in this video: · Step 1 Formula: =SUMIFS(Log!$G:$G, Log!$B:$B, Dashboard!C5, Log!$E:$E, Dashboard!$B9) · Step 2 Formula: =SUMIFS(Log!$G:$G, Log!$B:$B, Dashboard!C$3, Log!$E:$E, Dashboard!$B9) · Step 4 Formula: =SUMIFS(Log!$F:$F, Log!$B:$B, Dashboard!G$4, Log!$D:$D, Dashboard!$B5) · Step 5 Formula: =SUMIFS(Log!$G:$G, Log!$B:$B, Dashboard!G$4, Log!$E:$E, Dashboard!$B9) · Year Formula (Paste this after the first Comma in Cell C5, C9, G5, G9 – then drag down or across): Log!$A:$A, Dashboard!$B$3, Other Resources: If you are looking for pre-built, easy to use spreadsheets, try this link. There you can find cash flow planning, invoices, expense reports, personal budgets, and more! https://www.simplesheets.co/a/45451/ZWqXfVV9 Excel University: https://www.simplesheets.co/a/2147491676/ZWqXfVV9 Join my Facebook community: https://www.facebook.com/groups/344454936502236 #ExcelBudget #PersonalFinance #WorkSmarterNotHarder #BudgetSprl mfPIx1whoAc |
| Category | Howto & Style |
| Tags | Budget Spreadsheet | Budget Dashboard | Personal Finance | Microsft Excel | How to budget | Excel | Monthly Budget | Excel budget | Budgeting 101 | Personal Budget | Family Budget |
