How to create modern Excel dashboards for financial models | Microsoft Excel tutorial
In this tutorial video I will walk you through the steps to create an impressive, modern, and interactive dashboard in Microsoft Excel that you can bolt on to any type of financial model you are building using the same principles I have applied.
Excel should be fun and creative, so why not watch this and learn something new. Whether you are a beginner or an expert, there are things in this video for all different user levels and I’m sure everyone will learn something you can apply to your own work lives. So, have a watch and upskill yourself so you can impress your boss or colleagues! And share this with anyone that may also benefit from watching.
Please leave questions or comments below if you have any, and if you have ideas for future videos you would like to see I would love to hear them!
Intro music: www.bensound.com
Пікірлер: 72
What type of Dashboard would you like to see next? Let me know by replying to this comment and I will create a video on your topic!
@mustafahayriacikgoz6265
3 жыл бұрын
hi, can you share the data which you use to create dashboard. because we can follow you up more detail if we try to do same things the same data, and keep doing such wonderfull things
@jesseludenyo6436
2 жыл бұрын
camel analysis- finance
Thank you for the detailed step-by-step tutorial. You explain everything very well.
Outstanding, Looking forward for more tutorials on dashboards. :)
Amazing work bro Thank You for sharing
amazing.... keep up the good work
many thanks for this tutorial, it's very helpful
@everydayexcel9278
3 жыл бұрын
Glad it was helpful!
Hey man, keep up the awesome work with the videos. Really enjoying it
@everydayexcel9278
4 жыл бұрын
Thanks Iwshien! Appreciate the comment :)
Excellent video , I'm sure I'll be referring to this video loads when I am at work tomorrow. Thank you!
@everydayexcel9278
3 жыл бұрын
Thank you! Don’t forget to subscribe as well. If there is anything else you’d like in a video let me know and I can pull together.
Many Thanks for your time and your efforts
@everydayexcel9278
3 жыл бұрын
Thank you for your kind comment! Glad you enjoyed it
Beautiful work and awesome dashboard tutorial. You've solved all the issues I've been having with the design of my dashboard. Thank you very much. Never stop and keep making awesome videos. Your skills are extraordinary. It will take you to top.
@everydayexcel9278
3 жыл бұрын
Thanks for the positive feedback! Glad it helped :)
Top video!
Great stuff mate 👌👍👏
Very talented as all investment bankers ^^ , thanks for your work and time
@everydayexcel9278
3 жыл бұрын
Thanks for the comment Happy Turtle!
Awesome content bro
nice video, thanks
Awesome Dashboard and thanks for sharing. Probably, you could have explained on the Dashboard colours (both background and on the charts) from where you picked
@everydayexcel9278
3 жыл бұрын
Hi Lakshmipathi! Thanks for the comment and I am glad you enjoyed it :) I think I googled some different colour palettes and choose this one as I liked the shades of blue. Check out this link for some examples digitalsynopsis.com/design/beautiful-color-palettes-combinations-schemes/
Looking to increase your speed and efficiency in Excel as well? Check out my tips and tricks playlist here! kzread.info/head/PLLYSojxCGkt92mydfyt-mFUckTudnlbjn
Many thanks for this tutorial. Can you please mention how did you link the live output data of fin.Stat. with this data table, is there any combination of transpose and paste special (Ref: at 3:06min).
@everydayexcel9278
3 жыл бұрын
Hi Savvita, I usually use an index match to pull through the live information from my source. There are a few different ways you can do it however, so find something that works best for you. Unfortunately I have not found one easy way to pull everything through so it can take a few minutes to set up, but once done it is good to go!
do you have the raw data that i can use as dump file? Thanks
Thanks. I have been doing something similar with slices. Unfortunately, I lose the formatting on my graph when I select different things on my slicers. I make the graph look great then say I select a different date the graphs shows in its default colours but if I go back to the date I did the formatting on the graph it shows correctly. Is their a way to apply the same formatting to the graph no matter what I press on the slicer?
@everydayexcel9278
3 жыл бұрын
Sorry to hear Ryan, I am unsure why this might be happening without seeing it. Are all your report connections set up to different tables? Feel free to email me and I can help further
@CaptainNorthernMan
3 жыл бұрын
@@everydayexcel9278 yes they are - the boxes are checked in the report connections. It’s a little frustrating
@CaptainNorthernMan
3 жыл бұрын
@@everydayexcel9278 what’s your email address?
@everydayexcel9278
3 жыл бұрын
@@CaptainNorthernMan it is everydayexcel365@gmail.com
Can you provide me with the tamplate ? It will help alot! great lesson video thanks
@everydayexcel9278
3 жыл бұрын
Hi Manar, of course. Feel free to email me at everydayexcel365@gmail.com and I can send to you :)
Awesome video. Can you please share this dashboard with us?.
@everydayexcel9278
3 жыл бұрын
Hi there! of course. Feel free to email me at everydayexcel365@gmail.com and I can send to you :)
you are God gifted, can you please email me your template to learn more about dashboard ?
@everydayexcel9278
3 жыл бұрын
Hi Shah Meer, thanks for your comment! Of course. Please email me at everydayexcel365@gmail.com and I will send it to you
how can one get the csv files?
Awesome, an you share the dataset ?
@everydayexcel9278
3 жыл бұрын
Hi Arif! Sure, please send me an email at everydayexcel365@gmail.com and I will send it to you :)
hi , is it possible to receive the document ? Thanks !
@everydayexcel9278
2 жыл бұрын
Hi Stefan! Of course. Please send me an email at everydayexcel365@gmail.com and I can send it to you
Great Dashboard! Can I get the template via email?
Is this normal excel ( version ???) Or power BI ???
@everydayexcel9278
3 жыл бұрын
Hi Nitesh! This is all normal Excel :) you can do this! Be sure to watch along and you will see all the steps
Bro do you bring any personal orientation? How can I contact you?
@everydayexcel9278
2 жыл бұрын
Hey bro, you can contact me on everydayexcel365@gmail.com
Awesome video. But I need the files so that i can work on them. Will You please send them?
@everydayexcel9278
2 жыл бұрын
Hi Ankit, please send me an email on everydayexcel365@gmail.com and i can send it to you :)
@ankitmishra7076
2 жыл бұрын
@@everydayexcel9278 Please check the mail
@everydayexcel9278
2 жыл бұрын
@@ankitmishra7076 hi Ankit! Email has been sent to you
Link plz to download it
@everydayexcel9278
2 жыл бұрын
Please send me an email and I can send to you :) everydayexcel365@gmail.com
I sent you an email requesting this dashboard excel file with no response, would you please send me this file & thanks in advance