Impressive video, DataDash Pro. Looking forward to your next upload. I smashed the thumbs up button on your content. Keep up the fantastic work! Your approach to creating a dynamic dashboard is fascinating. How do you see the integration of real-time data impacting the functionality of such dashboards in the future?
It will work seem but you need to apply the array formula, so the last column i show, which is array formula and when you have more data formula will auto expand. for pivot table you need to select the entire columns range as well.
Excel slicer are already easy to use. But yes we can create but since there is no multi selection option so we need vba for that. I cover those too in my video
Impressive video, DataDash Pro. Looking forward to your next upload. I smashed the thumbs up button on your content. Keep up the fantastic work! Your approach to creating a dynamic dashboard is fascinating. How do you see the integration of real-time data impacting the functionality of such dashboards in the future?
It will work seem but you need to apply the array formula, so the last column i show, which is array formula and when you have more data formula will auto expand. for pivot table you need to select the entire columns range as well.
if you need something else. just explin me a little bit more and I will help.
nice share
Thank you
Can you create something similar for Excel?
Excel slicer are already easy to use. But yes we can create but since there is no multi selection option so we need vba for that. I cover those too in my video
@@DataDashPro Thank you 🙏