Create Dynamic Sales Dashboard in Excel | With Voiceover

[@harismansoor3584]

Thankyou soo much for the help. I just completed my Assigment and created my 1st Dynamic Sales Dashboard with your step by step guide. I'm soo much happy that i created my 1st ever Dashboard. 🙂🙂🙂

[@IrshadAhmed-uf8lt]

it was amazing journey of making a dash board from the scratch. the language was simple and effective with clarity. Of course some basic knowledge about the pivot table and other formatting stuff is mandatory to prepare the dash board. It was awesome experience and I truly enjoyed it. I will try to create one myself soon. Thanks buddy.

[@FinTechy]

Thanks for your kind words! I'm glad you enjoyed the journey and learned something new.

[@thebesttechnical3608]

Thats awesome, It always amazes me how creative people are. Always finding new ways to display info.

[@FinTechy]

I'm glad you liked it! I love finding new ways to visualize data.

[@IanOseiWalker-f8z]

Very Powerful Show of Excel Knowledge. Thank You.

[@FinTechy]

Grateful for your feedback! Excited to share more soon.

[@starX7995]

this is the best excel dashboard for any beginner out there just complete it.

[@FinTechy]

Thank you so much! I'm glad you find it helpful for beginners.

[@muraliiyer7850]

Superb presentation - Crisp and clear. Good show.

[@СергейКондулуков-з9ч]

Очень хороший урок. Вся кухня создания дашборда показана от начала и до конца. Всё дело в срезах :-)

[@MuhammadRafi-hq6pl]

Amazing job Fin techy.

[@FinTechy]

I'm glad you enjoyed it. Thanks!

[@ragulmarley4900]

Good one do more video like this really helpful for us 🎉

[@FinTechy]

Thank you very much! I'll create more helpful videos like this. If you have topics you'd like covered, let me know.

[@priscillangambi5805]

I loved the exercise. Thanks

[@Wanderlust.Venturer]

Great work ,really appreciate

[@FinTechy]

Thank you so much for your kind words! If you have any suggestions for future topics or any questions, feel free to let me know. Your feedback is invaluable!

[@jafetgonzaga9581]

Hi, I'm new to making in excel. How can you copy the scrollbar and bargraph? I didn't see what your next step.

[@keerthi-nf9kk]

By default it is disabled need to enable by right click any where on the screen and search for customize the ribbon and on right side enable developer click okay

[@agnaldodjive1673]

You just helped me a lot. great tutorial, thanks for sharing.

[@RajeshAcharya-em7qk]

Thanks for this Share. Very easy to understand and practice.

[@FinTechy]

You're welcome! I'm glad you found it easy to understand and practice.

[@jyotirmoybairagya4776]

Sir, I really appreciate it and gain lots of knowledge please please share this main data sheet for utilisation 🎉

[@FinTechy]

Thank you for your kind words! I'm glad you found the video helpful. Absolutely, I've included the dataset in the description section for you to utilize. Let me know if you have any other questions or need further assistance!

[@kalpanamagar2160]

Excellent tutorial👌🏻👌🏻

[@mohamadadhikasuryahaidar7652]

Can you share the excel file for exercise? thanks in advance.

[@FinTechy]

Absolutely! You can find the excel database in the description section of the video.

[@MustafaAli-yi2xu]

Amazing Amazing Amazing bro.. keep up the good work.. your explanation is worth outstanding.

[@FinTechy]

Grateful for your feedback! Excited to share more soon.

[@dudeyme3331]

wow i also prepared according to the video nice

[@FinTechy]

That's wonderful, thank you!

[@nnishadhussain]

Very nice explanation... i have a query, is there any option to create in slicer, if we click the button it should get highlighted in different color till we click other button

[@Rabbani_World_Flock]

I'm lucky I got it❤🎉🎉 subscriber number 74😂 growing

[@FinTechy]

Thank you very much :)

[@userfriendly801]

I am facing a zero pourcentage on profit margin using a pivot table. What did I do?

[@AJAYKUMAR-j3d7n]

Agar do raw data sheet h, one is warranty return qty and other one is sales qty. Then ek hi dashboard m link kiya ja skta h kya??

[@TanvirAhmed-t1d]

Sir i need this excell sheet. How i get from you. ❤️

[@FinTechy]

You can download the Excel Dashboard database file from the video description section.

[@SandeshPawar-r2o]

Wow just amazing…. Last doubt. How can we connect Sunburst to all data set? Thanks a lot for such a brilliant visualisation 😊

[@FinTechy]

Thank you so much for the kind words! To connect a Sunburst chart to your entire dataset, you can use a hierarchical structure in your data.

[@a_mhite2]

@@FinTechy How can we enable this hierarchical structure in our data? Can you please give us the steps? Because Sunburst chart is not getting change after clicking on slicers.

[@olayisadeadewole]

How can i get the dataset file used ?

[@FinTechy]

You can find the Excel file in the video description section.

[@dustyarcher]

Great video and info thank you! Dusty

[@tristadas7266]

Not able to get the top products total sale thing could pls anybody can help me out

[@deepeshsrivastava9274]

This is amazing... Can I get the dataset file please? Also waiting for more informative content

[@chinwe6341]

Amazing Stuff. Thank you for attaching the data.

[@FinTechy]

Thanks! I'm happy to hear you found the tutorial useful.

[@austinmarvellous2127]

On 21:16 outside my first cust_id_001 to 005 the rest are showing invalid

[@mandeepverma-j4h]

just type the formula and press together CTRL+SHIFT+ENTER ..it will give CUST_ID_01 then drag down.

