How to create a Simple Dashboard Report in Microsoft Excel

How to create a Sales Dashboard Report in Microsoft Excel.
Download Sales data for creating the Dashboard report and the completed Dashboard itself.
rzp.io/l/MRBDh7yLF8
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#dashboard #exceldashboard #advancedexceltraining

[@aparnakrishna5551]

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

[@abdiwaliyakub8396]

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

[@mariamagandi3777]

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

[@rutendomunharira1867]

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

[@muhammedmuhajireen722]

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

[@emanuelmichael5295]

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

[@pratikshahegde7248]

Thankyou, grateful to have come across your video!

[@gunjan4004]

Thanks a ton for such a brief and simple explanation

[@jayabakshi4034]

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

[@exploringindiawithyash]

Bro, month wise sales data is not changing when clicking on slicer?

[@Ajay.Joshua]

Wow Crisp and clear 🎉

[@BharadwajGiridhar]

Very informative, thank you.

[@user-nq2bg7xi3k]

Very Easy and precise. Thanks a lot Sir

[@krunalzode5481]

Thank you Very easy to understand

[@nitinparkar]

Very nice and simple presentation

[@maajiumarmustapha]

Great work, making work look easy. Thanks.

[@SharonSmith]

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

[@AjayAnandXLnCAD]

Glad to hear that Sharon :)

[@MohammadEkram-hm9ug]

Thanks For Giving a demo for Practice

[@ImaobongUdoh-zb9cy]

great work

[@simonlukwago8179]

Thanks for the great work, this was really helpful

[@DL12able]

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

[@monaabdli7321]

thank you so much , it was great following your instructions

[@suckymidicky123]

Very Nice presentation simple and easy to understand! Thank you so much Anand!

[@prasuncdas]

Excellent job 👍👍👍

[@Vijay-1694]

Useful and Thanks Ajay!

[@santoshpoloju8003]

it is helping me in excel knowledge, thank you.

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

[@netsanetregassa7193]

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

[@AjayAnandXLnCAD]

My pleasure :)

[@rickcambayajr4332]

Thank you!

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

[@MohammedKhaleel-ln9dq]

Thanks Bro. ,You are the best

[@ravindharm3760]

Great videos bro impressed

[@SweetestGhada]

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

[@vishwareddy6129]

Good Explanation bro....

[@deepakannan1988]

Thanks a lot it was well explained

[@phonenow]

Most helpful video

[@eunicebaidoo8851]

It really helpful 😊😊🎉

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

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

[@deshan4018]

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

[@PradeepKumar-hd1ty]

Great video for me..

[@abmty3734]

Great one

[@gradimukwasa1386]

Bravo!!!

[@kamisoodaargekumsa314]

interesting session

[@ranjitha.p7599]

Thank you

[@sakshi966]

Very informative thank you ✨👍

[@amanbhargava2702]

Thanks

[@koshalneupane6150]

Supper 🎉❤

[@brettmeadway43]

thank you

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

[@user-sv8wn7uc9i]

Can we create 3 district pivot table and then use slicer

[@hemasrisai4547]

Nice thnx u

[@Interestingboy642]

I really love your video, where were you Sir, I subscribed liked loved it

[@phandongexcel]

I like this video and comment ❤❤❤❤

[@abhishekbhushan1052]

My financial year is April to March. Then how to arrange my data Qtr wise in dash board. Please guide me.

[@navarajam4866]

Sir please present latest style Updated Dashboards

[@deepanshikatiyar3854]

Couldn't update anything in the sheet pls share a downloadable form

[@gadilingappasirigeri758]

very nice awsome... you explained whole concept in simple way....🍉🍌

[@user-hg9jh6bz3p]

why month wise sales no connected?

[@menaka.r2294]

Can you send the source data

[@rinagandhi5609]

It's good but I wanted the recruitment dashboard

[@Maria-ju3kf]

Good video. I’m a beginner, can someone tell me the function to insert a date in excel, for example, I want to put in 1-1-2018 to December 2018 Thank you

[@AjayAnandXLnCAD]

Custom Formatting in Excel can be used for this requirement. Type in 1-1-2018 into a cell > Right-click on the cell > Format Cells > Select Custom from the Categories > type in mmmm yyyy into the input box under the label Type and click OK. The cell will display January 2018

[@anaghachaudhari2042]

I liked your video and I have paid for the data on razorpay. But still I haven't got the data? Can you send me the data??

[@AjayAnandXLnCAD]

Sure. Can you please tell me exactly what happened after payment?