Daily Sales Dashboard in Excel

[@Michael_Alaska]

Enjoyed your instruction. Especially the calendar setup. I find making shapes (top labels) using "merge shapes" in PowerPoint and copying over to Excel easier than trying to line everything up. Thanks.

[@PKAnExcelExpert]

Great tip! Thanks

[@nataliheaguilar3333]

Me encantan tus videos! Gracias PK!

[@PKAnExcelExpert]

Gracias por ver

[@karthiksai4534]

It's awesome explanation 😁 thank you so much

[@PKAnExcelExpert]

Most welcome🙏

[@peymanrazmjoo-Th]

Many thanks for your valuable video

[@PKAnExcelExpert]

Most welcome🙏

[@andrewgreen8804]

Your videos are absolutely excellent and very educational. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Curic-Ivan]

Thank you for education, inspiration and ofc good work!

[@PKAnExcelExpert]

Thanks🙏

[@ssananda]

Tussi great ho Sir....Awesome

[@PKAnExcelExpert]

Thanks🙏

[@pandharinathjoshi6565]

Superb sir, always beautiful your explanation sir

[@PKAnExcelExpert]

Thanks a ton

[@vikasthk786]

That is awesome knowledge and experience. It helped a lot

[@Khalid_iyad]

You are a legend

[@PKAnExcelExpert]

Thanks🙏

[@DewanMahesh]

Thank you PK Sir.. I learnt a lot of things which helps me daily. You have got a great skills. Have a wonderful day..

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@kevindurham8980]

Great tutorial. I really like the end-result. I ended up using a sales target tracker template I got from Someka though. It saved me tens of hours of work. Thank you for the video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shabazrangrez2963]

From where did you get the template

[@IndrajitKarmakar-b3w]

Really Awesome !! Love it

[@PKAnExcelExpert]

Thanks

[@mcghanim]

You make it very easy, Thank you, go ahead.

[@PKAnExcelExpert]

You are most welcome

[@isaackudjo2799]

you are the best

[@PKAnExcelExpert]

Thanks🙏

[@devenderkumar1220]

Very-2 Impressive and attractive chart...Love it...👍👍

[@PKAnExcelExpert]

Thanks🙏

[@hafizhussienelneelhassan5941]

Wonderful video ..thanks a lot for support.

[@PKAnExcelExpert]

Thanks and welcome

[@Buck2901]

Fantastic, buddy. Thanks for posting that, it's awesome.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@karthickravichandran1355]

Excellent... Very informative... Expect more dashboards 😎

[@PKAnExcelExpert]

More to come! Thanks

[@roggermolinabustamante7390]

You are practical and a¿easy

[@PKAnExcelExpert]

Thanks🙏

[@Bengali_Medium_]

This is Amazing ❤️

[@PKAnExcelExpert]

Thanks

[@rajesh-j1e8t]

dont miss this invaluable session!!!

[@jgun0075]

Very nice and useful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@العراقد-م7ش]

very very beautiful💞🌹

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@huseyinbakir2017]

thanks teacher

[@PKAnExcelExpert]

Most welcome

[@tutorials4065]

Wow that was awesome PK

[@PKAnExcelExpert]

Thanks

[@md.fatemi2699]

Very Nice.

[@PKAnExcelExpert]

Many many thanks

[@rafaeldejesus8494]

Amazing

[@PKAnExcelExpert]

Thanks

[@brianbrian-on5yw]

Thanks

[@PKAnExcelExpert]

Most welcome

[@anilgorule235]

Very nice

[@PKAnExcelExpert]

Thanks

[@foodcity9875]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@smuddin215]

yes i need thanks

[@shilpakadam3725]

Nicely explain. ..how to add this dashboard in ppt presentation?

[@analyticsadda6080]

Request you to make some videos on power bi

[@PKAnExcelExpert]

We will try

[@rajsahu1029]

Nice.

[@PKAnExcelExpert]

Thanks

[@wrongturnlima007]

that was awesome

[@PKAnExcelExpert]

Thanks🙏

[@azli7772]

Wow😊

[@PKAnExcelExpert]

Thanks

[@vipulkarde6973]

majestic

[@PKAnExcelExpert]

Thanks

[@ramkumarchourasia8030]

Excellent 👌
How will make in google sheet ??

[@PKAnExcelExpert]

Will upload soon

[@fanstfs7661]

A bit too fast for me..but it is very informative..tks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@zxcvbnicoleee]

This is veryhelpful, now how to change if I want to update the data every week or month like add new values

[@simuislam5752]

Good

[@PKAnExcelExpert]

