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🙏

[@Curic-Ivan]

Thank you for education, inspiration and ofc good work!

[@PKAnExcelExpert]

Thanks🙏

[@andrewgreen8804]

Your videos are absolutely excellent and very educational. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@IndrajitKarmakar-b3w]

Really Awesome !! Love it

[@PKAnExcelExpert]

Thanks

[@peymanrazmjoo-Th]

Many thanks for your valuable video

[@PKAnExcelExpert]

Most welcome🙏

[@vikasthk786]

That is awesome knowledge and experience. It helped a lot

[@Khalid_iyad]

You are a legend

[@PKAnExcelExpert]

Thanks🙏

[@ssananda]

Tussi great ho Sir....Awesome

[@PKAnExcelExpert]

Thanks🙏

[@rajesh-j1e8t]

dont miss this invaluable session!!!

[@pandharinathjoshi6565]

Superb sir, always beautiful your explanation sir

[@PKAnExcelExpert]

Thanks a ton

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

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

[@mcghanim]

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

[@PKAnExcelExpert]

You are most welcome

[@isaackudjo2799]

you are the best

[@PKAnExcelExpert]

Thanks🙏

[@Bengali_Medium_]

This is Amazing ❤️

[@PKAnExcelExpert]

Thanks

[@tutorials4065]

Wow that was awesome PK

[@PKAnExcelExpert]

Thanks

[@hafizhussienelneelhassan5941]

Wonderful video ..thanks a lot for support.

[@PKAnExcelExpert]

Thanks and welcome

[@roggermolinabustamante7390]

You are practical and a¿easy

[@PKAnExcelExpert]

Thanks🙏

[@shilpakadam3725]

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

[@RobBastien]

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

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

[@devenderkumar1220]

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

[@PKAnExcelExpert]

Thanks🙏

[@jgun0075]

Very nice and useful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@fanstfs7661]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

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

very very beautiful💞🌹

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@revenuemanagerharrisfxjaka6467]

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

[@md.fatemi2699]

Very Nice.

[@PKAnExcelExpert]

Many many thanks

[@karthickravichandran1355]

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

[@PKAnExcelExpert]

More to come! Thanks

[@smuddin215]

yes i need thanks

[@wrongturnlima007]

that was awesome

[@PKAnExcelExpert]

Thanks🙏

[@rafaeldejesus8494]

Amazing

[@PKAnExcelExpert]

Thanks

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

[@huseyinbakir2017]

thanks teacher

[@PKAnExcelExpert]

Most welcome

[@ramkumarchourasia8030]

Excellent 👌
How will make in google sheet ??

[@PKAnExcelExpert]

Will upload soon

[@bhavneshparikh8283]

Can you add in Rm Sales man Product Customer

[@PKAnExcelExpert]

Will try to add in next version

[@bhavneshparikh8283]

@@PKAnExcelExpert also add zone region

[@anilgorule235]

Very nice

[@PKAnExcelExpert]

Thanks

[@vipulkarde6973]

majestic

[@PKAnExcelExpert]

Thanks

[@analyticsadda6080]

Request you to make some videos on power bi

[@PKAnExcelExpert]

We will try

[@azli7772]

Wow😊

[@PKAnExcelExpert]

Thanks

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

[@rajsahu1029]

Nice.

[@PKAnExcelExpert]

Thanks

[@khingskaar]

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

[@brianbrian-on5yw]

Thanks

[@PKAnExcelExpert]

Most welcome

[@awadhbinamro948]

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

[@foodcity9875]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@pavan77711]

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

[@parajf]

please make finance statement in power bi

[@PKAnExcelExpert]

Will try

[@prasad9976]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Luciano_mp]

Very good man, beautiful. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@lalnisahu3079]

Can you send me data of this sales

[@ahmadghaffar6213]

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

[@PKAnExcelExpert]

Will upload soon

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

[@padmakarlohatkar343]

Can we create same dashboard in PBi?

[@PKAnExcelExpert]

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

[@simuislam5752]

Good

[@PKAnExcelExpert]

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

[@pantherpride8143]

Need a YTD sales filter to see all

[@saurabhdoha]

make some for health and safety dashboard

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

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

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks

[@shabazrangrez2963]

Facing error creating the dashboard

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

[@lokeshmoolya5569]

Where is dataset of this?

[@asavaripasalkar632]

Upload more power bi reports

[@PKAnExcelExpert]

sure

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

[@truongtu8734]

🥰😍

[@PKAnExcelExpert]

Thanks

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

Привет

[@RiyanshiKhatri-vm7xp]

Where is the data

[@smailbacha4768]

👍

[@PKAnExcelExpert]

Thanks

[@MohammedYounas-kf7hu]

Teaching methods is so difficult

[@sampathkanakatla5048]

It

[@sampathkanakatla5048]

Zoom

[@tiendunggaming4443]

adasd

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