Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Build a Dynamic Personal Finance Budget Tracker in 15 minutes. That video is uploaded by Kenji Explains at 2022-10-30T08:45:02-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [M5ycCUUhCvM]
| Name | Build a Dynamic Personal Finance Budget Tracker in 15 minutes |
| Video Uploader | Video From Kenji Explains |
| Upload Date | This Video Uploaded At 30-10-2022 15:45:02 |
| Video Discription | Create an interactive Budget Tracker on Excel in 15 minutes ๐ Take our Finance & Valuation Course here: https://www.careerprinciples.com/courses/finance-valuation-course ๐ DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/635e9c988b3fedce67d0995f In this video you'll learn to make a personal finance budget tracker so you can keep your finances in check. Step 1 is to set up the inputs tab, where you'll add all your income and expenses. These include your salary, rent, groceries and more. Step 2 is to make the dashboard dynamic using the SUMIF's formula. With this you'll be able to see a monthly breakdown for all your expense and income categories. In step 3 you'll work on the visuals which include conditional formatting and charting. The conditinal formatting will be for positive and negative percentage changes, while the charting will be for creating two pie charts giving us the breakdown of expense and income categories. LEARN: ๐ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course ๐ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance ๐ All our courses: https://www.careerprinciples.com/courses ๐ Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS SOCIALS: ๐ธ Instagram - https://www.instagram.com/careerprinciples/?hl=en ๐คณ TikTok - https://www.tiktok.com/@career_principles ๐งโ๐ป LinkedIn - https://www.linkedin.com/company/careerprinciples/ GEAR: ๐น My Favorite Books & Gear: https://kit.co/kenjiexplains โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ Chapters: 0:00โ -โ Step 1: Income and Expense Inputs 2:00โ - Step 2: Setting up the Dashboard 8:52โ - Step 3: The Visuals Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you. M5ycCUUhCvM |
| Category | Education |
| Tags | budget tracker | budgetting | personal finance budget | variance analysis | budget analysis | budget tracker on excel | excel budget tracker | track your budget on excel | excel budget | excel budgeting | automated budget on excel | excel budget analysis | excel variance analysis | annual budget | 2023 budget | 2022 budget | budgetting for the new year | budget dashboard | p&l dashboard | profit and loss dashboard | budget vs actuals | budget vs actuals forecast | revenue forecast |
