How to create a Simple Dashboard Report in Microsoft Excel

[@russellmoss6487]

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]

Hi did you manage to create one

[@hidayahbashirdayyib443]

Very straightforward and clear

[@mabob12]

One of the best tutorials in excel dashboard so far in KZbin...

[@maheshkamble4778]

❤

[@SharonSmith]

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

[@AjayAnandXLnCAD]

Glad to hear that Sharon :)

[@asifrahat985]

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

[@pramilat24]

Omg...I have created it for the first time...never got a mentor like u...the method u were teaching just awesome....beginners can also learn easily....thanks to ur teaching skill...😊

[@Zilole111]

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

[@Data_Mom]

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]

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

[@abielkiflay3382]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@OilfieldSchool]

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

[@syedateequrrahman8401]

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

[@netsanetregassa7193]

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

[@AjayAnandXLnCAD]

My pleasure :)

[@drdanishaliphysiotherapist]

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

[@averilnazareth9041]

Love the way you teach... It makes things so simple even though complex

[@Vairagi_108]

Fantastic bro..... Loved it.....

[@emanuelmichael5295]

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

[@vaishnavichandrasekar6277]

Great explanation step by step Ajay. Really helpful and thanks for sharing it!!

[@mlightfoot2367]

This was very helpful, very easy to follow. I was able to create a dashboard for a project I was leading using your video. Great job!

[@deepaksinghrana6549]

Best Excel Dashboard tutorial video.

[@maqsoodahmed8536]

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

[@mariamagandi3777]

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

[@Ajay.Joshua]

Wow Crisp and clear 🎉

[@TheBestMrSam]

Very great and easy to follow explanation. Good job bro 👏

[@DhirajKumar-qi8uy]

you are mind blowing Ajay ji ,,nice explanation

[@awesomeviewdsa8735]

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

[@bikashmook100]

Fantastic dashboard creation. Thank you

[@prasadrathnayake3554]

Thanks Ajay.. l learned so many tips..😊😊🎉🎉🎉

[@adv.roshanj.jamdare9343]

Best Tut video so far I have come across ❤

[@divyabale3803]

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

[@abdulrahim9378]

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

[@arun4846]

Very Well Explained❤❤❤Superb❤❤❤

[@AjayAnandXLnCAD]

Glad you liked it😀

[@SweetestGhada]

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

[@menaka.r2294]

Can you send the source data

[@pravinmore1823]

Thanks Sir for very informative video.

[@Archana-k3q]

Wonderful tutorial! Thanks. One i have one question. Will the dashboard update as when when new values are added?

[@asarwaribit]

Very nicely explained with a reasonable speed. Can we keep adding more data into sheet or pivot table and dashboard will take that data into the different graphs or dashboard will be automatically updated.

[@SP-sg6ur]

One of the amazing video on excel reports.

[@trendyjukebox6313]

Excellent video,respect your work.

[@DL12able]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@dipanjan2]

One of the best video I have seen and learnt also

[@ravinderprasad8791]

You taught too much easy way. Thanks a lots

[@AjayAnandXLnCAD]

My pleasure 😀

[@EvansEnibe]

Very Easy and precise. Thanks a lot Sir

[@IS14875]

Excellent! Thanks for sharing the most valuable video.

[@MrChetanmahi]

Thankyou Ajay Anand, Superb explanation. Very easy to understand

[@infoworld7564]

Smart teaching❤easy learning

[@beulahvijayan7668]

Very very clear explanation🎉🎉

[@samudrasribulathgama5249]

Superb. Very simple way to lot. Tks

[@praveenbhojan5022]

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

[@mohandeshinge4375]

Very informative. Great work.

[@thiyakup7333]

Very useful , thank you so much

[@AjayAnandXLnCAD]

My pleasure 😀

[@aparnakrishna5551]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@nitinparkar]

Very nice and simple presentation

[@maajiumarmustapha]

Great work, making work look easy. Thanks.

[@SatyajitDasWorship]

This really helped me. Thanks a lot

[@ashishlad9582]

Excellent teaching👍🏻

[@lakshmit128]

Hi, useful tips. Thank u so much

[@asadpasha5554]

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

[@kumarajaysingh1863]

It is something I was searching for.❤

[@MNOrio]

You are an excellent tutor

[@akankshabadgujar6323]

Very helpful!

[@Silent_2880]

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

[@DipanjanDas-h8m]

Hi Great learning from this session

[@albertoderioh7912]

Great work

[@AnkitRathore-et4py]

Awesome.. Very easy and helpfull

[@shoaibahmed9504]

simple and awesome bro

[@atulpatel3693]

Greatly explained

[@HiraNaz-dd2kg]

Too much easy way. That's great

[@navinmohanasundaram6236]

Best tutorial thanks 👍

[@Interestingboy642]

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 KZbin 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

[@rangaranga5427]

@ajay I have separate small table categories. I want main table pivot slicer list to have this independent data. This is static list or table . Any idea how to?

[@abdiwaliyakub8396]

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

[@ram9699]

very nice explanation, really appreciated

[@akashnalwade252]

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

[@am-lr3rd]

Very nicely explained

[@HiraNaz-dd2kg]

You taught too much easy way. 😊

[@vishalghule7033]

Very informative session

[@deshan4018]

Hi, can the charts in the dashboard be imported to powerpoint? This includes the Slicer.

[@shitalchaudhari4383]

Nice tutorial. Thanks for sharing

[@jmakaza2936]

thank u easy and direct amazing

[@Vijay-1694]

Useful and Thanks Ajay!

[@simonlukwago8179]

Thanks for the great work, this was really helpful

[@GMServiceFordUniqueauto]

Good to understand, its easy.

[@punchgravity]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@lingavignesh5911]

Smooth 👌 thank you...😊

[@AjayAnandXLnCAD]

My pleasure 😀

[@prasuncdas]

Excellent job 👍👍👍

[@krunalzode5481]

Thank you Very easy to understand

[@AjayAnandXLnCAD]

My pleasure 😀

[@muhammedmuhajireen722]

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

[@mihirmukundthakar6853]

Excellent Video

[@danishamir786]

Awesome, Thank you Bro

[@AjayAnandXLnCAD]

My pleasure 😀

[@ShahabMehsud-jg8jn]

Excellent Tutorial

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

[@santoshpoloju8003]

it is helping me in excel knowledge, thank you.

[@rushirajkamblerk]

Very informative videos

[@rashmithakare7224]

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

[@deepakannan1988]

Thanks a lot it was well explained

[@eunicebaidoo8851]

It really helpful 😊😊🎉

[@monaabdli7321]

thank you so much , it was great following your instructions

[@AjayAnandXLnCAD]

My pleasure 😀

[@annaidu583]

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 💯👌

[@noorshaikh1247]

Nice the way you explain

[@sun-riseshetty556]

Superb sir.