Create a budget vs actuals dashboard on Excel for variance analysis.
Sign up to The Daily Upside: [ Ссылка ]
🆓 DOWNLOAD Free Excel file for this video: [ Ссылка ]
📈 The Complete Finance & Valuation Course: [ Ссылка ]
In this video you'll learn how to build a dynamic budget vs actuals Excel dashboard from scratch. This type of model is also known as a variance analysis, where you can determine how much of a difference there is between your budget and your actual amounts. While we focus on a personal finance budget, this is also applicable to a company's internal budget.
To make this dynamic, we use data validation to select the month. Then, we use INDEX MATCH to find the budget for a specific month and line item, and SUMIFS to find the actuals for a specific month and line item.
In case you want to add more items to your actuals, you can do so using the actuals tab. Using the SUMIFS function, any new inputs should automatically be updated on the dashboard.
Lastly, to make the dashboard visually pleasing, we create conditional formatting for the variances using IF conditions, and column & pie charts for the visually comparing the difference.
To follow along, you can download the excel file for this video which contains the budget information, the actuals information, and the dashboard.
LEARN:
📈 The Complete Finance & Valuation Course: [ Ссылка ]
👉 Excel for Business & Finance Course: [ Ссылка ]
📊 Get 25% OFF Financial Edge Using Code KENJI25: [ Ссылка ]
📝 Investment Banking Recruiting Course: [ Ссылка ]
SOCIALS:
📸 Instagram - [ Ссылка ]
🤳 TikTok - [ Ссылка ]
GEAR:
📹 My Favorite Books & Gear: [ Ссылка ]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Building a dynamic model
7:54 - Variance Analysis
10:25 - Conditional Formatting
13:26 - Charts & Visuals
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Ещё видео!