How to create a Simple Dashboard Report in Microsoft Excel

Поділитися
Вставка
  • Опубліковано 4 жов 2024

КОМЕНТАРІ • 190

  • @asifrahat985
    @asifrahat985 4 дні тому +2

    Great way to explain people . Must say you have a very smooth & clear voice to teach people about complex topics . Love to see more relevant videos. Keep it up..

  • @syedateequrrahman8401
    @syedateequrrahman8401 10 годин тому +2

    Very very beautifully explained , a layman can understand easily, many thanks for your wonderful explanation

  • @drdanishaliphysiotherapist
    @drdanishaliphysiotherapist 10 днів тому +1

    I have never seen any video like this in such a simple and easy way..❤❤❤❤

  • @russellmoss6487
    @russellmoss6487 2 місяці тому +25

    Hi. I am from Cape Town in South Africa. I am an "ageing accountant" and taught myself excel by trial and error. I loved your video on creating a dashboard. It will definitely assist me. Keep up the brilliant work!

    • @vrDIABLO-p9k
      @vrDIABLO-p9k 11 днів тому

      Hi did you manage to create one

  • @mabob12
    @mabob12 3 місяці тому +15

    One of the best tutorials in excel dashboard so far in UA-cam...

  • @deepaksinghrana6549
    @deepaksinghrana6549 8 днів тому

    Best Excel Dashboard tutorial video.

  • @abielkiflay3382
    @abielkiflay3382 6 днів тому

    Thank you !! you made it very straight forward, easy to follow. I really appreciate it.

  • @DhirajKumar-qi8uy
    @DhirajKumar-qi8uy 9 днів тому +1

    you are mind blowing Ajay ji ,,nice explanation

  • @Zilole111
    @Zilole111 Місяць тому +2

    Simply the best dashboard tutorial I have come across, awesome! Keep up the good work, Ajay.

  • @mariamagandi3777
    @mariamagandi3777 8 місяців тому +2

    You're one of the best UA-cam tutors I have encountered. Very precise, you make it look simple. Thank you

  • @awesomeviewdsa8735
    @awesomeviewdsa8735 3 місяці тому +1

    This is just an amazing with a clear crystal process flow.. God bless and thanks a ton for such wonderful video.

  • @Data_Mom
    @Data_Mom Рік тому +4

    Hi Ajay,
    Few suggestions:
    1) it's helpful to include currency in sales amount, this example refers to Sales amount in Rupees, so helpful to have Rs symbol in Sales Amount
    2) We can add Slicer's Reporting Connection to 'Sales by Months' pivot chart as well.
    Let me know your thoughts

    • @shaikhyaseen8322
      @shaikhyaseen8322 7 місяців тому

      Go to the number you will get option in last line of the series where you can turn currency in to Rupees

  • @OilfieldSchool
    @OilfieldSchool 2 місяці тому +2

    You are a legend! Keep going, and we will support you. You are the best

  • @beulahvijayan7668
    @beulahvijayan7668 6 днів тому

    Very very clear explanation🎉🎉

  • @maqsoodahmed8536
    @maqsoodahmed8536 Місяць тому +1

    Thanks brother, excellent and Simple to learn tutorial for dashboard creation

  • @SharonSmith
    @SharonSmith 11 місяців тому +5

    So many helpful tips and techniques in this tutorial, Ajay! Thanks for sharing it 😉

  • @netsanetregassa7193
    @netsanetregassa7193 11 місяців тому +4

    Thank you so much its very helpful and easy to understand!! Thank again!!

  • @praveenbhojan5022
    @praveenbhojan5022 3 місяці тому +1

    This video made me think creating dashboards is very easy 😉 Thanks for Ajay 👏👏

  • @divyabale3803
    @divyabale3803 Місяць тому

    Many thanks for making this video. Very informative and easy to learn.

  • @abdulrahim9378
    @abdulrahim9378 Місяць тому

    Thank you very much for sharing this Dashboard Ajay. It's very helpful for us.

  • @MrChetanmahi
    @MrChetanmahi 2 місяці тому

    Thankyou Ajay Anand, Superb explanation. Very easy to understand

  • @Silent_2880
    @Silent_2880 4 місяці тому

    It is my first time, I found making dashboard so easy!☺️

  • @emanuelmichael5295
    @emanuelmichael5295 9 місяців тому +1

    Many thanks Ajay for your simple elaboration on how to make dashboard 😊👏🤛

  • @SP-sg6ur
    @SP-sg6ur 2 місяці тому

    One of the amazing video on excel reports.

  • @HiraNaz-dd2kg
    @HiraNaz-dd2kg 6 днів тому

    Too much easy way. That's great

  • @ravinderprasad8791
    @ravinderprasad8791 Місяць тому

    You taught too much easy way. Thanks a lots

  • @sambath_2024
    @sambath_2024 26 днів тому

    Very excellent lesson I'm looking for!
    Thank you Sir!

  • @dipanjan2
    @dipanjan2 18 днів тому

    One of the best video I have seen and learnt also

  • @Ajay.Joshua
    @Ajay.Joshua 4 місяці тому +2

    Wow Crisp and clear 🎉

  • @muhammedmuhajireen722
    @muhammedmuhajireen722 7 місяців тому +1

    Simplified yet it was a very clear and meaningful explanation within a short time. Excellent brother. Thanks

  • @adv.roshanj.jamdare9343
    @adv.roshanj.jamdare9343 Місяць тому

    Best Tut video so far I have come across ❤

  • @abdiwaliyakub8396
    @abdiwaliyakub8396 4 місяці тому

    Great work, you made things easy for everyone to understand keep the good work.

  • @annaidu583
    @annaidu583 2 місяці тому

    very nice video and good and easy steps to learn excellent and keep it up the video creation u are excellent knowledgable person , iam retd mechanicle engineer no age limit for learning 💯👌

  • @aparnakrishna5551
    @aparnakrishna5551 4 місяці тому

    Thank you so much sir!!! excellent and well simplified presentation sir !!!!

  • @thiyakup7333
    @thiyakup7333 7 днів тому

    Very useful , thank you so much

  • @IS14875
    @IS14875 2 місяці тому

    Excellent! Thanks for sharing the most valuable video.

  • @DL12able
    @DL12able 9 місяців тому

    Thank you Ajay, you don't know how it is helpfull a lot for me🙏

  • @trendyjukebox6313
    @trendyjukebox6313 26 днів тому

    Excellent video,respect your work.

  • @SweetestGhada
    @SweetestGhada 10 місяців тому +1

    Thank you very much ajad ...but plz can you explain how i can daily add new data and update my dashboard data daily ?

  • @HiraNaz-dd2kg
    @HiraNaz-dd2kg Місяць тому

    You taught too much easy way. 😊

  • @samudrasribulathgama5249
    @samudrasribulathgama5249 20 днів тому

    Superb. Very simple way to lot. Tks

  • @punchgravity
    @punchgravity Місяць тому

    Thank you for share this video... its really helpful

  • @jmakaza2936
    @jmakaza2936 2 місяці тому +1

    thank u easy and direct amazing

  • @asadpasha5554
    @asadpasha5554 4 місяці тому

    Dear thanks for a such informative video ,I just want to learn that ,
    after calculating business growth in pivot table in % ,how can we add it in dashboard in form of % in graph or column..

  • @rutendomunharira1867
    @rutendomunharira1867 6 місяців тому

    Well simplified. You're the best Tutor I have encountered.

  • @FashionandStyle-il5jc
    @FashionandStyle-il5jc Місяць тому

    Very helpful content and awesome way to teach

  • @EvansEnibe
    @EvansEnibe 6 місяців тому

    Very Easy and precise. Thanks a lot Sir

  • @ram9699
    @ram9699 3 місяці тому

    very nice explanation, really appreciated

  • @nitinparkar
    @nitinparkar Рік тому +1

    Very nice and simple presentation

  • @anilkshirsagar-lx8ei
    @anilkshirsagar-lx8ei Місяць тому +2

    can i get raw data .

  • @MNOrio
    @MNOrio Місяць тому

    You are an excellent tutor

  • @SatyajitDasWorship
    @SatyajitDasWorship 24 дні тому

    This really helped me. Thanks a lot

  • @chandbashask8275
    @chandbashask8275 Рік тому

    Thanks for the video i would like to suggest you one thing is that slicer is not connected monthly sales pivot chart /pivot table. Bye the way i follow your channel for excel. your explained as a pro faculty.

  • @DipanjanDas-h8m
    @DipanjanDas-h8m 18 днів тому

    Hi
    Great learning from this session

  • @ashishlad9582
    @ashishlad9582 Місяць тому

    Excellent teaching👍🏻

  • @krunalzode5481
    @krunalzode5481 4 місяці тому

    Thank you
    Very easy to understand

  • @Interestingboy642
    @Interestingboy642 10 місяців тому

    After failing in phone interview, bec I never worked on Dashboard before in excel, interviewer asked, do u know dashboard, I told I have worked on Charts and Graphs in but not on Dashboard, then I searched on UA-cam your video, it's really amazing, after watching this video should I add Dashboard in my CV or not or still a lot to learn about Dashboard please guide

  • @santoshpoloju8003
    @santoshpoloju8003 Рік тому

    it is helping me in excel knowledge, thank you.

  • @navinmohanasundaram6236
    @navinmohanasundaram6236 13 днів тому

    Best tutorial thanks 👍

  • @lakshmit128
    @lakshmit128 18 днів тому

    Hi, useful tips. Thank u so much

  • @monaabdli7321
    @monaabdli7321 9 місяців тому

    thank you so much , it was great following your instructions

  • @atulpatel3693
    @atulpatel3693 Місяць тому

    Greatly explained

  • @njilembebianiscel6920
    @njilembebianiscel6920 7 днів тому

    Very useful sir thks

  • @MohammadEkram-hm9ug
    @MohammadEkram-hm9ug Рік тому

    Thanks For Giving a demo for Practice

  • @shoaibahmed9504
    @shoaibahmed9504 22 дні тому

    simple and awesome bro

  • @am-lr3rd
    @am-lr3rd 2 місяці тому

    Very nicely explained

  • @kumarajaysingh1863
    @kumarajaysingh1863 2 місяці тому

    It is something I was searching for.❤

  • @jsandeep01
    @jsandeep01 4 місяці тому

    Thanks a ton Ajay 😊

  • @ShahabMehsud-jg8jn
    @ShahabMehsud-jg8jn 2 місяці тому

    Excellent Tutorial

  • @GMServiceFordUniqueauto
    @GMServiceFordUniqueauto 3 місяці тому

    Good to understand, its easy.

  • @akashnalwade252
    @akashnalwade252 2 місяці тому

    Very nice sir...very informative video..❤

  • @mohandeshinge4375
    @mohandeshinge4375 Місяць тому

    Very informative. Great work.

  • @noorshaikh1247
    @noorshaikh1247 Місяць тому

    Nice the way you explain

  • @shitalchaudhari4383
    @shitalchaudhari4383 2 місяці тому

    Nice tutorial. Thanks for sharing

  • @vishalghule7033
    @vishalghule7033 2 місяці тому

    Very informative session

  • @AnkitRathore-et4py
    @AnkitRathore-et4py 3 місяці тому

    Awesome.. Very easy and helpfull

  • @lingavignesh5911
    @lingavignesh5911 2 місяці тому +1

    Smooth 👌 thank you...😊

  • @simonlukwago8179
    @simonlukwago8179 9 місяців тому

    Thanks for the great work, this was really helpful

  • @deepakannan1988
    @deepakannan1988 6 місяців тому

    Thanks a lot it was well explained

  • @MohammedKhaleel-ln9dq
    @MohammedKhaleel-ln9dq 6 місяців тому

    Thanks Bro. ,You are the best

  • @maajiumarmustapha
    @maajiumarmustapha 8 місяців тому

    Great work, making work look easy. Thanks.

  • @rajput7452
    @rajput7452 4 місяці тому

    THANK YOU VERY MUCH..

  • @BharadwajGiridhar
    @BharadwajGiridhar Рік тому +1

    Very informative, thank you.

  • @jinu911
    @jinu911 24 дні тому

    Super.... Thanks!

  • @Foodie_till_end
    @Foodie_till_end 2 місяці тому

    Thankyou brother 👏🏻

  • @TarunKumar-ey6rb
    @TarunKumar-ey6rb Місяць тому

    Sir make videos prapartion of BBs in Ms Excel

  • @gunjan4004
    @gunjan4004 8 місяців тому

    Thanks a ton for such a brief and simple explanation

  • @armyvhinyle
    @armyvhinyle Місяць тому

    nice.this will help me a lot

  • @Karansamal11
    @Karansamal11 3 місяці тому

    dataset for sale..wah nice

  • @danishamir786
    @danishamir786 3 місяці тому

    Awesome, Thank you Bro

  • @prasuncdas
    @prasuncdas 4 місяці тому

    Excellent job 👍👍👍

  • @jiwanadevi1717
    @jiwanadevi1717 Місяць тому

    Excellent

  • @mihirmukundthakar6853
    @mihirmukundthakar6853 Місяць тому

    Excellent Video

  • @Vijay-1694
    @Vijay-1694 4 місяці тому

    Useful and Thanks Ajay!

  • @rushirajkamblerk
    @rushirajkamblerk 2 місяці тому

    Very informative videos

  • @pratikshahegde7248
    @pratikshahegde7248 5 місяців тому

    Thankyou, grateful to have come across your video!

  • @phonenow
    @phonenow Рік тому +1

    Most helpful video

  • @rashmithakare7224
    @rashmithakare7224 3 місяці тому

    Can u please share any full project for data visualisation with excel , sql

  • @menaka.r2294
    @menaka.r2294 6 місяців тому +3

    Can you send the source data

  • @jayabakshi4034
    @jayabakshi4034 10 місяців тому

    This ine was really simple to understand. The dashboard looks beautiful too. Thank you . I am gonna try this one now😊