I have been using excel for 20 years, I thought I was a power user, your tutorial shows me I am a mere beginner. I learnt so much, thank you

@MyOnlineTrainingHub

2 жыл бұрын

So pleased you enjoyed it, Tony!

@adelekedeborah316

2 жыл бұрын

It's almost confusing me really. Excel is wide!

@YuccaTrash79

Жыл бұрын

I haven't even bought it yet, but this comment let's me know I'm learning and leading on the right foot. I need it for personal family finances, hopefully forecasting also.

Your tutorials are fantastic. I watched this over and over while rebuilding it. Thank you so much for your videos!

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear 😊

This is by far the best expense overview/budget overview setup I've seen! I love how visual it is!

@MyOnlineTrainingHub

2 жыл бұрын

Thanks for your kind words, Victoria!

An almost impossible balancing act between "Baptism by Firehose" and "Total Immersion"! It was so helpful that your video not only covers data analysis, tables, dashboards and slicers but does so under a single topic "personal budget tracking" which can be applied to almost any other topic. Covering so much material and presenting it so clearly and concisely is what makes your video one of the best I've seen. Thanks for your 'Excel'lent presentation.

@MyOnlineTrainingHub

Жыл бұрын

Wow, thanks for your super kind words! Please check out my other dashboard videos too: kzread.info/dash/bejne/fWtowaiHns-vdps.html

@2mdallas

Жыл бұрын

@@MyOnlineTrainingHub I'm on it ... and spreading your gospel to everyone I know asap. You're the best. Thanks again for sharing your remarkably gifted work. All the best from "across the pond". MgM

I just loved this dashboard based on personal finance! I've been trying to create something like this for a while, so I could have a better visualization of my expenses. If you have other ideas on dashboard for personal finances, please show us, Mynda! Thank you for sharing this one!

@MyOnlineTrainingHub

2 жыл бұрын

Glad it’ll be useful, Cassio! 😊

Excellent content. Having a personal finance dashboard like this will keep paying off for years to come. Had fun making it and learned a lot of useful excel skills in the process. Thank you for making this available to everyone.

@MyOnlineTrainingHub

Жыл бұрын

Great to hear it will be useful to you!

Mynda I wake up on Sunday morning at 8:30 AM to finish your video tutorial. It´s really amazing all things you explained on this video. Thanks to people like you I truly believe in new social media. Greetings from Spain !

@MyOnlineTrainingHub

Жыл бұрын

Wow, that's awesome to hear, Pablo! I'm so pleased my tutorial has been so helpful to you.

Amazing how somebody that uses excel everyday still can learn a lot. This tutorial is the best i have seen and i have seen a lot. Keep it coming.

@MyOnlineTrainingHub

Жыл бұрын

That's wonderful to hear!

Very impressive. I don’t use Excel nearly as much as I used to, but this makes me want to start using it again! I had no idea you could do this sort of thing.

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear, Todd! 😊

thank you so much for you tutorials in data analyzing and visualizing data in EXCEL and POWER BI, please continue with your videos, for me those videos better than a lot of courses because you give us a real case and give us the file to work with you in the case by ourselves, for me this better than theory courses to understand and how i can monitor the platform like excel and power BI. i hope to see more practical videos

@MyOnlineTrainingHub

2 жыл бұрын

Glad you enjoy them, Sam! My courses also include examples based on real cases and more.

Never thought I’d enjoy an Excel tut. This is pure Gold

@MyOnlineTrainingHub

3 ай бұрын

Awesome to hear 😁

I don't know how I've gone this long without knowing you exist but I'm so glad I found you. I'm definitely going to try this! Thank you so much!

@MyOnlineTrainingHub

2 жыл бұрын

My pleasure 😊 glad you found me!

Excellent video -- thank you for sharing this knowledge, Mynda! Very minor possible correction: 13:29 I believe if you select the entire chart object by clicking in its general chart area, any font changes you make will apply to every text box within the chart (instead of having to select them one by one). I have to make a lot of charts and this also frustrated me for a long time before I realized you can do them all at once! Cheers