Thanks

[@denizcanminak]

need your help for prepare smt

[@PKAnExcelExpert]

Please email us at [e-mail]

[@bhavneshparikh8283]

Can you add in Rm Sales man Product Customer

[@PKAnExcelExpert]

Will try to add in next version

[@bhavneshparikh8283]

@@PKAnExcelExpert also add zone region

[@prasad9976]

I always learn from you thank you. Sir make some videos on data modeling

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@lalnisahu3079]

Can you send me data of this sales

[@khingskaar]

I try this Mr. PK but the problem is when i update my daily data the dashboard is not working

[@Sanjay_Banik]

Can we change subtotal figure as per decimal. I have a master data. Where a project have 3 decimal should reflect. And for rest decimal not required. If I click Slicer, it shows either decimal or without decimal.

[@ahmadghaffar6213]

Awesome videos..... Plz make videos on Arrays Formula in excel CTRL +SHIFT +ENTER

[@PKAnExcelExpert]

Will upload soon

[@parajf]

please make finance statement in power bi

[@PKAnExcelExpert]

Will try

[@Luciano_mp]

Very good man, beautiful. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@awadhbinamro948]

thanks could you plz what do you mean by call in the secind column

[@greg10118]

Hi PK Sir, great tutorial! Need your advice. If I have to update the data tab on a daily/weekly basis, how should I go about it without having to redo the whole dashboard? Pls help

[@jeffagbor4362]

Try using power query to automatically transform your data from its source data. Whenever you make updates to your sources data, the transform data also gets updated

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks

[@shabazrangrez2963]

Facing error creating the dashboard

[@pantherpride8143]

Need a YTD sales filter to see all

[@pavan77711]

After creating round corner table and inserted properly into rect angle Group i con showing diabled after right click

[@padmakarlohatkar343]

Can we create same dashboard in PBi?

[@PKAnExcelExpert]

Yes we can. Will try to create a video on this

[@mitulpatelful]

I have no download template for website

[@PKAnExcelExpert]

Please visit below webpage to download
www.pk-anexcelexpert.com/daily-sales-dashboard-in-excel/

[@hudsonserwanga]

How do you update your data

[@RiyanshiKhatri-vm7xp]

How can i download it

[@PKAnExcelExpert]

Link is in the description box

[@TheSharanyaYoga]

@@PKAnExcelExpert UNABLE TO DOWNLOAD THE DATA...
WHERE EXACTLY IN THAT LINK?

[@saurabhdoha]

make some for health and safety dashboard

[@PKAnExcelExpert]

will try

[@jonisarowar8424]

How i will create this deshboard on google sheets. Please help me
Thanks

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@jonisarowar8424]

@@PKAnExcelExpert thanks a lot ❤️ i am wetting for your video

[@ajaychandel6807]

Hi Thanks
Your instructions are amazing but For the beginner, it's not effectively understood due to your high instruction fluency

[@PKAnExcelExpert]

Sorry for that. will take care for upcoming videos

[@zintajones6956]

Sir how to add multiple products with different prices?

[@lokeshmoolya5569]

Where is dataset of this?

[@truongtu8734]

🥰😍

[@PKAnExcelExpert]

Thanks

[@АлександрПашкевич-ь2х]

Привет

[@allinonewithaks9496]

Hi sir, can you pls make a video, how can I send excel reports multiple snapshot to whatsapp group

[@PKAnExcelExpert]

will try

[@allinonewithaks9496]

@@PKAnExcelExpert Thanks sir, I will be waiting

[@AshishPandey-de3wh]

how can we down load raw data?

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@smailbacha4768]

👍

[@PKAnExcelExpert]

Thanks

[@asavaripasalkar632]

Upload more power bi reports

[@PKAnExcelExpert]

sure

[@RiyanshiKhatri-vm7xp]

Where is the data

[@rajraj-oj3pb]

How can we add Year slicer.
Also, can you please help us with Sales dashboard for petrol pump.
Also, can we make chart type in the dashboard dynamic based on the data selected in the dashboard (change in slicer) example from pie chart to bar chart

[@sampathkanakatla5048]

It

[@MohammedYounas-kf7hu]

Teaching methods is so difficult

[@tiendunggaming4443]

adasd

[@sampathkanakatla5048]

Zoom

[@amanluniya491]

Faltuka vedio bada banaya he.. It should be easy and short

[@sohaibkhan-om4fh]

You should have given Font effect and portrait color that is secret of making impressive dashboard in Excel ever

[@Jamalhappy]

Sir..... Hindi ya urdu mai nai hai