How do I contact u pls

Its great. Thank you so much.

good day sir me i ask a question how to create this kind of excel to make it editable in powerpoint not photos type.

what if one more new sub category comes up in the upcoming data.. then do we have to relink everything and make necessary spaces?

I would really love to show you the dashboard I created similar to yours using same format ❤

Code not found in description

@skillnator, your videos are great. can you please share the excel data file used in this video.

Hello @SkillNator, may God bless you a lot. You are so good in your job.

I am curious to know why didn't you create the charts straight from pivot tables instead of copying and using the copy to create charts? This is how I create my dashboard using pivot tables. if you could kindly briefly clarify I will highly appreciate. Thank you!

Thanks, a lot, absolutely brilliant,

This is one of the best Video Presentations on creating an Excel Dashboard. This is a must watch presentation for anyone who wants to learn how to create a dashboard. Very useful tips too. A perfect Step-by-step guide. Thank you for sharing.

Fantastic Video presentation. Very useful feature for creating PP Dashboard from Excel.

adv_brochure_mapping_20150316_20151015@joebillionaiteguillen4749.xlsx

Your Switch Formula is not working it is giving the #SPILL! Error !!! Can you please tell me how to resolve it?

super sir. thanks

Wonder tutorial

its hard but gradually I'm understood

Thanks for the video. if I may, I have a problem I wish you could help me with. It's a filter formula with multiple criteria where "if_not found" condition doesn't work if I add choosecols function to it. Is there any way round this? Here is my filter formula =FILTER(Orders[[Year]:[Amount]],(Orders[Date]>=G14)*(Orders[Date]<=H14)*(Orders[Client]=B5)*(Orders[Payment]="receivable"),"All paid for selected month by selected client") Thank you in advance

Great content 💯.How can we get data for practice ?

Can you please tell from where you get this data?

how to link a sheet to another?

@Skillnator What if we have two datasets? Do we have to merge it or we can use both as it is?

What is the formulae you used to create a new table from.pivot table at around 18minutes?

Pls tell 26:08 ,how add latest year value??

It’s better to use sort unique filter from the table column containing the month then it’s fully dynamic. Charts that also get data from spilled ranges will become fully dynamic

Greetings Sir! Great Tutorial, I must say! I watched this tutorial and my feedback on this is that, who so ever wanted to [a. learn to write queries] or to [b. filter information from the data] or [c. write special functions], on MIS or day to day reporting will get all in this single tutorial, I bet they will survive! PS the best part was the positive and negative indicators, Fantastic.

God job! 👍

Where is code??

Please check..In your excel file switch button (top 10 & bottom 10) are not worked

very helpfull, great job, congratulations

very detailed explained. thank you

Wow I was looking exactly for this ! Thank you 😊

I need a help with pivot table how to reach you ?

❤

Very interesting and informative. Will surely try it.

This an amazing video, extremely helpful and informative! Thank you very much for shring it with us.

Hello! I'm practicing and re-creating your tutorial however, I'm having an error when replicating your formula for =Working! to pick the number and show it in the shape.

❤

😢In store wherehouse there RACK "shelve" for storage items. I'm looking for idea if you can help me Can i create barcode for entar the items when start arrange the items on RACK. In same time other bacode for take items to display. Mean : 1 barcode for arrange items on RACK 1 barcode for remove items from area to display This idea will help for monitor the stock if you help you will make my work very easy 🙏

Ctrl+ Shift + 7 is not working in a excel for border design

Hi this is really amazing! Gonna be starting an internship soon and this is definitely helpful! How can I download the practice data set?

There's no reason why I should not like and subscribe. This is more than mind blowing

This is amazing... Absolutely awesome... Please keep it up and continue to provide us these kind of useful videos.

This is so impressive.

Thank you so much for this! It's very helpful.

I liked the video, but you didnt show some crucial steps for the last top10 and bottom 10 segment.

Amazing... Love this ❤

@Skillnator Thank you walking us through such informative dashboard. I tried replicating the same. I have facing an issue with Slice + Text box at top. I am having to reconfigure the formula every time. Although it setup as dynamic, When i open file next time and try to check filters- the data remains same. only after i reconfigure the cell does the text box become dynamic. Is there any way to fix this issue ?

❤

VBA PROGRAMMING COURSE PLEASE