@MyOnlineTrainingHub

2 жыл бұрын

Thanks for the tip 😊

i like the whole concept. you dont only make videos and share this wonderful work, you as well have a really nice webpage, where i often search some vba stuff and i find it with a wonderful and clear explaination which is on point👍 Thanks a lot @ you and your team. really professional work 😊 wish you klicks and views 😊👍

@MyOnlineTrainingHub

2 жыл бұрын

So pleased you find our tutorials helpful 🙏

I watched the whole video in awe..... Someone whispered in my ears..... You know nothing.... And i love the feeling ❤️❤️❤️🙏🙏🙏🙏 Applied excel at its best🙏

@MyOnlineTrainingHub

Жыл бұрын

😊 glad you enjoyed it, Tua!

I like how you're making data analysis dashboarding accessible for everyone.

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much 😊

Y'all come up with the best ideas! You have taught me so much through these videos. Thank you!!!

@MyOnlineTrainingHub

2 жыл бұрын

Awesome! Thank you!

That's a beautiful dashboard. Love the colour palette. Wouldn't it be great if Excel had data label charts and table charts? I hate having to play about with column widths to align data entered into cells alongside shapes. It'd be even better if Microsoft added a better interface for handling shapes altogether, with alignment bars and snap to fit and that sort of thing. I suppose they have to leave some things for power bi!

@MyOnlineTrainingHub

2 жыл бұрын

:-) thanks so much, Rico! You can snap objects to the grid by holding down ALT while you left click and drag. I agree, the chart and object tools could do with some improvement.

@ricos1497

2 жыл бұрын

@@MyOnlineTrainingHub yes, the alt is good for snapping to cells, I was more meaning for snapping to align to other shapes. I'm probably expecting too much from a spreadsheet tool though!

@MyOnlineTrainingHub

2 жыл бұрын

Yes, that would be handy too!

This is by far the best KZread video on excel personal finance dashboards. Thank you for your generosity in sharing this knowledge and the free template!

@MyOnlineTrainingHub

9 ай бұрын

Wow, thanks!

Great video, thanks Mynda. When you set up the treemap and waterfall charts you had to edit the chart parameters to point to the data and label ranges. Would these ranges automatically expand if, say, an additional category was used in the transaction detail table?

@MyOnlineTrainingHub

2 жыл бұрын

Hi Dave, sorry for the slow reply. I thought I responded. For the treemap you can simply reference a range big enough to allow for growth and the treemap will only display the data, ignoring empty cells in the range. For the waterfall chart you'd have to use dynamic named ranges: www.myonlinetraininghub.com/excel-dynamic-named-ranges

@davecope3322

2 жыл бұрын

@@MyOnlineTrainingHub Thanks Mynda

As always, a terrific tutorial - thanks! I especially liked your use of Treemap & Waterfall charts. I haven’t needed either in the dashboards I’ve built to date, but (probably b/c of that) I don’t even think of them when building dashboards. Good to be reminded & see how to set them up. Lesson learned: I need to spend a bit more time in Chart Type selection to review all possibilities & not just pre-select the chart types that I commonly use. Question: Why did you not use the Data Model (Power Pivot)? Was it outside scope of this tutorial? Or was it a conscious design decision that its use here was not appropriate for this dashboard? (In other words, if you were building this for your personal use, not for training, would you have used the Data Model? If not, why not?) Or some other reason?

@ricos1497

2 жыл бұрын

I'm guessing it was outside scope, but also there would need to be some sort of interface for filling out the categories for each expense. You could do that, of course, by downloading your bank CSV/text files and then using adodb to update them with expenses from a table in Excel or something along those lines, but it'd be quite variable in the setup for each circumstance. However, it would make a cool video.

@jimfitch

2 жыл бұрын

