Make an automated budget tracker in Excel in just 15 minutes.
🚀Get the FREE Data Analytics Guide from Hubspot: https://clickhubspot.com/kgv
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/j31axx067d
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 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/all-courses
In this step-by-step tutorial you'll learn to make a personal finance dashboard from scratch in Excel in just 15 minutes. This can be used to track your finances such as your expenses, your income, or your savings. As the dashboard is fully dynamic, as soon as you enter a new transaction it will be added to the dashboard. To automate the dashboard, we use Excel tables, text formulas, SUMIFS, Date formulas, and more.
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:42 - Adding Entries
4:48 - Personal Finance Dashboard
10:15 - Category Breakdown
12:38 - Summary Numbers