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

[@andrewgreen8804]

Your videos are absolutely excellent and very educational. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@karthiksai4534]

It's awesome explanation 😁 thank you so much

[@PKAnExcelExpert]

Most welcome🙏

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

[@Curic-Ivan]

Thank you for education, inspiration and ofc good work!

[@PKAnExcelExpert]

Thanks🙏

[@ssananda]

Tussi great ho Sir....Awesome

[@PKAnExcelExpert]

Thanks🙏

[@peymanrazmjoo-Th]

Many thanks for your valuable video

[@PKAnExcelExpert]

Most welcome🙏

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

[@rajesh-j1e8t]

dont miss this invaluable session!!!

[@pandharinathjoshi6565]

Superb sir, always beautiful your explanation sir

[@PKAnExcelExpert]

Thanks a ton

[@Khalid_iyad]

You are a legend

[@PKAnExcelExpert]

Thanks🙏

[@shilpakadam3725]

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

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

[@devenderkumar1220]

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

[@PKAnExcelExpert]

Thanks🙏

[@tutorials4065]

Wow that was awesome PK

[@PKAnExcelExpert]

Thanks

[@khingskaar]

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

[@ramkumarchourasia8030]

Excellent 👌
How will make in google sheet ??

[@PKAnExcelExpert]

Will upload soon

[@vikasthk786]

That is awesome knowledge and experience. It helped a lot

[@karthickravichandran1355]

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

[@PKAnExcelExpert]

More to come! Thanks

[@awadhbinamro948]

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

[@Buck2901]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@isaackudjo2799]

you are the best

[@PKAnExcelExpert]

Thanks🙏

[@zxcvbnicoleee]

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

[@denizcanminak]

need your help for prepare smt

[@PKAnExcelExpert]

Please email us at [e-mail]

[@pavan77711]

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

[@mcghanim]

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

[@PKAnExcelExpert]

You are most welcome

[@bhavneshparikh8283]

Can you add in Rm Sales man Product Customer

[@PKAnExcelExpert]

Will try to add in next version

[@bhavneshparikh8283]

@@PKAnExcelExpert also add zone region

[@hafizhussienelneelhassan5941]

Wonderful video ..thanks a lot for support.

[@PKAnExcelExpert]

Thanks and welcome

[@fanstfs7661]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Bengali_Medium_]

This is Amazing ❤️

[@PKAnExcelExpert]

Thanks

[@roggermolinabustamante7390]

You are practical and a¿easy

[@PKAnExcelExpert]

Thanks🙏

[@jgun0075]

Very nice and useful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@shabazrangrez2963]

Facing error creating the dashboard

[@padmakarlohatkar343]

Can we create same dashboard in PBi?

[@PKAnExcelExpert]

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

[@analyticsadda6080]

Request you to make some videos on power bi

[@PKAnExcelExpert]

We will try

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

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

very very beautiful💞🌹

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@md.fatemi2699]

Very Nice.

[@PKAnExcelExpert]

Many many thanks

[@hudsonserwanga]

How do you update your data

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

[@anilgorule235]

Very nice

[@PKAnExcelExpert]

Thanks

[@lalnisahu3079]

Can you send me data of this sales

[@rafaeldejesus8494]

Amazing

[@PKAnExcelExpert]

Thanks

[@zintajones6956]

Sir how to add multiple products with different prices?

[@mitulpatelful]

I have no download template for website

[@PKAnExcelExpert]

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

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

[@parajf]

please make finance statement in power bi

[@PKAnExcelExpert]

Will try

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

[@wrongturnlima007]

that was awesome

[@PKAnExcelExpert]

Thanks🙏

[@huseyinbakir2017]

thanks teacher

[@PKAnExcelExpert]

Most welcome

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

[@foodcity9875]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@pantherpride8143]

Need a YTD sales filter to see all

[@ahmadghaffar6213]

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

[@PKAnExcelExpert]

Will upload soon

[@brianbrian-on5yw]

Thanks

[@PKAnExcelExpert]

Most welcome

[@smuddin215]

yes i need thanks

[@prasad9976]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@rajsahu1029]

Nice.

[@PKAnExcelExpert]

Thanks

[@vipulkarde6973]

majestic

[@PKAnExcelExpert]

Thanks

[@Luciano_mp]

Very good man, beautiful. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@azli7772]

Wow😊

[@PKAnExcelExpert]

Thanks

[@saurabhdoha]

make some for health and safety dashboard

[@PKAnExcelExpert]

will try

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

[@lokeshmoolya5569]

Where is dataset of this?

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

[@simuislam5752]

Good

[@PKAnExcelExpert]

Thanks

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

[@sohaibkhan-om4fh]

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

[@RiyanshiKhatri-vm7xp]

Where is the data

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks

[@asavaripasalkar632]

Upload more power bi reports

[@PKAnExcelExpert]

sure

[@truongtu8734]

🥰😍

[@PKAnExcelExpert]

Thanks

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

Привет

[@MohammedYounas-kf7hu]

Teaching methods is so difficult

[@smailbacha4768]

👍

[@PKAnExcelExpert]

Thanks

[@amanluniya491]

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

[@sampathkanakatla5048]

It

[@tiendunggaming4443]

adasd

[@sampathkanakatla5048]

Zoom

[@Jamalhappy]

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