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

[@zxcvbnicoleee]

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

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

[@user-tv1pw7qj9x]

dont miss this invaluable session!!!

[@Khalid_iyad]

You are a legend

[@PKAnExcelExpert]

Thanks🙏

[@peymanrazmjoo-Th]

Many thanks for your valuable video

[@PKAnExcelExpert]

Most welcome🙏

[@Curic-Ivan]

Thank you for education, inspiration and ofc good work!

[@PKAnExcelExpert]

Thanks🙏

[@ssananda]

Tussi great ho Sir....Awesome

[@PKAnExcelExpert]

Thanks🙏

[@nataliheaguilar3333]

Me encantan tus videos! Gracias PK!

[@PKAnExcelExpert]

Gracias por ver

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

[@pandharinathjoshi6565]

Superb sir, always beautiful your explanation sir

[@PKAnExcelExpert]

Thanks a ton

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

[@isaackudjo2799]

you are the best

[@PKAnExcelExpert]

Thanks🙏

[@mcghanim]

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

[@PKAnExcelExpert]

You are most welcome

[@Bengali_Medium_]

This is Amazing ❤️

[@PKAnExcelExpert]

Thanks

[@fanstfs7661]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@shilpakadam3725]

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

[@rafaeldejesus8494]

Amazing

[@PKAnExcelExpert]

Thanks

[@brianbrian-on5yw]

Thanks

[@PKAnExcelExpert]

Most welcome

[@roggermolinabustamante7390]

You are practical and a¿easy

[@PKAnExcelExpert]

Thanks🙏

[@md.fatemi2699]

Very Nice.

[@PKAnExcelExpert]

Many many thanks

[@hafizhussienelneelhassan5941]

Wonderful video ..thanks a lot for support.

[@PKAnExcelExpert]

Thanks and welcome

[@tutorials4065]

Wow that was awesome PK

[@PKAnExcelExpert]

Thanks

[@jgun0075]

Very nice and useful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@user-uq1bh7ho8b]

very very beautiful💞🌹

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@devenderkumar1220]

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

[@PKAnExcelExpert]

Thanks🙏

[@huseyinbakir2017]

thanks teacher

[@PKAnExcelExpert]

Most welcome

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@anilgorule235]

Very nice

[@PKAnExcelExpert]

Thanks

[@karthickravichandran1355]

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

[@PKAnExcelExpert]

More to come! Thanks

[@RobBastien]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@vipulkarde6973]

majestic

[@PKAnExcelExpert]

Thanks

[@prasad9976]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@wrongturnlima007]

that was awesome

[@PKAnExcelExpert]

Thanks🙏

[@pavan77711]

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

[@Luciano_mp]

Very good man, beautiful. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@rajsahu1029]

Nice.

[@PKAnExcelExpert]

Thanks

[@foodcity9875]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@analyticsadda6080]

Request you to make some videos on power bi

[@PKAnExcelExpert]

We will try

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

[@revenuemanagerharrisfxjaka6467]

excellent content, please advise if I would like create the daily sales by day in the dashboard?

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

[@azli7772]

Wow😊

[@PKAnExcelExpert]

Thanks

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

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

[@pantherpride8143]

Need a YTD sales filter to see all

[@simuislam5752]

Good

[@PKAnExcelExpert]

Thanks

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks

[@awadhbinamro948]

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

[@ramkumarchourasia8030]

Excellent 👌 How will make in google sheet ??

[@PKAnExcelExpert]

Will upload soon

[@shabazrangrez2963]

Facing error creating the dashboard

[@bhavneshparikh8283]

Can you add in Rm Sales man Product Customer

[@PKAnExcelExpert]

Will try to add in next version

[@bhavneshparikh8283]

@@PKAnExcelExpert also add zone region

[@saurabhdoha]

make some for health and safety dashboard

[@PKAnExcelExpert]

will try

[@zintajones6956]

Sir how to add multiple products with different prices?

[@hudsonserwanga]

How do you update your data

[@padmakarlohatkar343]

Can we create same dashboard in PBi?

[@PKAnExcelExpert]

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

[@RiyanshiKhatri-vm7xp]

How can i download it

[@PKAnExcelExpert]

Link is in the description box

[@sampathkanakatla5048]

It

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

[@RiyanshiKhatri-vm7xp]

Where is the data

[@asavaripasalkar632]

Upload more power bi reports

[@PKAnExcelExpert]

sure

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

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

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

[@truongtu8734]

🥰😍

[@PKAnExcelExpert]

Thanks

[@user-ed2xk1qy7d]

Привет

[@smailbacha4768]

👍

[@PKAnExcelExpert]

Thanks

[@sampathkanakatla5048]

Zoom

[@MohammedYounas-kf7hu]

Teaching methods is so difficult

[@tiendunggaming4443]

adasd

[@amanluniya491]

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

[@Jamalhappy]

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

[@mitulpatelful]

I have no download template for website

[@PKAnExcelExpert]

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