[@fathiann]

@@mandeepverma-j4h thanks, it works!

[@ramana628]

How does the past values table is stnc with Slicera?? In this dashboard trechart is not syncing with slicers

[@mohammadharun2831]

Thank you very much

[@DeepakBesoya-g8b]

How did you do offset - $Y$1. Unable to do that, it only shows cell value, please help

[@manojkumaryaram3210]

Yes , I'm also Facing Same Issue Kindly Requesting Please Help to this Issue

[@NS90100]

After entering the formula don't press on enter. Press control+shift+enter it will work please try

[@NS90100]

​@@manojkumaryaram3210please try

[@pranjalpatel6927]

I am facing Issue in OFFSET function. It is showing error in it.What to do??😢😢

[@MujahedMerghani]

amazing explanation but why you start work in PowerPoint

[@hemaraghu5202]

Really thank you so much

[@wendysmith1453]

Thanks for the video, can you share the file so I can follow along, please.

[@FinTechy]

Certainly! I'm happy that you found the video helpful. I've included the file in the description section for you to download and follow along. Let me know if you encounter any issues.

[@kelompokpurbalingga_gugusw4388]

what kind data that you use in this video sir?

[@FinTechy]

I used sample sales data, including fields like product, customer, sales, units sold etc. You can download the Excel Dashboard database file from the video description section.

[@Mainulmunna]

Can i get it?

[@FinTechy]

You can download the Excel Dashboard database file from the video description section.

[@KoolGuyism]

How to create a reconciliation dashboard indicating how many breaks are there , how many are resolved and so on?

[@binaykumar1616]

Very Nice.... thanks

[@niroshawarnasooriya4850]

At 8.43 min, as discussed in video, can't get the link even give the formula.. it is due to text box ?

[@nagmanaikwadi-iy4pe]

Thank you very much sir

[@francisjunius8013]

Please how do i get sql file you uploaded in the video

[@FinTechy]

You can download the Excel Dashboard database file from the video description section.

[@konikamridha]

Sir plz help,,,, i can not proper use in slicer,,,sir Report connecting korte giye only 1 pivote tabel show kortace,,,,

[@JaanviJha_TheAllRounder]

I am getting VALUE error when i am scrolling, first 5 data are coming perfectly in offset but for rest getting value error. Can you please help me on this. Thank you

[@mandeepverma-j4h]

just drag right side

[@irshadmurad]

Nicely Done

[@FinTechy]

Thank you!

[@hafizkamran1774]

How to add new data in the same Dashboard? Like if we want to add next month data in the same dashboard

[@claudiesoondar3577]

Great Dashboard, thanks. Can you create a Construction Project Dashboard

[@FinTechy]

Thank you so much! I’m glad you liked it.

[@faisalqureshi9440]

File will not updated because pivot table whats the solution?

[@cumwithme100]

I copied and pasted both scroll bar and chart to the Dashboard, but the Chart is not dynamic even though the scroll bar works

[@prajwalprajwalhegde8558]

sir can u send the excel pdf to practice

[@FinTechy]

You can download the Excel Dashboard database file from the video description section.

[@mohammedbelattar8212]

Thanks for this great work. Will you please share this dashboard !! (The data file is already shared . Thanks again)

[@josephcalano8878]

Are you doing personal tutoring?

[@FinTechy]

I haven’t started live classes yet, but I’m planning to offer them in the future, including advanced Excel training. I’ll announce it on my channel once I have the classes ready.

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@FinTechy]

You're welcome!

[@khushinigam5442]

The value is not changing while scrolling. It keeps showing the error. Kindly help.

[@Prathmesh_jadhav96]

You have to connect scrolling bar to that the 1st cell which we have created … you can refer 20:05 from here and watch carefully

[@mandeepverma-j4h]

just type the formula and press together CTRL+SHIFT+ENTER ..it will give CUST_ID_01 then drag down.

[@anshuk8972]

wow ❤

[@Pratik-x4c]

Sir plz appload video in hindi

[@Maria-nz3mz]

where is dashboard file?

[@FinTechy]

You can find the Dashboard file in the video description section.

[@PraveenaPraveena-tv4py]

Where is the sales data

[@FinTechy]

You can download the Excel Dashboard database file from the video description section.

[@AmbarAromaticSpices]

nice

[@buddhikaperera5716]

thanks sir

[@josephprecion5871]

Thanks for sharing

[@vaanibhardwaj3128]

Great

[@Potencyfunction]

I have no idea why yo use the term loyal. Prehaps you are all dreamers.

[@userfriendly801]

The sum of profit gave me 700 I don't understand why

[@rachelefeighan2797]

"promosm"

[@javedagf]

Great, please contact, I need to discuss you some dashboard

[@FinTechy]

You can reach out to me at [e-mail]. Looking forward to discussing your dashboard needs!

[@mosaadmohamed5017]

Hi there, I really have learned a lot from you. I also emailed you about your help in creating a business dashboard. Please reply to my emails. Thank you,

[@FinTechy]

Thank you so much-I'm really glad the videos have been helpful to you!. I actually replied to your email recently. Looking forward to connecting further!

[@ITGate24h]

I loved the exercise. Thanks

[@emmanuelnduka3290]

Please can you share the Excel file for us to work with? Thanks.

[@FinTechy]

Certainly! You can find the Excel file in the video description.

[@fathiann]

Why does the Sales ($) Generated by Customers scroll bar doesn't work when I moved it to the dashboard?

[@arghyadutta9091]

Great