@@ricos1497 Great points, Rico. A couple of Excel apps that I built have a similar user-adds-data-to-downloaded-records requirements. Those apps use PQ, VBA, & dynamic arrays. Neither uses the Data Model b/c I had zero PP/DAX skills then (& almost zero now, but I’m starting that learning curve). In both, I use PQ to ETL source data, then use PQ to extract new entries that require user-entered data to a separate table, then the user enters the data (e.g., categories), then DAs display the results. Both use VBA (with macros assigned to buttons/shapes) to sequence the steps & guide the user to “Now, enter data for new entries” & the like. FWIW: We don’t have big data. We’re using Excel primarily to speed business process flows, mash together data from different sources, & enable report readers to slice & dice dashboards & drill down into supporting detail. Love PQ, VBA, UserForms, DAs, Custom Data Types, LET, & data validation. We make little use of pivot tables, Power Pivot, & DAX, but that’s mostly a training deficiency in me (our report author). I started that learning curve when DAs, LET, & PowerApps came out (or I discovered their existence) & decided to set PP/DAX aside to learn them first.

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much, Jim! I intentionally kept this tutorial away from the power tools so that it would be useful to most Excel users. It also didn't really lend itself to using Power Pivot, but that's not to say you shouldn't :-)

Mynda, this is simply brilliant! Thank you for sharing this. You cover a huge amount of ground (pivot tables, formatting, workarounds, formatting, data clean up and analysis, formulas, to name a few!). You make me feel like I actually know Excel (I don't really, but I can follow your patient, thorough explanations and it's working brilliantly)! I wanted to say thank you and that you're appreciated no end! I've not seen anyone present Excel material as well as you do, though there may well be great videos out there. Best, T

@MyOnlineTrainingHub

8 ай бұрын

Thanks so much for your kind words, Terence! 🥰 It's great to hear you go so much value from this video.

Wow! I would never have believed you could do something like that in Excel. Wow! Mynda you are a genius.

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much 😊

I learned more from you now than in years of using excel myself. Thank you!

@MyOnlineTrainingHub

2 жыл бұрын

Wow, so pleased to hear that, Simone!

Dios te tenga en la gloria mujer!!! Mereces ser beatificada... Muchísimas gracias por tomarte el trabajo de realizarlo y compartirlo... Por mas gente así en la comunidad Feliz de haberla encontrado!

@MyOnlineTrainingHub

Жыл бұрын

Gracias!

This tutorial is fantastic. I am not even a novice in Excel, but looking at this beautiful and interactive dashboard, I'm going to learn it and create one for my household. Many many thanks!!!

@MyOnlineTrainingHub

2 жыл бұрын

Glad it was helpful!

@jk6343

Жыл бұрын

Am gonna do the same

OMG, I'm so impressed!!!!! I've seen a lot of videos for my homework and you're the only one can do the Treemap like that! Thank u

@MyOnlineTrainingHub

Жыл бұрын

So pleased you enjoyed it 🙏

Thanks for the great video Mynda! This will be a great personal project, much appreciated, Dave.

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear, Dave! 😊

I love this fancy dashboard. More tricks learned with PT charts. Thanks so much!

@MyOnlineTrainingHub

2 жыл бұрын

Glad you like it!

Love the shirt! and your tutorial of course! Excited to follow this step by step. ❤

@MyOnlineTrainingHub

4 ай бұрын

Yay! Thank you!

Excellent tutorial. I always enjoy your dynamic dashboards.

@MyOnlineTrainingHub

2 жыл бұрын

Glad to hear that, Nick!

Great Job - Just spent the last 4 hours doing my own budget - this is the best tutorial by far on youtube - Thankyou

@MyOnlineTrainingHub

11 ай бұрын

Wow! Awesome to hear 🙏

Waterfall tip alone is crazy good! Thanks so much.

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear you liked it, Ben 😊

Fabulous! I wish I’d seen this while I was still working - could have used the techniques for my reporting work. I’m early retired now, and so will adapt this for my retirement expenses and income analyses

