🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PdJzy956wo4.html
Before sharing the file with team members, I recommend locking all items on the dashboard - only slicers should be interactive. I once created a dashboard and people messed it up. A tutorial on the recommended settings for "Format Cells>Protection", "Review tab>Protect", and object "Size and Properties" would be nice. These are under the hood settings but are important things to learn. Thank you!
Have the same thing. Want to share it but want only the slicer to be selected. People in my organisation like to click arounf on things they should not and dont want them to change the formats and standards i set. Did you perhaps find a work around since the post?
You have a real talent for communicating loads of information, but making it simple for people to grasp quickly. Not to mention your effortless flow of your videos. Thanks for this video!
It's difficult to believe I managed to do this. You basically saved my presentation. Thank you very much. I have learned so much watching your tutorials. You should have way more subscribers.
Always keep in mind that ppl who see his tutorials might be new or their first time. Every movement of curser showing how every options work. So much detail. U r always a saviour. And do ur company really sell in India . I want to place order if it is yes. Thank u once again. Our great professor Kevin .
Bless you my wonderful tutor. What some tutors explain in hours, Stratvert does it in less than 20 minutes. Your skill set is superb bro. Keep up the good work.
Your steps are as interactive as the dashboard created. Thanks Kevin for creating videos which makes learning supposed complicated parts of Excel super easy.
Kevin, I will agree with one comment here, this is one of the most simple, very easy, and well-explained videos. I could build my first dashboard, THANK YOU!!
Of all the multiple channels I subscribe to on RU-vid - this has become my favorite channel. My skill levels just improve literally by the day. Many thanks Kevin, and I hope the cookie company business makes you filthy rich.
This is by FAR the best comprehensive straightforward video about pivot tables and dashboards. Spending the 19 minutes allowed me to understand everything, which was not possible during my 4-hour class !! Now I feel I should pay you for this haha
Kevin is showing us lots of Excel and by the way you Excel in Excel! Can we all agree we don't think anything when we see a Kevin video pop up? We click on it. Wow, the cookie in the thumbnail just might have got me more reflex to click it! Awesome video
Thank you very much, Kevin for this video. I spent hours yesterday and last night watching videos on how to make interactive dashboards, but I got it when I watched and followed along practically. Much appreciation..💃💃
This video was awesome!! I have been struggling for weeks to figure out how to build a dashboard in Excel. With this video, I got it done in 30 minutes!
I have watched this video a couple of times. Now, I was able to create my own dashboard and my Boss was very glad with my report. Thanks again, Idol.... I'm an avid fan!...
Amazing video! I found it in an Excel playlist from another RU-vidr/Data analyst and decided to check it out since I have been wondering how dashboarding works in this tool. I was able to easily follow along and replicate everything from scratch. Thank you for this quick and easy lesson on Excel.
this is better and easy to follow than the one ive watched from another tutorial. I didnt know that you can sort data directly in Pivot. this will surely lessen my time. thank you.
Awesome presentation, well spoken, thoughtful and easy to understand. I have been using Excel and VBA for years, I knew that I needed to learn pivot tables/charts but I was always afraid to tackle it. This video is making me a lot less hesitant to try it - thank you
Great video. Your delivery is nice, smooth, and to the point. Thank you for not being one of those "teachers" that rambles on forever about absolutely nothing. One thing that would be amazing in your dashboards is a single command button that would clear all the slicers/timeline filters in the dashboard with a single click. Do you think that is possible? Also, I do agree with Jimcarl S. that certain elements of the dashboard should be locked.
Great video, i went through quite some of your videos, as the content was great! Thanks a lot for sharing your knowledge and put it into a great educational sequence Always something new to learn!
Hello, one issue I have is that sheets won’t look exactly the same on various screens. For example you craft a very nice cell, you set width manually to look good on your computer, but when it’s opened on another computer, the text does not fit the cell anymore. Any tips on how to keep things looking good ?
Thank you for this! Everybody in the office now thinks I'm an Excel god and all I did is follow your tutorial. I did learn quite a bit about Excel. Connecting multiple sources to the slicers has literally saved me weeks of work. 10/10 would and will recommend.
Thank you very much Kevin, my Excel skills have been upgraded thanks to your easy to follow videos. The sample excel worksheets you share are super helpful, thank you for being very generous with your knowledge and skills. God bless you
Thank you so much for the file to practice. I don't have time to type data. I spending time to studying a lot stuff preparing for job test and interview. God gives you double blessings.