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

  • @everydayexcel9278
    @everydayexcel92783 жыл бұрын

    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

    @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

    @jesseludenyo6436

    2 жыл бұрын

    camel analysis- finance

  • @catherineds9462
    @catherineds9462 Жыл бұрын

    Thank you for the detailed step-by-step tutorial. You explain everything very well.

  • @maroofkhan2087
    @maroofkhan20873 жыл бұрын

    Outstanding, Looking forward for more tutorials on dashboards. :)

  • @lukev730
    @lukev7303 жыл бұрын

    Amazing work bro Thank You for sharing

  • @farrukhjavaid1
    @farrukhjavaid13 жыл бұрын

    amazing.... keep up the good work

  • @rachidaidrissi2483
    @rachidaidrissi24834 жыл бұрын

    many thanks for this tutorial, it's very helpful

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    Glad it was helpful!

  • @lwshien
    @lwshien4 жыл бұрын

    Hey man, keep up the awesome work with the videos. Really enjoying it

  • @everydayexcel9278

    @everydayexcel9278

    4 жыл бұрын

    Thanks Iwshien! Appreciate the comment :)

  • @HeyItzMo95
    @HeyItzMo953 жыл бұрын

    Excellent video , I'm sure I'll be referring to this video loads when I am at work tomorrow. Thank you!

  • @everydayexcel9278

    @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.

  • @kch900
    @kch9003 жыл бұрын

    Many Thanks for your time and your efforts

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    Thank you for your kind comment! Glad you enjoyed it

  • @soloseven007
    @soloseven0073 жыл бұрын

    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

    @everydayexcel9278

    3 жыл бұрын

    Thanks for the positive feedback! Glad it helped :)

  • @moritzrichter2523
    @moritzrichter25233 жыл бұрын

    Top video!

  • @kfzar908
    @kfzar9082 жыл бұрын

    Great stuff mate 👌👍👏

  • @HiPh0Plover1
    @HiPh0Plover13 жыл бұрын

    Very talented as all investment bankers ^^ , thanks for your work and time

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    Thanks for the comment Happy Turtle!

  • @Ayuk1
    @Ayuk12 жыл бұрын

    Awesome content bro

  • @AdeKaryadi
    @AdeKaryadi3 жыл бұрын

    nice video, thanks

  • @lakshmipathiganesan6332
    @lakshmipathiganesan63323 жыл бұрын

    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

    @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/

  • @everydayexcel9278
    @everydayexcel92784 жыл бұрын

    Looking to increase your speed and efficiency in Excel as well? Check out my tips and tricks playlist here! kzread.info/head/PLLYSojxCGkt92mydfyt-mFUckTudnlbjn

  • @savvitasripati2976
    @savvitasripati29763 жыл бұрын

    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

    @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!

  • @RioDecz317
    @RioDecz3172 жыл бұрын

    do you have the raw data that i can use as dump file? Thanks

  • @CaptainNorthernMan
    @CaptainNorthernMan3 жыл бұрын

    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

    @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

    @CaptainNorthernMan

    3 жыл бұрын

    @@everydayexcel9278 yes they are - the boxes are checked in the report connections. It’s a little frustrating

  • @CaptainNorthernMan

    @CaptainNorthernMan

    3 жыл бұрын

    @@everydayexcel9278 what’s your email address?

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    @@CaptainNorthernMan it is everydayexcel365@gmail.com

  • @manaralabbar
    @manaralabbar3 жыл бұрын

    Can you provide me with the tamplate ? It will help alot! great lesson video thanks

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    Hi Manar, of course. Feel free to email me at everydayexcel365@gmail.com and I can send to you :)

  • @deathsquad1185
    @deathsquad11853 жыл бұрын

    Awesome video. Can you please share this dashboard with us?.

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    Hi there! of course. Feel free to email me at everydayexcel365@gmail.com and I can send to you :)

  • @shahmeer604
    @shahmeer6043 жыл бұрын

    you are God gifted, can you please email me your template to learn more about dashboard ?

  • @everydayexcel9278

    @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

  • @zaburamusa2924
    @zaburamusa2924 Жыл бұрын

    how can one get the csv files?

  • @arifzainurrohman9220
    @arifzainurrohman92203 жыл бұрын

    Awesome, an you share the dataset ?

  • @everydayexcel9278

    @everydayexcel9278

    3 жыл бұрын

    Hi Arif! Sure, please send me an email at everydayexcel365@gmail.com and I will send it to you :)

  • @stefantodorovikj6165
    @stefantodorovikj61652 жыл бұрын

    hi , is it possible to receive the document ? Thanks !

  • @everydayexcel9278

    @everydayexcel9278

    2 жыл бұрын

    Hi Stefan! Of course. Please send me an email at everydayexcel365@gmail.com and I can send it to you

  • @nirmaanshah1178
    @nirmaanshah1178 Жыл бұрын

    Great Dashboard! Can I get the template via email?

  • @niteshrawat1140
    @niteshrawat11403 жыл бұрын

    Is this normal excel ( version ???) Or power BI ???

  • @everydayexcel9278

    @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

  • @gregorycastillo4069
    @gregorycastillo40692 жыл бұрын

    Bro do you bring any personal orientation? How can I contact you?

  • @everydayexcel9278

    @everydayexcel9278

    2 жыл бұрын

    Hey bro, you can contact me on everydayexcel365@gmail.com

  • @ankitmishra7076
    @ankitmishra70762 жыл бұрын

    Awesome video. But I need the files so that i can work on them. Will You please send them?

  • @everydayexcel9278

    @everydayexcel9278

    2 жыл бұрын

    Hi Ankit, please send me an email on everydayexcel365@gmail.com and i can send it to you :)

  • @ankitmishra7076

    @ankitmishra7076

    2 жыл бұрын

    @@everydayexcel9278 Please check the mail

  • @everydayexcel9278

    @everydayexcel9278

    2 жыл бұрын

    @@ankitmishra7076 hi Ankit! Email has been sent to you

  • @kaderjuvanchi2692
    @kaderjuvanchi26922 жыл бұрын

    Link plz to download it

  • @everydayexcel9278

    @everydayexcel9278

    2 жыл бұрын

    Please send me an email and I can send to you :) everydayexcel365@gmail.com

  • @karimemam356
    @karimemam356 Жыл бұрын

    I sent you an email requesting this dashboard excel file with no response, would you please send me this file & thanks in advance