MyOnlineTrainingHub 👋 At 28:12 of this video you explain a little bit on how to get the values to change color Is there a video about this ? Cuz all my values are not blue for exemple ( number of male, )
It is quite refreshing to find someone on the Internet who is so organized in their presentations and loves what they do. Your videos are informative, well presented, and meaningful to anyone who wants to know more about excel. DZ, North Carolina, USA.
You probably are the best excel tutor on youtube (sorry didn't mean to offend the others). I was so proud that I managed to build my first interactive dashboard after watching your tutorial. Thank you!
Another fantastic training, Mynda - thanks!!! I built my first Excel dashboard about 4 months ago after viewing an earlier webinar by you. It works, but taught me to dive deeper into Power Query, M, Power Pivot, & DAX (all new to me at the time). So, I’ve learned & am learning PQ & PP from you, Mike Girvin, Leila Gharani, Jon Acompora, & others. This webinar came at just the right time to push me back into dashboard development ... probably beginning with replacing that first dashboard. (I configured it to load data tables which makes the file huge & slows the daily update. Now, I know to load data to the PP data model in background & make only pivoted data visible. My DAX chops aren’t quite ready for that, but I learned to swim at the deep end of the pool, so why not jump in?) I love the fast-paced, content-rich method of your webinars. Thanks again!
@@MyOnlineTrainingHub Agree with above - scored me some points with SMT and I have also spread the word about your videos :) Can I please ask, is it possible to add a column with data in retrospect, as in not change the template for ALL previous csv files, but just in the latest ones? I cannot get it to work..
Just brilliant. At a moment, it was like watching a movie and saying the dialogue you want to hear just ahead of hearing it; “Plenty of room to grow”. Yes! Side note, going back to rewatch the 15 things I missed while penning this most amazing commentary.
Loved watching the video and I never realized how the time passed while learning. Beautifully presented and easily explained. Would like see more from you on measures section.👍
Firstly I have to say thank you on behalf of all the members who are learning from your videos. your efforts to educate us on deep excel usage were remarkable ... Thankyou so much for that.
You have done everything with PQ and PP, with a few measures. Fantastic Mynda. I would add a small rejoinder in the end that this is the same way you make this in PowerBI
Hello Mynda, thank you very much for the tutorial it is very helpful but I am currently facing an issue as it shows 1057 errors and the date formatting results in an issue with the pivot table date grouping it reads the date as dd/mm/yyyy please advise I looked through the comments and saw your reply about using locale but after choosing the date type from the first drop-down list, there's another one with all languages and countries which one do i choose.
I know it has been a while since you posted this video, but I had question as far as making the first "Active Employee" chart. How would this work if the initial data loaded in did not have the "Date" column of when the data was retrieved? So for example the only initial dates would be the employee "Hire Date".
Your videos are amasing and the way you explain is very clear. Thanks for sharing the files as well. God bless you and keep creating such amasing content
@@MyOnlineTrainingHub My pleasure Ma'm. Thinking to take your power BI online training classes in May 2019. Your teaching method is excellent and stuff is to the point. Do you offer preparing financial statements webinar as seperate classes. I am account! So more concerned in financial reporting. Thanks. Regards
Mynda, I've been a reluctant Tableau convert but this has really given me the flexibility to jump back into Excel when the context requires :) Thanks for a great tutorial.
This was easily the best tutorial I've ever seen on building dashboards in enhanced Excel -- and I've been using Power Query and Power Pivot for several years. The problem is, sometimes I still struggle to describe or explain what I see happening on my Power Pivot dashboards as I "trial-and-error" my way through various DAX calculations. The two biggest areas of "nebulousness" are: 1) Given that (in addition to allowing us to add basic conditional filters) CALCULATE adds the current row to the existing filter context, is there an easy way to know in advance when you will want to add CALCULATE to your expressions rather than simply waiting to see if things "look right" with or without it on your pivot table? 2) Similarly, I know what ALL and ALLEXCEPT do and I use them frequently to remove or keep selected filters/columns. However, for example, in this tutorial you sometimes use ALL to augment your FILTER statements but not others. Is there an easy way to know in advance that we should be thinking of modifying our FILTER statement with ALL?
I do all the same stuff as you and am amazed how differently we get the same results. I prefer to work inside the formula window at the bottom of PowerPivot.. you do not.. I insert pivot tables from PowerPivot.. you do not.. Excel is so versatile. Good stuff.. and learned a nice few tweaks and tricks from the video. Many thanks.
I enjoy watchin your videos. Quick question. I'm trying to use multiple rules to find a value but I cant get a good result. can you help? 1st rule, value will be = value. I have 3 plan results based on the answer called 1, 2, 3. depending on the value and the plan picked I want to multiple a cell times plan value. What's the best formula to use?
@@MyOnlineTrainingHub I am learning power query from your videos. Have Excel that is update by power query and have formula as well. When I refresh the power query to add latest data in Excel, it refresh but columns having formula don't drag till end and I have to drag it manually. Can you make a video for that? I saw there are many on internet searching the solution of this issue. Thanks again for wonderful Excel videos.
Complimenti per l'ottima spiegazione, una dashboard di ottimo livello, perfettamente realizzata, con una spiegazione chiara e professionale. Bravissima!
Wow! This was AMAZING! I was directed here by (shout out) Jon @ExcelCampus. Now I see why he recommends your training. I'm sharing this with my colleagues. I can't wait to use what I've learned. First, as my Sensei quotes "Perfect practice makes perfect." :) Anyway, thanks!
Thank you so much for your sharing. I am just learning about data analysis for few weeks. I'm wondering that when we combine the data from various sheets, so do we need to form the same format for all sheets?
My pleasure! Ideally the data in each sheet should be in the same structure, however depending on the differences, it is sometimes possible to get data from sheets that aren't the same. It's hard to say without examples.
The work you do is amazing. For sure one of the best excel online teachers I've seen. Big big big thanks, please continue doing what you do ! The value is huge in all of your vids. +1 subcriber.
Hello, Thank you for your very useful videos. If we create all your dashboards in one file, can we consider it as ERP for a small organization? I aimed to build ERP through Excel. I have no idea what ERP looks like? I was not able to find any useful materials like yours regarding ERP. Thank you for your answer
Excellent! Thank you very much for this webinar. My only concern was when we will need to add new data, but you explained this at the end. Basically one-click, this is amazing.
First time to write a comment about youtube video ever, which means your class is absolutely great! I didn't even imagine we can make this kind of beautiful report only with Excel. Tried to follow your steps through this video but hard to understand about DAX. I think I can get the knowledge from your videos. Thanks for letting me know about another world, I will practice to become the person like you :D P.S. it would be very appreciated if you could speak little slower than now, sometimes your tempo is bit faster than my understanding because I am not a native speaker.
Wow, thanks for taking the time to comment and your kind words :-) While DAX is very similar to Excel functions, it's also quite advanced so don't be tough on yourself if you don't get it right away.
Thank you Mynda for sharing this amazing tutorial. Question: I'm having trouble in getting data. It shows an error when I click close and apply about a driver missing or corrupted! What should I do in such case? Thank you
Good morning, I just discovered this excellent video, and started watching. I'm wondering if this material is still current (5 years ago) or are there more recent versions? Thank you so much!
Your videos are soooo informative, thank you! Any idea why the values are showing as 0 on the dashboard? I put the = and went to the sheet and selected the values but it populates as 0 near the icon…
Wow... absolutely amazing. I picked up so many things from this video and was able to apply these concepts to produce a similar dashboard for our HR data. It was very well received, thank you so much. Just one small thing I couldn't figure out - How did your text in the headlines automatically format to match the colour of your icon?
@@MyOnlineTrainingHub Thanks Mynda. Can you help with a new emergency please - I had created a number of queries and loaded them to my workbook as tables in separate tabs. I had used Power Pivot to create a data model with several relationships, hierarchies and measures. I finished my dashboard, then changed the name of my workbook to something user friendly. But now all my queries and my model have disappeared. When I click the data tab, the queries and connections is greyed out. When I click Power Pivot my model is empty. How do I get everything back?! Please help!
![How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024]](/img/n.gif)
Download the file used in the video here: www.myonlinetraininghub.com/workbook-downloads
MyOnlineTrainingHub hi is the download free? I’d like to have a go while watching your instructions.
MyOnlineTrainingHub 👋
At 28:12 of this video you explain a little bit on how to get the values to change color
Is there a video about this ?
Cuz all my values are not blue for exemple ( number of male, )
Thank ...
@@rodrigorodders7173 Yes, it's completely free.
Hi Linda I don't get an option to combine and edit after clicking on get data while downloading my csv file
It is quite refreshing to find someone on the Internet who is so organized in their presentations and loves what they do. Your videos are informative, well presented, and meaningful to anyone who wants to know more about excel. DZ, North Carolina, USA.
Thanks for your kind words, David!
For a guy who learnt PowerBI first, this seems like a revision of measures and calculated columns but this video showed me where the PowerBI began!!
Power BI did indeed start in Excel as Power View :-)
That's the best tutorial for dashboard design in Excel I've seen so far.
You probably are the best excel tutor on youtube (sorry didn't mean to offend the others). I was so proud that I managed to build my first interactive dashboard after watching your tutorial. Thank you!
Thanks for your kind words, Grace! Congratulations on building your own dashboard :-) Please share the tutorial with your friends and colleagues.
Did not think i could watch a 50+ min video but this went by so fast .. glad i watched this
i am ready to show off
cant group selection for dates. months, quarters in pivot table as it is connected to data model. what to do?
Another fantastic training, Mynda - thanks!!! I built my first Excel dashboard about 4 months ago after viewing an earlier webinar by you. It works, but taught me to dive deeper into Power Query, M, Power Pivot, & DAX (all new to me at the time). So, I’ve learned & am learning PQ & PP from you, Mike Girvin, Leila Gharani, Jon Acompora, & others. This webinar came at just the right time to push me back into dashboard development ... probably beginning with replacing that first dashboard. (I configured it to load data tables which makes the file huge & slows the daily update. Now, I know to load data to the PP data model in background & make only pivoted data visible. My DAX chops aren’t quite ready for that, but I learned to swim at the deep end of the pool, so why not jump in?) I love the fast-paced, content-rich method of your webinars. Thanks again!
Thanks for your kind words, Jim! It's great to hear you're using Power Query and Power Pivot and I'm honoured that I can help in a small way :-)
Absolutely incredible... Thanks for this webinar.... So proud of you!
Thanks for your kind words, Marcel :-)
To be honest. Your video is the best. Can see u r a very good teacher. Everything is so detail and never miss a step.
Wow, thank you!
Been looking for something like this! Especially working in HRIS. Thank you so much, you're amazing! X
You're so welcome :-)
@@MyOnlineTrainingHub mam cant group selection for dates. months, quarters in pivot table as it is connected to data model. what to do?
cant group selection for dates. months, quarters in pivot table as it is connected to data model. what to do?
@@MyOnlineTrainingHub Agree with above - scored me some points with SMT and I have also spread the word about your videos :) Can I please ask, is it possible to add a column with data in retrospect, as in not change the template for ALL previous csv files, but just in the latest ones? I cannot get it to work..
Just brilliant. At a moment, it was like watching a movie and saying the dialogue you want to hear just ahead of hearing it; “Plenty of room to grow”. Yes! Side note, going back to rewatch the 15 things I missed while penning this most amazing commentary.
Thanks for your kind words, Chris! So pleased you enjoyed it.
Loved watching the video and I never realized how the time passed while learning. Beautifully presented and easily explained. Would like see more from you on measures section.👍
🆔🕋📗
Firstly I have to say thank you on behalf of all the members who are learning from your videos. your efforts to educate us on deep excel usage were remarkable ... Thankyou so much for that.
So nice of you 😊
Your videos are awesome 😍😍😍. Thanks a lot. Please create a special video for pivot calculator.
Thanks for your kind words! I'm not sure what you mean by a 'Pivot Calculator'.
Great example you have shed a new light on the capabilities of Excel as a BI tool and changed my perspective !!!!
Thank you! That's great to hear :-)
*This is a super great online tutorial* _for free!_ *Will i be able to master it? Wish me luck. THANK YOU!!*
You're welcome, James! Have fun building your own dashboards :-)
Very comprehensive, yet easy steps. Many thanks Mynda
Glad you enjoyed it!
Awasome videos. Congrats Mynda
:-) thank you!
Your style is so calming...im so chill when watching your videos
Oh thank you!
cant group selection for dates. months, quarters in pivot table as it is connected to data model. what to do?
Great Video, Mynda!!!!
Thanks, Mike!
cant group selection for dates. months, quarters in pivot table as it is connected to data model. what to do?
You have done everything with PQ and PP, with a few measures. Fantastic Mynda. I would add a small rejoinder in the end that this is the same way you make this in PowerBI
Great point 😊
Hello Mynda, thank you very much for the tutorial it is very helpful but I am currently facing an issue as it shows 1057 errors and the date formatting results in an issue with the pivot table date grouping it reads the date as dd/mm/yyyy please advise
I looked through the comments and saw your reply about using locale but after choosing the date type from the first drop-down list, there's another one with all languages and countries which one do i choose.
Choose your locale. For me, I choose English (Australia). If you use mm/dd/yyyy formatting you'd choose English (United States)
I know it has been a while since you posted this video, but I had question as far as making the first "Active Employee" chart. How would this work if the initial data loaded in did not have the "Date" column of when the data was retrieved? So for example the only initial dates would be the employee "Hire Date".
You could use today's date to compare to the hire date using the TODAY() function.
Your videos are amasing and the way you explain is very clear. Thanks for sharing the files as well. God bless you and keep creating such amasing content
You are very welcome 🙏😊
Amazing webinar!
Thank you, Muhammad :-)
@@MyOnlineTrainingHub My pleasure Ma'm. Thinking to take your power BI online training classes in May 2019. Your teaching method is excellent and stuff is to the point. Do you offer preparing financial statements webinar as seperate classes. I am account! So more concerned in financial reporting. Thanks. Regards
It'd be great to have you join my course. I don't have anything specifically on financial statements, but many of the techniques apply to all data.
MyOnlineTrainingHub Great. Thanks
Mynda, I've been a reluctant Tableau convert but this has really given me the flexibility to jump back into Excel when the context requires :) Thanks for a great tutorial.
Great to hear Gary!
Gorgeous woman, excellent content🔥
Excellent tutorial! I still have 13 minutes more to go in the video but I am literally excited to finish and go into Excel to play around with this.
Great to hear :-)
It is an art rather than a so-called-skill!!!
Excellent tutorial of making Dashboard using Excel. Thank you so much!
Glad you like it!
Could you please share a finance dashboard
You're a real master thank you! Your presentation is so different from the trainings we may get from top companies
Thanks for your kind words, Dimitri! I'm honoured you liked my video. Please share it with your co-workers too :-) Mynda
Why there are dislikes? Its a good video. Not many trainers share this level of information and detail.
Thanks, Usman!
I have literally never felt one hour passing that quick! This is much more than outstanding! Wow! 😊
From Jakarta-Indonesia, I would say, "Excellent" online training ! Keep sharing, keep be blessing to others !
:-) thanks, John!
John, apakah anda mendapatkan masalah tenure months yang tidak terbaca sebagai decimal?mohon solusinya. saya juga dari jakarta indonesia, terima kasih
This was easily the best tutorial I've ever seen on building dashboards in enhanced Excel -- and I've been using Power Query and Power Pivot for several years.
The problem is, sometimes I still struggle to describe or explain what I see happening on my Power Pivot dashboards as I "trial-and-error" my way through various DAX calculations. The two biggest areas of "nebulousness" are:
1) Given that (in addition to allowing us to add basic conditional filters) CALCULATE adds the current row to the existing filter context, is there an easy way to know in advance when you will want to add CALCULATE to your expressions rather than simply waiting to see if things "look right" with or without it on your pivot table?
2) Similarly, I know what ALL and ALLEXCEPT do and I use them frequently to remove or keep selected filters/columns. However, for example, in this tutorial you sometimes use ALL to augment your FILTER statements but not others. Is there an easy way to know in advance that we should be thinking of modifying our FILTER statement with ALL?
Thanks for your kind words. This is a great DAX resource on FILTER etc.: dax.guide/filter/
I do all the same stuff as you and am amazed how differently we get the same results. I prefer to work inside the formula window at the bottom of PowerPivot.. you do not.. I insert pivot tables from PowerPivot.. you do not.. Excel is so versatile. Good stuff.. and learned a nice few tweaks and tricks from the video. Many thanks.
Thank you so much for such a stunning video. You are a genius
So nice of you 🙏🥰
I enjoy watchin your videos. Quick question. I'm trying to use multiple rules to find a value but I cant get a good result. can you help? 1st rule, value will be = value. I have 3 plan results based on the answer called 1, 2, 3. depending on the value and the plan picked I want to multiple a cell times plan value. What's the best formula to use?
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Dear Mrs Mynda, i from indonesia. Thankyou so much Mynda. thankyou. God Bless You.. ❤
You are so welcome!
Mynda, thanks, your webinar still fresh to follow :)
Awesome, thank you!
Hi Mynda, it took me 3 Hours to got the same results as yours but it looks amazing. Thanks a lot for sharing this information and teaching us!
It’s awesome to hear you were able to build it yourself. Congratulations!
We used to keep waiting for your videos...I would say best Excel videos over TH-cam. Please keep uploading videos ..
:-) thanks, Zahir! Please share them with your colleagues.
@@MyOnlineTrainingHub I am learning power query from your videos. Have Excel that is update by power query and have formula as well. When I refresh the power query to add latest data in Excel, it refresh but columns having formula don't drag till end and I have to drag it manually. Can you make a video for that? I saw there are many on internet searching the solution of this issue. Thanks again for wonderful Excel videos.
Hi Zahir, you should add your columns in Power Query, not in the Excel worksheet, then they always copy to the end.
Complimenti per l'ottima spiegazione, una dashboard di ottimo livello, perfettamente realizzata, con una spiegazione chiara e professionale. Bravissima!
Your vdos are fantastic and informative. I follow you and I find every vdo helpful in my work.
Awesome to hear 🙏
Wow! This was AMAZING! I was directed here by (shout out) Jon @ExcelCampus. Now I see why he recommends your training. I'm sharing this with my colleagues. I can't wait to use what I've learned. First, as my Sensei quotes "Perfect practice makes perfect." :) Anyway, thanks!
Great to know Jon sent you our way. He does some amazing tutorials too.
Love the tabs added in the dashboard, exactly what I needed in my project.
Great to hear!
God bless you young lady
Thanks a lot
Most welcome 😊
Thanks for sharing this wonderful tutorial!
You are so welcome!
I just love this woman! Isn't she amazing?
Aw, thank you! You're too kind :-)
Your presentation is excellent. thankyou
You are most welcome, Farhan!
Speechlessly brilliant! Thank you!!!
Wow, thank you!
You are really great. Thanks for sharing your knowledge and helping others.
My pleasure!
Lovely dashboard and amazing & easy presentation for learning , thanks
Thanks so much 😊
Way better than in my company :) Good for inspiration!
Great to hear you found some techniques you can use 😊
LOVED IT; Thank you very much for sharing such a wonderful piece of work...Respects for you..
My pleasure 😊
Thank you so much for your sharing. I am just learning about data analysis for few weeks. I'm wondering that when we combine the data from various sheets, so do we need to form the same format for all sheets?
My pleasure! Ideally the data in each sheet should be in the same structure, however depending on the differences, it is sometimes possible to get data from sheets that aren't the same. It's hard to say without examples.
Great video with a good detailed explanation! Mind-blowing your amazing teaching style.
A Big Thank you
Thanks for your kind words!
This was so powerful! I learned so much! Excited to implement this with my reports
Excellent webinar. Thank you.
Glad you enjoyed it, Juan!
No words enough to thank you enough for all the amazing information you are sharing.
Thank you! You can thank me by sharing the video with your friends and colleagues too. Let's help more people master Excel.
@@MyOnlineTrainingHub I am giving them a gift by sharing this video. Anyone not yet checked your channel, he doesn't know what professionalism mean :)
you are absolutely brilliant, thank you so much for this public service.
My pleasure :-)
Mynda 🥰 Tremendous work, the New Icons looks great in the dashboard. You are the best in this topic. Thank you 🙏.
Thank you so much 🤗
Your videos are so satisfying 😊
Glad you like them!
Awesome tutorial! Many thanks for this.
Glad you enjoyed it!
Excellent! very clear webinar.
Thanks,Chuck! Glad it was helpful. Please share it with your friends and colleagues.
Thanks for this detailed explanation
My pleasure, Tanmay :-)
Excellent webinar...learned a lot.. thank you.
Glad it was helpful!
Every Video is a new experience - Really Loved them. Very well done for the quality of your work. You make a difference to the excel-users world!
Thanks for your kind words, Antonios :-) Please share the video with your colleagues.
That's about 2 weeks work for me!! I get crap data supplied though... But still amazing. Going to use power query from here on in!!
como haces para cambiar la matriz de colores de la fuente de excell, gracias por la respuesta.
Great one
Impressive dashboard Lots of love from India
Have fun building your own dashboards :-)
I am very glad to you for broader, talented and expertise presentation. Thanks lot.
Many thanks, Syed!
Very much impressed with the way it is explained. Neatly understood step by step. Thank you very much for making this video.
The work you do is amazing. For sure one of the best excel online teachers I've seen. Big big big thanks, please continue doing what you do ! The value is huge in all of your vids. +1 subcriber.
Wow, thank you, Gevorg!
You are so great and awesome your tutorial is very clear and helpful. I admire your passion, effort and skills. Huge thank you 🤗
Thank you so much, Sally!
Just AWESOME! Thank you so much for such a great learning material!
My pleasure, Greg!
Very helpful thanks for your professional work ♥♥♥
My pleasure 😊
Gracias!!!!! Me encanto tu video lo veo una y otra vez
Great to hear, Yohana!
Hello,
Thank you for your very useful videos. If we create all your dashboards in one file, can we consider it as ERP for a small organization? I aimed to build ERP through Excel.
I have no idea what ERP looks like?
I was not able to find any useful materials like yours regarding ERP.
Thank you for your answer
Glad you found them helpful. I'm sure you can build an ERP in Excel, however I don't have any examples I can show you.
Excellent! Thank you very much for this webinar. My only concern was when we will need to add new data, but you explained this at the end. Basically one-click, this is amazing.
Glad you liked it, Julissa! Please share it with your friends and colleagues who use Excel for reporting.
I absolutely love this! Every time I watch one of your videos I learn something new!
Thanks so much! Please share it with your colleagues :-)
First time to write a comment about youtube video ever, which means your class is absolutely great! I didn't even imagine we can make this kind of beautiful report only with Excel. Tried to follow your steps through this video but hard to understand about DAX. I think I can get the knowledge from your videos. Thanks for letting me know about another world, I will practice to become the person like you :D P.S. it would be very appreciated if you could speak little slower than now, sometimes your tempo is bit faster than my understanding because I am not a native speaker.
Wow, thanks for taking the time to comment and your kind words :-) While DAX is very similar to Excel functions, it's also quite advanced so don't be tough on yourself if you don't get it right away.
Interactive Excel HR Dashboard awesome!
Glad you liked it 😊
Thank you very much, I always learn from you !
Glad to hear that, Jawad!
Excellent video content, quality, and presentation. Thank you very much!
Simple but extremely effective when you know how.
Cheers, Kevin. Have fun building your own dashboards.
I'm sorry! You deserve more subscribers! Good job!!
Thanks so much. Please spread the word and help us grow 😊
Great stuff! really impressed.
Glad you liked it!
Excellent training
Glad you enjoyed it, Nagu!
Amazing, Never used DAX but after seeing your video I might try to learn more about it. Thanks A lot..
I'm getting this excitement, just imagining what dashboard I can make out of your video.
On every of your videos, i learn a lot!!! Thank you for spending your time and resources to share your knowledge with us.
Glad you find them helpful :-)
Excellent, presentation is crisp as well as detailed given the number of sub-topics
Can you do a video on how to analyse survey data? I appreciate you sharing the knowledge with us.
Hi Edwin, here is a tutorial on visualising survey data: www.myonlinetraininghub.com/excel-charts-for-surveys
Thank you Mynda for sharing this amazing tutorial. Question: I'm having trouble in getting data. It shows an error when I click close and apply about a driver missing or corrupted! What should I do in such case? Thank you
Not sure. I recommend you do a Google search for the exact error message as I'm sure you're not the first to have the problem.
I fall in love with this excel dashboard 😍
:-) thanks, Niks! Please share it with your friends and colleagues.
Good morning, I just discovered this excellent video, and started watching. I'm wondering if this material is still current (5 years ago) or are there more recent versions? Thank you so much!
Glad you're enjoying it. It's still relevant all these years later 😉
Thank you. The content is amazing!
Your videos are soooo informative, thank you! Any idea why the values are showing as 0 on the dashboard? I put the = and went to the sheet and selected the values but it populates as 0 near the icon…
I figured it 🎉. Now just need to figure how to lock those shapes to prevent others from moving them 😅
Great to hear. Please see this tutorial on how to prevent others messing with your shapes: www.myonlinetraininghub.com/excel-worksheet-protection
Thank you. You're the best. Greetings from Colombia
Thanks so much!
Wow... absolutely amazing. I picked up so many things from this video and was able to apply these concepts to produce a similar dashboard for our HR data. It was very well received, thank you so much. Just one small thing I couldn't figure out - How did your text in the headlines automatically format to match the colour of your icon?
Great to hear, Holly! I had already applied the cell formatting before building the dashboard to save some time.
@@MyOnlineTrainingHub Thanks Mynda. Can you help with a new emergency please - I had created a number of queries and loaded them to my workbook as tables in separate tabs. I had used Power Pivot to create a data model with several relationships, hierarchies and measures. I finished my dashboard, then changed the name of my workbook to something user friendly. But now all my queries and my model have disappeared. When I click the data tab, the queries and connections is greyed out. When I click Power Pivot my model is empty. How do I get everything back?! Please help!