@MyOnlineTrainingHub

2 жыл бұрын

Glad you found it helpful 😊

Thank you so much. The way you deliver the tutorials is so engaging.

@MyOnlineTrainingHub

Жыл бұрын

Glad you liked it 🙏

Hi Mynda. What an awesome dashboard tutorial / mini-course! It is definitely full of multiple tips, tricks and techniques. Thanks so much for sharing this and providing the sample file to follow along. I learned a lot working through it and had fun, as well :)) Much appreciated! Thumbs up!!

@MyOnlineTrainingHub

2 жыл бұрын

So pleased to hear that, Wayne! 😊

Brilliant! I have been maintaining an excel of our household expenses but never thought to represent them like this. I already have a few ideas of modifications I will make. Never seen a tree map before and not sure I need that part but some excellent ideas. Thank you.

@MyOnlineTrainingHub

2 жыл бұрын

Glad you liked it, Alistair! 😊

Like Tony, I thought I was an Excel Expert, using functions, VBA, nested IF statements, and strong math formulea, and I came here just to be humbled. Perhaps in 20 years, I could be classified as a novice. Thank you Mynda.

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much for your kind words!

That Treemap trick might just be the most useful thing I've seen all year! Thanks!

@MyOnlineTrainingHub

2 жыл бұрын

Glad you liked it 😊

One word!!!! OUTSTANDING! Ok I have to say more, that was a truly mind blowng masterclass on what ou can do with Excel! Thanks for sharing!

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much for your kind words, Paul!

Very useful. And your effort to explain all these free including download is really appreciated. Thanks

@MyOnlineTrainingHub

4 күн бұрын

Glad it was helpful!

Fantastic tutorial. You always make it a piece of cake to create visulisations!

@MyOnlineTrainingHub

2 жыл бұрын

Thank you very much!

This video was awesome. It blew my mind. Thank you so much. Dashboards here I come!!!!😀

@MyOnlineTrainingHub

Жыл бұрын

So glad you enjoyed it, Veronica!

Your Excel skills (and teaching skills) are truly amazing. I used to work with vlookups, goalseek (and even recorded some macros) etc. back in 2003-2005 when I had a data crunching job and I thought I'm a pro user. Fast forward to 2024, I was still under the wrong impression that I know enough of Excel until I saw your videos which made me realize that perhaps I know just the tip of the iceberg of what Excel 365 offers....Thanks for your amazing eye-opening videos with lot of 'a-ha' moments!! You're truly splendid!

@MyOnlineTrainingHub

Ай бұрын

Wow! Thanks for your kind words 🥰 I'm so pleased you found my videos helpful.

Great video!! Something for me to try during the Christmas break. I love this channel. It’s always my go to!

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear 😊

WOW!! You are the best!! I learned so much tricks from this video. Appreciate you doing this. Thank you!

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear, Jimmy! 😊

Fantastic demonstration!! and one of the best videos I've ever seen on pivot tables and dashboards!! Wonderful!

@MyOnlineTrainingHub

10 ай бұрын

Wow, thanks so much!

You are amazing, first time in my life I watched this much simple explanation of interactive report in excel, what others are selling on the internet and earing you are giving it free. Thanks for being on this earht. 🥰

@MyOnlineTrainingHub

9 ай бұрын

Wow, thank you! 😊 Please share my video with your friends and coworkers.

“If I go too fast for you…”. LOL. If this were just about finance, fine, but this person is an excel magician, so more like start, stop, huh, wow, backup… start again. This was soooooo fun. Oh, and my analysis of last years expenses and creeping inflation was very, very helpful. Thank you so much.

@MyOnlineTrainingHub

Жыл бұрын

😁glad you found it helpful!

Thank you. Followed your guidance to letter and created an amazing dashboard, along the way discovered some anomalies with my finances. I recovered some vague payments. Additionally created a Treemap to link my detailed items spent with Paypal and Amazon. Works like a charm. Before, I was a complete luddite with Excel. THANK YOU SO MUCH.

