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

[@mabob12]

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

[@Silent_2880]

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

[@Ajay.Joshua]

Wow Crisp and clear 🎉

[@emanuelmichael5295]

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

[@jayabakshi4034]

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

[@nitinparkar]

Very nice and simple presentation

[@BharadwajGiridhar]

Very informative, thank you.

[@user-nq2bg7xi3k]

Very Easy and precise. Thanks a lot Sir

[@MohammadEkram-hm9ug]

Thanks For Giving a demo for Practice

[@aparnakrishna5551]

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

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

[@krunalzode5481]

Thank you Very easy to understand

[@abdiwaliyakub8396]

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

[@DL12able]

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

[@maajiumarmustapha]

Great work, making work look easy. Thanks.

[@simonlukwago8179]

Thanks for the great work, this was really helpful

[@anbhuvenkat]

super tutorials video

[@santoshpoloju8003]

it is helping me in excel knowledge, thank you.

[@mariamagandi3777]

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

[@SharonSmith]

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

[@AjayAnandXLnCAD]

Glad to hear that Sharon :)

[@netsanetregassa7193]

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

[@AjayAnandXLnCAD]

My pleasure :)

[@jsandeep01]

Thanks a ton Ajay 😊

[@prasuncdas]

Excellent job 👍👍👍

[@ravindharm3760]

Great videos bro impressed

[@Vijay-1694]

Useful and Thanks Ajay!

[@MohammedKhaleel-ln9dq]

Thanks Bro. ,You are the best

[@deepakannan1988]

Thanks a lot it was well explained

[@vishwareddy6129]

Good Explanation bro....

[@rickcambayajr4332]

Thank you!

[@rajput7452]

THANK YOU VERY MUCH..

[@muhammedmuhajireen722]

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

[@rutendomunharira1867]

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

[@phonenow]

Most helpful video

[@ImaobongUdoh-zb9cy]

great work

[@eunicebaidoo8851]

It really helpful 😊😊🎉

[@ravikumar-vz5eh]

super sir .thankyou

[@gunjan4004]

Thanks a ton for such a brief and simple explanation

[@PradeepKumar-hd1ty]

Great video for me..

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

[@kamisoodaargekumsa314]

interesting session

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

[@gradimukwasa1386]

Bravo!!!

[@abmty3734]

Great one

[@ranjitha.p7599]

Thank you

[@pratikshahegde7248]

Thankyou, grateful to have come across your video!

[@SweetestGhada]

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

[@hemasrisai4547]

Nice thnx u

[@syedghouri3441]

awesome

[@amanbhargava2702]

Thanks

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

[@brettmeadway43]

thank you

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

[@Interestingboy642]

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

[@sakshi966]

Very informative thank you ✨👍

[@koshalneupane6150]

Supper 🎉❤

[@phandongexcel]

I like this video and comment ❤❤❤❤

[@user-sv8wn7uc9i]

Can we create 3 district pivot table and then use slicer

[@gadilingappasirigeri758]

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

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

[@navarajam4866]

Sir please present latest style Updated Dashboards

[@abhishekbhushan1052]

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

[@deepanshikatiyar3854]

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

[@menaka.r2294]

Can you send the source data

[@user-hg9jh6bz3p]

why month wise sales no connected?

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

[@megharajput430]

Thanku sir... it's very helpful for me...I created my first dashboard..☺️👍

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

[@exploringindiawithyash]

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