Interactive Excel Dashboards with Power Query and Power Pivot - FREE Download - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
fatih
Thanks for the content. I want to ask that instead of doing the long Offset function formula, can't we make the same effect with simply indicating the data range in sparkling data range section? Because at the end, the thing you did is not fully dynamic. it is limited to some extent, we can specify that by indicating the range longer in sparkline date range section, can't we? Thanks in advance.
reply
Thanks for the content. I want to ask that instead of doing the long Offset function formula, can't we make the same effect with simply indicating the data range in sparkling data range section? Because at the end, the thing you did is not fully dynamic. it is limited to some extent, we can specify that by indicating the range longer in sparkline date range section, can't we? Thanks in advance.
reply
Nico
Hi Mynda,
Thanks a lot for what you do, your video are really intersting and useful.
I have a problem, I'm struggle with the offset formula, I can't to find the correct result.
If you have lesson about this please could you indicate me ? I would appreciate a lot.
Thanks,
Nico
reply
Hi Mynda,
Thanks a lot for what you do, your video are really intersting and useful.
I have a problem, I'm struggle with the offset formula, I can't to find the correct result.
If you have lesson about this please could you indicate me ? I would appreciate a lot.
Thanks,
Nico
reply
Giovanni
Thank you so much for sharing these materials. Thanks to your videos I was able to successfully get a job (I was able to create a interactive dashboards in less than 30 minutes!). Not to mention of course that I have learned and still learning a lot of new staff. Thanks again!
reply
Thank you so much for sharing these materials. Thanks to your videos I was able to successfully get a job (I was able to create a interactive dashboards in less than 30 minutes!). Not to mention of course that I have learned and still learning a lot of new staff. Thanks again!
reply
Tasfia
This is a great training video. I just faced a problem. When I try to subtract the order date from the shipping date, the values did not match with yours. Then I noticed the date format is different for different rows. Could you please help me in this regard?
reply
This is a great training video. I just faced a problem. When I try to subtract the order date from the shipping date, the values did not match with yours. Then I noticed the date format is different for different rows. Could you please help me in this regard?
reply
Marfel
Ship date and Order date are in Text format, when I change it to date, it has an error maybe due to the format (dd/mm/yyyy), How can I change the format and then I think I can successfully change it to date format with no errors.
reply
Ship date and Order date are in Text format, when I change it to date, it has an error maybe due to the format (dd/mm/yyyy), How can I change the format and then I think I can successfully change it to date format with no errors.
reply
Peace
Thank you! I got stuck at 7:41 of your video time. When I select those columns and try to Add Column and I see that the Date icon is Greyed out so I can't use Subtract Days. Is it a bug or a User Error? I am in Office 365. Thanks
reply
Thank you! I got stuck at 7:41 of your video time. When I select those columns and try to Add Column and I see that the Date icon is Greyed out so I can't use Subtract Days. Is it a bug or a User Error? I am in Office 365. Thanks
reply
Ana-s
I LOVE YOU ! I've answered so much needs already thanks to you ! And I want to work on my dashboards all over again. And thank you for your accent, perfectly understandable for me (I'm french). You are wonderfull !
reply
I LOVE YOU ! I've answered so much needs already thanks to you ! And I want to work on my dashboards all over again. And thank you for your accent, perfectly understandable for me (I'm french). You are wonderfull !
reply
SwiftG!!!
Mynda, do you recommend anyone seeking to enroll in your online course use Microsoft Office 365 as well? And what is the benefit of 365 vs. other versions of Microsoft Office? Annual renewal with updates?
reply
Mynda, do you recommend anyone seeking to enroll in your online course use Microsoft Office 365 as well? And what is the benefit of 365 vs. other versions of Microsoft Office? Annual renewal with updates?
reply
Marlie
Hi thank you for the tutorial. I am trying to follow you by doing, but I cannot find the dimension tables (the look up tables) to download? Was it missing from the resources link below?
reply
Hi thank you for the tutorial. I am trying to follow you by doing, but I cannot find the dimension tables (the look up tables) to download? Was it missing from the resources link below?
reply
Ravikishore
Hi i have issue in office 365 in when we select getdata folder in the path its not showing th files when i click on csv file it is showing how i can correct this ?
reply
Hi i have issue in office 365 in when we select getdata folder in the path its not showing th files when i click on csv file it is showing how i can correct this ?
reply
Add a review, comment
Other channel videos
