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!

[@blk_Trump]

Hi did you manage to create one

[@yusryfrizlar3261]

I am from Cape Town, South Africa, I am an “aging engineer” - and will use this excellent video to create my personalised Dashboard!

[@SharonSmith]

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

[@AjayAnandXLnCAD]

Glad to hear that Sharon :)

[@sangeeta8959]

I saw too many vdos on creating dashboard but urs one is amazing. Must say it was smooth and clear instruction, not many instruction.

[@mabob12]

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

[@maheshkamble4778]

❤

[@parmeshwarishah6929]

The way you teach is amazing!! Thank you for the content, keep them coming!!

[@OilfieldSchool]

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

[@pushpakmistry3005]

Thank you very much for making such an informative and knowledge-sharing video on Excel work.

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

[@mariamagandi3777]

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

[@syedateequrrahman8401]

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

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

[@netsanetregassa7193]

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

[@AjayAnandXLnCAD]

My pleasure :)

[@Ajay.Joshua]

Wow Crisp and clear 🎉

[@sowmiyasree4248]

Hello Ajay, wonderful explanation and it is easy to learn and pleasing to hear your lecture. Keep it up.

[@phandongexcel]

I like this video and comment ❤❤❤❤

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

[@abielkiflay3382]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@maqsoodahmed8536]

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

[@emanuelmichael5295]

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

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

[@thebesttechnical3608]

The best excel tutorial. Straight to the point!

[@deepalipatange1880]

Thank you, precise and very well explained 👏

[@averilnazareth9041]

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

[@awesomeviewdsa8735]

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

[@jemimahernandez7995]

Loved your video, best video ive seen so far

[@vaishnavichandrasekar6277]

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

[@menaka.r2294]

Can you send the source data

[@drdanishaliphysiotherapist]

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

[@rrdjrahul]

Amazing bro... Keep it up and thanks for such a wonderful explanation

[@rambabudasari2110]

superb dettailed explained

[@purnimak4073]

one of the best tutorial.. it will definitely help me .. great work

[@SweetestGhada]

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

[@DhirajKumar-qi8uy]

you are mind blowing Ajay ji ,,nice explanation

[@arun4846]

Very Well Explained❤❤❤Superb❤❤❤

[@AjayAnandXLnCAD]

Glad you liked it😀

[@ravinderprasad8791]

You taught too much easy way. Thanks a lots

[@AjayAnandXLnCAD]

My pleasure 😀

[@TheBestMrSam]

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

[@bikashmook100]

Fantastic dashboard creation. Thank you

[@DL12able]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@sgsrikanth]

Is it possible to create dashboard with multiple reports. If yes can you teach us

[@gaganpaaji13]

Very well explained, easy and simple

[@Raw_videoss]

Bro, Seriously this is the most useful video for me in my life❤🎉

[@ManishGupta-ng7mk]

Awesome video . Thanks

[@adv.roshanj.jamdare9343]

Best Tut video so far I have come across ❤

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

[@hidayahbashirdayyib443]

Very straightforward and clear

[@divyabale3803]

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

[@EvansEnibe]

Very Easy and precise. Thanks a lot Sir

[@MDNASIR-vm2gp]

Excellent explanation. 😊

[@deepaksinghrana6549]

Best Excel Dashboard tutorial video.

[@getachewhailu9859]

Really Nice training thank you

[@praveenbhojan5022]

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

[@thiyakup7333]

Very useful , thank you so much

[@AjayAnandXLnCAD]

My pleasure 😀

[@Vairagi_108]

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

[@dipanjan2]

One of the best video I have seen and learnt also

[@Foodie_till_end]

Thankyou brother 👏🏻

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

[@prabhakarrawat8879]

To the point and easy to understand

[@deshan4018]

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

[@santoshanandgupta3784]

Superb man, you were amazing.😀

[@abdulrahim9378]

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

[@arunmanu1980]

Superb bro....thank you...

[@lingavignesh5911]

Smooth 👌 thank you...😊

[@AjayAnandXLnCAD]

My pleasure 😀

[@ErusappanRagupathi]

Sir thanks lot for your. video. Last month wise chart not linked sir

[@MrChetanmahi]

Thankyou Ajay Anand, Superb explanation. Very easy to understand

[@beulahvijayan7668]

Very very clear explanation🎉🎉

[@aparnakrishna5551]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@pravinmore1823]

Thanks Sir for very informative video.

[@prasadrathnayake3554]

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

[@albertoderioh7912]

Great work

[@abdirisaqahmedegal5655]

thank you for your sharing Excell Dashboards

[@nitinparkar]

Very nice and simple presentation

[@trendyjukebox6313]

Excellent video,respect your work.

[@eunicebaidoo8851]

It really helpful 😊😊🎉

[@SatyajitDasWorship]

This really helped me. Thanks a lot

[@mohandeshinge4375]

Very informative. Great work.

[@maajiumarmustapha]

Great work, making work look easy. Thanks.

[@akankshabadgujar6323]

Very helpful!

[@khalidbukhari3261]

How to put Grand total in the Pivot chart? Please advise

[@navinmohanasundaram6236]

Best tutorial thanks 👍

[@DipanjanDas-h8m]

Hi Great learning from this session

[@JinshadMuhammed-u3r]

Sooo good ❤

[@infoworld7564]

Smart teaching❤easy learning

[@ravikumartantry]

Good video easy to understand

[@ashishlad9582]

Excellent teaching👍🏻

[@apkashubchintak-e5c]

Can we create 3 district pivot table and then use slicer

[@samudrasribulathgama5249]

Superb. Very simple way to lot. Tks

[@SP-sg6ur]

One of the amazing video on excel reports.

[@lakshmit128]

Hi, useful tips. Thank u so much

[@atulpatel3693]

Greatly explained

[@danishamir786]

Awesome, Thank you Bro

[@AjayAnandXLnCAD]

My pleasure 😀

[@IS14875]

Excellent! Thanks for sharing the most valuable video.

[@shoaibahmed9504]

simple and awesome bro

[@akashnalwade252]

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

[@HiraNaz-dd2kg]

You taught too much easy way. 😊

[@deepakannan1988]

Thanks a lot it was well explained

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

[@MAYYABABA]

Month wise sales were not connected to slicer