Видео

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

Can you share the data set

How can i get the dataset ?

Is all the functionality on your dashboard available on the online version of excel? I'm having trouble using text boxes with dynamic cell references while using the online version. Are dynamic text boxes limited to desktop excel?

Very nice 👍👍👍

Excellent presentation

Pls, I have been trying to use the developer tool navigate from top 10 to bottom 10 but my result is always #Spill!…. Pls how can I get to watch the videos step by step for developer tool aspect. Thank you

Thank you very much. I do wish you have good healthy and wealthy forever!!!

wooo thanks very much specials thank for sample file I can follow your video step by step

you are most amazing and brilliant teacher I have ever seen.You give the explanation so clearly.I understand all of steps.Thank you so much.I am really grateful.

Awesome explanation!

Ow did you copy the data off the pivot while it stay linked with the slicer

Awesome job

Where's the code?

Absolutely brilliant

Great

Pls help us with data

This is so awesome

Wow. Thanks for sharing bro. Very informative.

Good work. Switch formul for title is a new idea. Thx

Absolutely amazing.

I really love the switch option, but I also have a slicer by location and some locations dont have any data. Even after modifying my switch formula to not return them it is still showing 0 value in my bar chart. I already tried the "hidden cells" changed to show gaps instead of zeros but I want the chart to resize appropriately based on present values rather than having placeholders when theres only 3 of top 10 values. Is there a way to do this or am I just wishing excel was like Power BI?

Really good ! Why do I get this when linking to Pivot Table cells ?? =GETPIVOTDATA("[Measures].[Count of Rate]",$A$1,"[Append1].[Date]","[Append1].[Date].&[2024-01-09T00:00:00]","[Append1].[TERM]","[Append1].[TERM].&[10 YR ARM]") * I fixed, really odd ! Love the new animation for the Bar and Line charts. I used to code to make that happen ! PS I notice that using interest rate data 6.875% these do not and I cannot make them values using the Import process and TARNSFORM options... really frustrating !

Why not do a video on how you created the Wireframe? Seems like you sped up the process, that's the most important step....

You're awesome bro❤

Which version of excel you are using

You are right , the last part you last part, Normally we did have this kind of cleaned data . Could you make a video and use power query to clean the dataset as this sales dataset?

thanks a lot sir

simply to understand and easy to follow, thank you very much

Good

Thank you so much! Clear explanation and steps.

Wow Fantastic for the first time i have understood PIVOT Tables Thanks! Man

Awesome video and I learned a lot of Excel tricks 🙌🏼

Very informative and useful video i have ever seen so far on excel dashboard

Great Video and Well Explained. The only part i was unable to get it was how you assign roles to Top 10 and Bottom 10 button as video skipped one part I guess around the time stamp 38:00 till 38:55. Please help to clarify. @Skillnator

very nice !!!! thank you

I watched some others too, but this one is excellent!

Hi, what's the shortcut to adapt the slicer size to the content as fast you did (timestamp : 9:20) ?

how you removed all the cells in white background without rows and columns

if only i could like this video a million time! Appreciate the effort to guide us through, it is fantastic and absolutely helpful.

Its an amazing video I learned a lot from it however I have one question its regarding about last 2 minutes(to be precise when the video is on 38.45minutes, how were you able to change the value (number 1 to 2) in option when you were typing the switch and sort, in between typing formula. if its automatic due to formula so its not happing for me

Brilliant, which Font & size you have used

Thanks for Creating us outstanding exposure to dashboard

Excellent teacher

worst contain writer

You teach well. All the relevant aspects are included in your video. Brilliant!!!

Hi .thanks for your wonderful explanation.perfect. Pls I have an assignment ,could you help me out