Daily Sales Dashboard in Excel

#SalesDashboard #ExcelDashboard
Hello Friends,
In this video, you will learn how to create a daily Sales Dashboard in Excel. We have explained how to create custom stylish for a slicer and for a Pivot table.
Download the practice file from the below link:
www.pk-anexcelexpert.com/dail...
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

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

[@andrewgreen8804]

Your videos are absolutely excellent and very educational. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@user-tv1pw7qj9x]

dont miss this invaluable session!!!

[@nataliheaguilar3333]

Me encantan tus videos! Gracias PK!

[@PKAnExcelExpert]

Gracias por ver

[@karthickravichandran1355]

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

[@PKAnExcelExpert]

More to come! Thanks

[@devenderkumar1220]

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

[@PKAnExcelExpert]

Thanks🙏

[@RobBastien]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@mcghanim]

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

[@PKAnExcelExpert]

You are most welcome

[@peymanrazmjoo-Th]

Many thanks for your valuable video

[@PKAnExcelExpert]

Most welcome🙏

[@brianbrian-on5yw]

Thanks

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

[@FraIvan]

Thank you for education, inspiration and ofc good work!

[@PKAnExcelExpert]

Thanks🙏

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

[@hafizhussienelneelhassan5941]

Wonderful video ..thanks a lot for support.

[@PKAnExcelExpert]

Thanks and welcome

[@karthiksai4534]

It's awesome explanation 😁 thank you so much

[@PKAnExcelExpert]

Most welcome🙏

[@Luciano_mp]

Very good man, beautiful. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@tutorials4065]

Wow that was awesome PK

[@PKAnExcelExpert]

Thanks

[@jgun0075]

Very nice and useful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ssananda]

Tussi great ho Sir....Awesome

[@PKAnExcelExpert]

Thanks🙏

[@revenuemanagerharrisfxjaka6467]

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

[@Khalid_iyad]

You are a legend

[@PKAnExcelExpert]

Thanks🙏

[@user-uq1bh7ho8b]

very very beautiful💞🌹

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@huseyinbakir2017]

thanks teacher

[@PKAnExcelExpert]

Most welcome

[@azli7772]

Wow😊

[@PKAnExcelExpert]

Thanks

[@isaackudjo2799]

you are the best

[@PKAnExcelExpert]

Thanks🙏

[@wrongturnlima007]

that was awesome

[@PKAnExcelExpert]

Thanks🙏

[@vipulkarde6973]

majestic

[@PKAnExcelExpert]

Thanks

[@roggermolinabustamante7390]

You are practical and a¿easy

[@PKAnExcelExpert]

Thanks🙏

[@md.fatemi2699]

Very Nice.

[@PKAnExcelExpert]

Many many thanks

[@Bengali_Medium_]

This is Amazing ❤️

[@PKAnExcelExpert]

Thanks

[@ahmadghaffar6213]

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

[@PKAnExcelExpert]

Will upload soon

[@rajsahu1029]

Nice.

[@PKAnExcelExpert]

Thanks

[@rafaeldejesus8494]

Amazing

[@PKAnExcelExpert]

Thanks

[@anilgorule235]

Very nice

[@PKAnExcelExpert]

Thanks

[@awadhbinamro948]

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

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks

[@prasad9976]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

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

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

[@foodcity9875]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@pavan77711]

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

[@fanstfs7661]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@simuislam5752]

Good

[@PKAnExcelExpert]

Thanks

[@zintajones6956]

Sir how to add multiple products with different prices?

[@truongtu8734]

🥰😍

[@PKAnExcelExpert]

Thanks

[@user-ed2xk1qy7d]

Привет

[@parajf]

please make finance statement in power bi

[@PKAnExcelExpert]

Will try

[@hudsonserwanga]

How do you update your data

[@pantherpride8143]

Need a YTD sales filter to see all

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

[@shabazrangrez2963]

Facing error creating 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

[@saurabhdoha]

make some for health and safety dashboard

[@PKAnExcelExpert]

will try

[@bhavneshparikh8283]

Can you add in Rm Sales man Product Customer

[@PKAnExcelExpert]

Will try to add in next version

[@bhavneshparikh8283]

@@PKAnExcelExpert also add zone region

[@ramkumarchourasia8030]

Excellent 👌
How will make in google sheet ??

[@PKAnExcelExpert]

Will upload soon

[@padmakarlohatkar343]

Can we create same dashboard in PBi?

[@PKAnExcelExpert]

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

[@lokeshmoolya5569]

Where is dataset of this?

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

[@smailbacha4768]

👍

[@PKAnExcelExpert]

Thanks

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

[@asavaripasalkar632]

Upload more power bi reports

[@PKAnExcelExpert]

sure

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

[@sampathkanakatla5048]

It

[@tiendunggaming4443]

adasd

[@sampathkanakatla5048]

Zoom

[@MohammedYounas-kf7hu]

Teaching methods is so difficult

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