VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
How to Build Excel Interactive Dashboards - Kevin Stratvert

How to Build Excel Interactive Dashboards - Kevin Stratvert

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
How to Build Excel Interactive Dashboards - Kevin Stratvert learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. All you need is Microsoft Excel there's no need for any VBA or add-ons. When you receive new data, you can easily update your dashboard to reflect the latest. You can adjust the look and feel using various themes and you can even customize the dashboard to match your organization's color scheme. Once you finish, you can share out your dashboard easily for others to consume. If you'd like to follow along, you'll find the sample sheet that I used below. - Additional resources - Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMgx8bXq-2uARjf45Q?e=VU4CPy - Introduction to Pivot Tables video: https://youtu.be/m0wI61ahfLc - Advanced Pivot Tables video: https://youtu.be/3g1CSG5zvQ0
Date: 2022-03-15

Comments and reviews: 8


Sometimes some of us offered the best in relationship but still never get the best from our partner, if you genuinely love your partner and you sense this behaviour of cheating you dont just have to work away like that sometimes you might be wrong thinking your spouse is cheating on you, the best way to get this properly is to spy on his/her messages, i was once in this shoes i told a colleagues about it and she advice me to chat FORTIFIED7TOOLS on instagram initially i was having this doubt just be caused i was scammed several times by different hackers i gave my self a second thought that my colleagues can not feed me with lies, i decided to give him my last try and he successfully spy my spouse messages, i was so in shocked seeing everything clearly that my partner has been cheating on me i just have to work away, thankgod i have seen the right person happily married expecting a bouncing baby boy lol, with sincere heart i recommend all of you to the best hacker FORTIFIED7TOOLS on instagram so reliable and trusted
reply

Hi Kevin,
First of all, thank you so much. Great & awesome video, explained so very well. I have followed everything you have shown to the letter in here. However, I'm stuck at linking the Slicers to the multiple Pivot Charts. When I'm trying to establish the Connection, it won't shown me multiple options except 1 (my original pivot data only). I've tried to look for the settings but couldn't find anything relevant. Any help would be highly appreciated.
Thanks

reply

Hello kevin, thank you for creating such an amazing guide in a video. you are cool.
Anyway, how do we make our pivot table enable us to read data profit as a number, not as a text?
Thanks in advance

reply

-Kevin Stratvert - How to add dashboard header which is added with your company logo? Also I'm facing Reference isn't valid error sometimes which force me to close all excels from task manager.
reply

Creating Interactive dashboards is not an optional thing. Creating interactive dashboards is not a compulsory thing. It is not difficult to create interactive dashboards. It is not easy.
reply

Hello, thank you very much Kevin, you are surprising me all the time, I am fascinated by the way you explain things video after another, thank you very much.
reply

Can you show me how you can detect the problem behind sales profit going down during November and December and how to tackle it.
reply

Thanks very much. You are now the only person I go to when learning something g new in Excel. Keep up the good work mate.
reply
Add a review, comment






Other channel videos