How to Create a Personal Budget Dashboard in Excel | Step-by-Step Tutorial

  Рет қаралды 18,786

Skillify

Skillify

Күн бұрын

Пікірлер
@SkillifyExplains
@SkillifyExplains Ай бұрын
Thanks for watching! Let me know in the comments if you have any questions or suggestions for future tutorials. Don’t forget to subscribe for more Excel content!
@AshleyMartinez-cy1qo
@AshleyMartinez-cy1qo Күн бұрын
Hello thank you for the I depth tutorial. I just got done making this for myself and I love it. I am somewhat confused about the highest expenses section in the dashboard. I used the exact formulas in your tutorial however it keeps showing the incorrect highest expenses name with a different actual expense amount. I went back and looked at yours and it has the same issue. How can this formula be fixed to show the correct names and amounts?
@steffanyrodrigues757
@steffanyrodrigues757 Ай бұрын
Thank you very helpful! Now I can do it! Finally a channel that teaches from the beginning !
@SkillifyExplains
@SkillifyExplains Ай бұрын
Glad that you liked it!
@dereksylar1416
@dereksylar1416 29 күн бұрын
All time I searched on KZbin but couldn’t find finally someone explaining all
@SkillifyExplains
@SkillifyExplains 28 күн бұрын
Thanks, Stay Tuned!
@AshleyMartinez-cy1qo
@AshleyMartinez-cy1qo Күн бұрын
Hello thank you for the I depth tutorial. I just got done making this for myself and I love it. I am somewhat confused about the highest expenses section in the dashboard. I used the exact formulas in your tutorial however it keeps showing the incorrect highest expenses section name with the actual expense.
@SkillifyExplains
@SkillifyExplains 13 сағат бұрын
Make sure that you use the option (sort) to sort them based on the value, it exists in the video!
@AshleyMartinez-cy1qo
@AshleyMartinez-cy1qo 42 минут бұрын
@@SkillifyExplains I went back and looked at the video and I did not see the sort option being used. I tried experimenting with it and I was not able to fix the issue. Not only am I having this issue in the highest expense section of the dashboard but I am also having this issue in the budget data section. I noticed both of the sections in your video had the same issue. In the budget data section it has the correct name and budget for the highest expenses however the actual section does not correlate with the name. I think the issue is the actual section is correlating the largest expense amount with the largest budget amount. I am not sure how to fix it 😞
@michaelsolomon6033
@michaelsolomon6033 10 күн бұрын
Will definitely check this out
@kadakreir2707
@kadakreir2707 3 күн бұрын
C'est moi le 600 abonné a votre chaîne 🎉
@mahmoudyasser-l4z
@mahmoudyasser-l4z Ай бұрын
thank you so much for that video, I learnt things from the formulas you used, and Can you make another video with different design in the way to be darker colors and different design?
@SkillifyExplains
@SkillifyExplains Ай бұрын
Thanks, I will add that to my ideas!
@monzuralam9862
@monzuralam9862 17 сағат бұрын
Could you please share this excel for practice?
@SkillifyExplains
@SkillifyExplains 13 сағат бұрын
There is no free template for this sheet, in a previous video on my channel there is another video with a free template! Here is the link: kzbin.info/www/bejne/g6Wsl2OeaK-thc0
@user-ow8ov9cp4b
@user-ow8ov9cp4b 10 күн бұрын
Do you have the template for this kind of personal budget that you've made? May i have the link please?
@SkillifyExplains
@SkillifyExplains 9 күн бұрын
There is no free template for this sheet, in a previous video on my channel there is another video with a free template! Here is the link: kzbin.info/www/bejne/g6Wsl2OeaK-thc0
@abdibasitfarah7459
@abdibasitfarah7459 7 сағат бұрын
Can you make this file downloadable, or can u send me please?
@adhityaoctavianus6223
@adhityaoctavianus6223 Күн бұрын
is it also working on google sheets?
@SkillifyExplains
@SkillifyExplains Күн бұрын
It will work but not totally because excel is more advanced about the customisations of the advanced dashboards.
@athirakv7182
@athirakv7182 Ай бұрын
Could you please share the sample excel for practice?
@SkillifyExplains
@SkillifyExplains Ай бұрын
Take a look about the previous video, it has the data i used here
@ragulmarley4900
@ragulmarley4900 6 күн бұрын
Data set link 😊
@SkillifyExplains
@SkillifyExplains 6 күн бұрын
There is no free template for this sheet, in a previous video on my channel there is another video with a free template! Here is the link: kzbin.info/www/bejne/g6Wsl2OeaK-thc0
@bhavneshparikh8283
@bhavneshparikh8283 28 күн бұрын
How to downalod file?
@SkillifyExplains
@SkillifyExplains 28 күн бұрын
Check the previous video if you want a template!
@bhavneshparikh8283
@bhavneshparikh8283 28 күн бұрын
@SkillifyExplains already check but can not download excel file
Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)
18:57
MyOnlineTrainingHub
Рет қаралды 157 М.
How to Create Pivot Table in Excel
20:49
Kevin Stratvert
Рет қаралды 1,4 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
How Strong Is Tape?
00:24
Stokes Twins
Рет қаралды 96 МЛН
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 363 М.
The One Simple Budgeting Method That Changed My Life
13:53
Humphrey Yang
Рет қаралды 264 М.
Make an Awesome Excel Dashboard in Just 15 Minutes
15:27
Kenji Explains
Рет қаралды 1,4 МЛН
Excel Pivot Tables from scratch to an expert for half an hour + dashboard!
34:55
Билял Хасенов – Excel, VBA & More
Рет қаралды 2,2 МЛН
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,7 МЛН
How To Build Your Own Budget in Google Sheets | GOOGLE SHEETS DEMO/TUTORIAL
26:34
Personal Finance with Leila - Debt Over It
Рет қаралды 285 М.
VLOOKUP in Excel | Tutorial for Beginners
32:09
Kevin Stratvert
Рет қаралды 2,1 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 1 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19