@MyOnlineTrainingHub

7 ай бұрын

Wow, that's fantastic to hear!

I've used excel templates for many different things throughout the years, and if I couldn't find one the fit in my ovely picky requirementes I would make my own tables spending hours to perfect them, but yours are in a whole different level.

@MyOnlineTrainingHub

2 жыл бұрын

Glad you liked it!

Having short in words to appreciate the effort to make Dashboard like this

@MyOnlineTrainingHub

2 жыл бұрын

Thanks for your comment, Shahi!

This is beautiful and not nearly as intimidating after you start teaching it. Thanks!

@MyOnlineTrainingHub

Жыл бұрын

Glad it was helpful!

First off thank you for putting this video together. What an incredible video. There are so many topics that are covered here. Excellent presentation.

@MyOnlineTrainingHub

7 ай бұрын

So glad you enjoyed it! 🙏😊

This is fantastic, I have been using excel and google sheets for years and have never considered working with them the way you have here. Thanks for the video

@MyOnlineTrainingHub

Жыл бұрын

You're very welcome!

@49pattyortiz

Жыл бұрын

My thougths exactly! This is amazing!

Great video! Lots of helpful tips for creating dashboards.

@MyOnlineTrainingHub

2 жыл бұрын

Glad you enjoyed it, Savio!

Love this video - just discovered your channel through this particular video, now subscribed. Thank You!!

@MyOnlineTrainingHub

2 жыл бұрын

So pleased to hear that, Sean!

That’s very useful, you’re such a great person in the world, may God always bless you 😊

@MyOnlineTrainingHub

4 ай бұрын

Thank you! 😃

Awesome dashboard! Again... Thank you, Mynda!

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much 😊

Sensacional Dashboard, beautiful and useful. Thank you Mynda!

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much, Luciano!

Finally! Kudos KZread for giving me an excellent recommendation! This video is brilliant.

@MyOnlineTrainingHub

Жыл бұрын

Wow, thanks, Mark!

Simply brilliant! And very generous of you, thanks :-)

@MyOnlineTrainingHub

2 жыл бұрын

My pleasure, Max 😊

Fantastic resource and some great tips, always good to see how easy you make it look, thank you.

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much!

You are so kind to share all this work that really takes time, thank you so so much for this. 💛

@MyOnlineTrainingHub

11 ай бұрын

It's my pleasure 🙏

Love this training video - your ides will certainly brighten up my table! Thank you...

@MyOnlineTrainingHub

2 жыл бұрын

Fantastic to hear, David!

Mynda, another great video and more helpful tips and tricks, as always.

@jamesgerber7923

2 жыл бұрын

I do need to ask though, where can i get a green "I Simply Excel" shirt???

@MyOnlineTrainingHub

2 жыл бұрын

Glad you liked it, James 😊 you can get these t-shirts on redbubble.com.

Your videos are excellent! Thanks!

@MyOnlineTrainingHub

2 жыл бұрын

Glad you think so!

Fantastic tutorial, thanks so much!! Am absolutely going to implement this for my household.

@MyOnlineTrainingHub

2 жыл бұрын

Awesome to hear 😊

Fantastic. Picked up several awesome tips, tricks and techniques. Presentation style wonderful as well.

@MyOnlineTrainingHub

2 жыл бұрын

Awesome, thank you!

Loving this and adding this to my everyday use. Thank you!

@MyOnlineTrainingHub

2 жыл бұрын

Great to hear, Chris!

Hi Mynda!Great Tips And Tricks Plus A Cool Looking Dashboard...Thank You :)

@MyOnlineTrainingHub

2 жыл бұрын

Cheers, Darryl! 😊

Thank you so much. Your videos are so informative!

@MyOnlineTrainingHub

2 жыл бұрын

Glad you like them!

As ALWAYS your presentation was REALLY REALLY great 😉

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much 😊

I really appreciate this tutorial. You just got a new subscriber!

