Secrets to Building Excel Dashboards based on Non-financial Data - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Prasun
Hello, Mynda I have been watching your guidance and it's really great to understand. My request is to kindly guide me how to create dynamic links of various rows in a sheet to another sheet?
Example: in Sheet 1,
Row 1: 24(col1), 29(col2), 37(col3), 58(col4) #(shape)
Row 2: 65(col1), 31(col2), 35(col3), 54(col4) #(shape)
Now while clicking on # of each row, it will automatically fill up the corresponding data of that row into another sheet under concerned column title. And it will changes automatically while clicking # of another row of sheet 1.
Can we solve this without using VBA, please guide...
Thanks
reply
Hello, Mynda I have been watching your guidance and it's really great to understand. My request is to kindly guide me how to create dynamic links of various rows in a sheet to another sheet?
Example: in Sheet 1,
Row 1: 24(col1), 29(col2), 37(col3), 58(col4) #(shape)
Row 2: 65(col1), 31(col2), 35(col3), 54(col4) #(shape)
Now while clicking on # of each row, it will automatically fill up the corresponding data of that row into another sheet under concerned column title. And it will changes automatically while clicking # of another row of sheet 1.
Can we solve this without using VBA, please guide...
Thanks
reply
Hougrel
I am having to completely re-educate myself. 15 years ago the majority of my logic,formatting and processing was achieved via events and VBA code. Granted some of this functionality is new but I suspect much of it I just ignored because I could code it. I pretty much kept up with video but now will watch again and note the bits I need to know more about and then dive into your other brilliant videos to re-enforce what I learnt today. Thank you so much (Note to self - use a measure to fill in missing weekend data for stock prices?)
reply
I am having to completely re-educate myself. 15 years ago the majority of my logic,formatting and processing was achieved via events and VBA code. Granted some of this functionality is new but I suspect much of it I just ignored because I could code it. I pretty much kept up with video but now will watch again and note the bits I need to know more about and then dive into your other brilliant videos to re-enforce what I learnt today. Thank you so much (Note to self - use a measure to fill in missing weekend data for stock prices?)
reply
Allie
Great tutorial!!! Thank you
I have a question, it is related to Microsoft planner and the ability to use excel to create a dashboard for the projects.
I know power BI can be used to get visuals by downloading the data using excel.
I would like to know if you have a tutorial on how to use excel dashboards using the data downloaded from planner.
Thanks again for your videos and tutorials -
reply
Great tutorial!!! Thank you
I have a question, it is related to Microsoft planner and the ability to use excel to create a dashboard for the projects.
I know power BI can be used to get visuals by downloading the data using excel.
I would like to know if you have a tutorial on how to use excel dashboards using the data downloaded from planner.
Thanks again for your videos and tutorials -
reply
Peace
Mynda, I got stuck at 45:42 video time. In my case after I wrote that measure, it populates 0 for every column for Male and Female. In your case I noticed that there are other values also. What mistake do you think that I must have made? It is wonderful but, in my case, it didn't take an hour to make, it take entire day as I was making some mistakes. Thanks
reply
Mynda, I got stuck at 45:42 video time. In my case after I wrote that measure, it populates 0 for every column for Male and Female. In your case I noticed that there are other values also. What mistake do you think that I must have made? It is wonderful but, in my case, it didn't take an hour to make, it take entire day as I was making some mistakes. Thanks
reply
frank
Absolutely loved it. A ton of different techniques used in one amazing presentation. Looks like I now have to go back to the drawing board and redo just about every file I'm sharing. Thanks for the extra work:)
reply
Absolutely loved it. A ton of different techniques used in one amazing presentation. Looks like I now have to go back to the drawing board and redo just about every file I'm sharing. Thanks for the extra work:)
reply
Just
Sooo many thanks for this tutorial and all other video's from you. it's just...wow.. Currently i am creating a big dashboard for the company with your help. I will blow them away i guess.. thank you so much!
reply
Sooo many thanks for this tutorial and all other video's from you. it's just...wow.. Currently i am creating a big dashboard for the company with your help. I will blow them away i guess.. thank you so much!
reply
AlterMind64
Yet another incredibly efficient and effective video, with great and clear explanation, and brilliant result ! Always a real pleasure and learning experience combined. Thank you Mynda :-)
reply
Yet another incredibly efficient and effective video, with great and clear explanation, and brilliant result ! Always a real pleasure and learning experience combined. Thank you Mynda :-)
reply
kara
Followed this perfectly until the crewed mission table. When I use the calendar for the rows the years show up but as soon as I add the other field s the years disappear what am I doing wrong!!!
reply
Followed this perfectly until the crewed mission table. When I use the calendar for the rows the years show up but as soon as I add the other field s the years disappear what am I doing wrong!!!
reply
Amin
Hi, very useful videos. Thank you. Is it possible to create a project management dashboard which is linked to primavera p6 database? It would be very helpful and also new amazing topic.
reply
Hi, very useful videos. Thank you. Is it possible to create a project management dashboard which is linked to primavera p6 database? It would be very helpful and also new amazing topic.
reply
Saba
That's just awesome, I never found someone explaining so beautifully to make dashboards in non-financial data, for me it is life saver for qualitative data.
Thanks -
reply
That's just awesome, I never found someone explaining so beautifully to make dashboards in non-financial data, for me it is life saver for qualitative data.
Thanks -
reply
Add a review, comment
Other channel videos