@MyOnlineTrainingHub

2 жыл бұрын

Awesome, thank you and welcome!

You amazed me with your skills. 🙏🏼🤩 and for that reason, I subscribed. ⭐️⭐️⭐️⭐️⭐️🤓

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much 🙏

Absolutely fantastic job!!! Thank you very much and more dashboards please ;)

@MyOnlineTrainingHub

2 жыл бұрын

Thanks, will do! But also don't forget my Excel Dashboard course: www.myonlinetraininghub.com/excel-dashboard-course

Thank you! Have been looking for this type of excel sheet for a long time

@MyOnlineTrainingHub

2 жыл бұрын

Glad it’ll be useful 😊

You are just awesome. That is one word how I can describe your excel skills.

@MyOnlineTrainingHub

2 жыл бұрын

Thank you so much 😀

That was simply amazing, thank you for making this content. I learned so much!

@MyOnlineTrainingHub

Жыл бұрын

Glad you enjoyed it!

That was slick! I learned quite a bit, thank you.

@MyOnlineTrainingHub

Жыл бұрын

Glad to hear it!

Thank you so much. Excellent Video!!!

@MyOnlineTrainingHub

5 ай бұрын

Glad it was helpful!

Not much into excel but Im helping my brothers business keep his books in check and this vid was amazingly helpful. A comment a like and a sub.

@MyOnlineTrainingHub

Жыл бұрын

Great to hear!

Thank you. Great video. Helped me a lot!

@MyOnlineTrainingHub

Жыл бұрын

Great to hear!

Thank you for sharing this amazing video. Definitely, I will practice this one also.

@MyOnlineTrainingHub

2 жыл бұрын

You're so welcome!

Amazing Excel Example, Truly impressive

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much, Jim!

This was epic Mynda!!

@MyOnlineTrainingHub

2 жыл бұрын

😁 thanks, Chris!

Absolutely amazing! Thank you

@MyOnlineTrainingHub

Жыл бұрын

You're very welcome!

Thank you Mynda 🙏

@MyOnlineTrainingHub

2 жыл бұрын

My pleasure 😊

Thank you for fantastic and simply tutorial. Easy to understand.

@MyOnlineTrainingHub

Жыл бұрын

Glad you liked it 😊

You are awesome Mynda. Thanks to share your knowledge, time and joy with us. Thumbs Up from Brazil girl, yeeeh 😁😆😅

@MyOnlineTrainingHub

2 жыл бұрын

You are so welcome! 😊

Wow! Seriously inspired, top notch tutorial.

@MyOnlineTrainingHub

Жыл бұрын

Glad you liked it 😊

Don't know who you are, or how I came across this video, but my 2022 finances will be better for it! Thank you, and you are awesome!

@MyOnlineTrainingHub

2 жыл бұрын

You are most welcome!

You are the “the guy” !!!!!!! 🎉 Now i can do it ! Thank you very much !

@MyOnlineTrainingHub

8 ай бұрын

Awesome to hear!

25:07 My progress Tysm bc without this vid i can't do my task keep making usefull vid :)

@MyOnlineTrainingHub

11 ай бұрын

Glad it has been helpful!

Another amazing video, thank you

@MyOnlineTrainingHub

Жыл бұрын

Glad you enjoyed it!

Brilliantly done. Thanks for sharing.

@MyOnlineTrainingHub

9 ай бұрын

Thanks for watching!

Nice! Thank you for this. I did rebuild to fit me a little better and with a darker theme. Super cool

@MyOnlineTrainingHub

2 жыл бұрын

Glad it was helpful, Gerardus!

Another masterpiece. Thank you for sharing

@MyOnlineTrainingHub

2 жыл бұрын

Thanks so much, Sophie!

Thank you very much, this is extremely helpful. Very professional!

@MyOnlineTrainingHub

Жыл бұрын

Great to hear, Frank!

Thanks for such wonderful video.🙏

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 🙏