Interactive Personal Finance Dashboard with FREE EXCEL TEMPLATE

  Рет қаралды 1,056,103

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

🔻 DOWNLOAD EXCEL FILE HERE: www.myonlinetraininghub.com/i...
Visualise, keep track of and manage where you’re spending your money with this interactive Excel personal finance dashboard.
🎓 LEARN MORE: Take my Dashboard course: www.myonlinetraininghub.com/e...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction
1:00 The Data
3:44 Headline Figures and Images
11:33 Doughnut Chart
14:41 Dual Column Chart
19:20 Line Chart
21:33 Treemap Chart
24:34 Waterfall Chart
28:06 Top 5 Conditional Formatting Data Bars
30:08 Slicers
33:05 Dynamic Chart Labels
39:25 Updating with One Click!

Пікірлер: 1 000
@tonysicily2687
@tonysicily2687 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
So pleased you enjoyed it, Tony!
@adelekedeborah316
@adelekedeborah316 2 жыл бұрын
It's almost confusing me really. Excel is wide!
@YuccaTrash79
@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.
@barbaraschmidt8204
@barbaraschmidt8204 2 жыл бұрын
Your tutorials are fantastic. I watched this over and over while rebuilding it. Thank you so much for your videos!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear 😊
@VictoriaRodgersK
@VictoriaRodgersK 2 жыл бұрын
This is by far the best expense overview/budget overview setup I've seen! I love how visual it is!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for your kind words, Victoria!
@2mdallas
@2mdallas Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
Wow, thanks for your super kind words! Please check out my other dashboard videos too: kzbin.info/www/bejne/gWiXkHmEo9F8fJo
@2mdallas
@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
@cassioalexan
@cassioalexan 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Glad it’ll be useful, Cassio! 😊
@hit0kiriSigma
@hit0kiriSigma Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
Great to hear it will be useful to you!
@ToddGallant
@ToddGallant 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear, Todd! 😊
@pabloperezpascual7863
@pabloperezpascual7863 Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
Wow, that's awesome to hear, Pablo! I'm so pleased my tutorial has been so helpful to you.
@samrajeh9076
@samrajeh9076 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Glad you enjoy them, Sam! My courses also include examples based on real cases and more.
@kolavithonduraski5031
@kolavithonduraski5031 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
So pleased you find our tutorials helpful 🙏
@jujubeaning
@jujubeaning 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure 😊 glad you found me!
@terenceduplessis9439
@terenceduplessis9439 10 ай бұрын
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
@MyOnlineTrainingHub 10 ай бұрын
Thanks so much for your kind words, Terence! 🥰 It's great to hear you go so much value from this video.
@heavyMetal1720
@heavyMetal1720 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for the tip 😊
@barbaraharris1212
@barbaraharris1212 2 жыл бұрын
Y'all come up with the best ideas! You have taught me so much through these videos. Thank you!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Awesome! Thank you!
@Sandvink
@Sandvink Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
That's wonderful to hear!
@ricos1497
@ricos1497 2 жыл бұрын
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
@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
@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
@MyOnlineTrainingHub 2 жыл бұрын
Yes, that would be handy too!
@jimfitch
@jimfitch 2 жыл бұрын
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
@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
@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
@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 :-)
@Slindo_M
@Slindo_M 5 ай бұрын
Never thought I’d enjoy an Excel tut. This is pure Gold
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Awesome to hear 😁
@gwargumm9511
@gwargumm9511 11 ай бұрын
This is by far the best KZbin video on excel personal finance dashboards. Thank you for your generosity in sharing this knowledge and the free template!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 ай бұрын
Wow, thanks!
@davecope3322
@davecope3322 2 жыл бұрын
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
@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
@davecope3322 2 жыл бұрын
@@MyOnlineTrainingHub Thanks Mynda
@10G3x7
@10G3x7 7 күн бұрын
Who understands excel, understands everything in this world!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 күн бұрын
True dat! 😁
@tuarani1455
@tuarani1455 Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
😊 glad you enjoyed it, Tua!
@ImperialArmour
@ImperialArmour 2 жыл бұрын
I like how you're making data analysis dashboarding accessible for everyone.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much 😊
@sandettielimited8747
@sandettielimited8747 2 жыл бұрын
Wow! I would never have believed you could do something like that in Excel. Wow! Mynda you are a genius.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much 😊
@simonepace71
@simonepace71 2 жыл бұрын
I learned more from you now than in years of using excel myself. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Wow, so pleased to hear that, Simone!
@gfacekilla01
@gfacekilla01 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Glad it was helpful!
@jk6343
@jk6343 Жыл бұрын
Am gonna do the same
@cd8599
@cd8599 3 ай бұрын
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
@MyOnlineTrainingHub 3 ай бұрын
Wow! Thanks for your kind words 🥰 I'm so pleased you found my videos helpful.
@alistairstanger2940
@alistairstanger2940 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it, Alistair! 😊
@thuhuong5451
@thuhuong5451 Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
So pleased you enjoyed it 🙏
@wayneedmondson1065
@wayneedmondson1065 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
So pleased to hear that, Wayne! 😊
@GratefulThird
@GratefulThird 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Glad you found it helpful 😊
@geensjc
@geensjc 2 жыл бұрын
Great video!! Something for me to try during the Christmas break. I love this channel. It’s always my go to!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear 😊
@arpanatikekar8699
@arpanatikekar8699 2 жыл бұрын
Fantastic tutorial. You always make it a piece of cake to create visulisations!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thank you very much!
@gary8022
@gary8022 Жыл бұрын
Great Job - Just spent the last 4 hours doing my own budget - this is the best tutorial by far on youtube - Thankyou
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Wow! Awesome to hear 🙏
@giangluong8185
@giangluong8185 2 жыл бұрын
I love this fancy dashboard. More tricks learned with PT charts. Thanks so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you like it!
@GonzaCN
@GonzaCN 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Gracias!
@davegoodo3603
@davegoodo3603 2 жыл бұрын
Thanks for the great video Mynda! This will be a great personal project, much appreciated, Dave.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear, Dave! 😊
@whazee
@whazee 2 жыл бұрын
That Treemap trick might just be the most useful thing I've seen all year! Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it 😊
@amirawn1
@amirawn1 11 ай бұрын
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
@MyOnlineTrainingHub 11 ай бұрын
Wow, thank you! 😊 Please share my video with your friends and coworkers.
@Paul-Thomas-LifeCoach
@Paul-Thomas-LifeCoach 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much for your kind words, Paul!
@denorrisd
@denorrisd Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
You're very welcome!
@49pattyortiz
@49pattyortiz Жыл бұрын
My thougths exactly! This is amazing!
@DaKussh
@DaKussh 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it!
@stanleyc50
@stanleyc50 Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
Thanks so much for your kind words!
@martindavoodi5908
@martindavoodi5908 2 жыл бұрын
Fantastic tutorial, thanks so much!! Am absolutely going to implement this for my household.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Awesome to hear 😊
@hungarianzozo
@hungarianzozo 9 ай бұрын
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
@MyOnlineTrainingHub 9 ай бұрын
Wow, that's fantastic to hear!
@jimmyjohn1523
@jimmyjohn1523 2 жыл бұрын
WOW!! You are the best!! I learned so much tricks from this video. Appreciate you doing this. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear, Jimmy! 😊
@engt1000
@engt1000 9 ай бұрын
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
@MyOnlineTrainingHub 9 ай бұрын
So glad you enjoyed it! 🙏😊
@praveennishahenry5131
@praveennishahenry5131 Жыл бұрын
Thank you so much. The way you deliver the tutorials is so engaging.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it 🙏
@nickkaskarelis8995
@nickkaskarelis8995 2 жыл бұрын
Excellent tutorial. I always enjoy your dynamic dashboards.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad to hear that, Nick!
@seanmorrow7306
@seanmorrow7306 2 жыл бұрын
Love this video - just discovered your channel through this particular video, now subscribed. Thank You!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
So pleased to hear that, Sean!
@benjenkins2415
@benjenkins2415 2 жыл бұрын
Waterfall tip alone is crazy good! Thanks so much.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear you liked it, Ben 😊
@noemie3049
@noemie3049 6 ай бұрын
Love the shirt! and your tutorial of course! Excited to follow this step by step. ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Yay! Thank you!
@jeremytalbot8915
@jeremytalbot8915 Жыл бұрын
Fantastic demonstration!! and one of the best videos I've ever seen on pivot tables and dashboards!! Wonderful!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Wow, thanks so much!
@mishellsanz372
@mishellsanz372 Жыл бұрын
You are so kind to share all this work that really takes time, thank you so so much for this. 💛
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
It's my pleasure 🙏
@eileeno2947
@eileeno2947 Жыл бұрын
“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
@MyOnlineTrainingHub Жыл бұрын
😁glad you found it helpful!
@nonamemcgee4842
@nonamemcgee4842 Жыл бұрын
This is beautiful and not nearly as intimidating after you start teaching it. Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@kenbarbour3841
@kenbarbour3841 2 жыл бұрын
Fantastic. Picked up several awesome tips, tricks and techniques. Presentation style wonderful as well.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Awesome, thank you!
@VeronicaSanchez-qt1zf
@VeronicaSanchez-qt1zf Жыл бұрын
This video was awesome. It blew my mind. Thank you so much. Dashboards here I come!!!!😀
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
So glad you enjoyed it, Veronica!
@watcharachaimongkolrat736
@watcharachaimongkolrat736 Ай бұрын
thank you for million times. your clearly explanation with a very good example give me better understanding even though i am just a beginner for this dashboard. Again thanks for your creative way to draw this dashboard, i can have many ideas to do mine.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
You're very welcome!
@clivepiper2
@clivepiper2 Жыл бұрын
Fantastic resource and some great tips, always good to see how easy you make it look, thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much!
@shoaibwarriah
@shoaibwarriah 2 жыл бұрын
Having short in words to appreciate the effort to make Dashboard like this
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for your comment, Shahi!
@christaylor7943
@christaylor7943 2 жыл бұрын
Loving this and adding this to my everyday use. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear, Chris!
@daves902
@daves902 2 жыл бұрын
Love this training video - your ides will certainly brighten up my table! Thank you...
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Fantastic to hear, David!
@activeresidence
@activeresidence 2 жыл бұрын
Absolutely fantastic job!!! Thank you very much and more dashboards please ;)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks, will do! But also don't forget my Excel Dashboard course: www.myonlinetraininghub.com/excel-dashboard-course
@lrmastertech
@lrmastertech 2 жыл бұрын
Thank you! Have been looking for this type of excel sheet for a long time
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad it’ll be useful 😊
@JacobvijaykumarA
@JacobvijaykumarA Ай бұрын
Very useful. And your effort to explain all these free including download is really appreciated. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad it was helpful!
@Bennyoutnabout
@Bennyoutnabout Жыл бұрын
That was simply amazing, thank you for making this content. I learned so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you enjoyed it!
@muhammadakmalikramudin8659
@muhammadakmalikramudin8659 6 ай бұрын
That’s very useful, you’re such a great person in the world, may God always bless you 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Thank you! 😃
@maxf5868
@maxf5868 2 жыл бұрын
I really appreciate this tutorial. You just got a new subscriber!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Awesome, thank you and welcome!
@chillers_2641
@chillers_2641 Ай бұрын
Very comprehensive and easy to understand tutorial. Thank you very much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you enjoyed it!
@Luciano_mp
@Luciano_mp 2 жыл бұрын
Sensacional Dashboard, beautiful and useful. Thank you Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much, Luciano!
@savioseona
@savioseona 2 жыл бұрын
Great video! Lots of helpful tips for creating dashboards.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you enjoyed it, Savio!
@ssss54
@ssss54 2 жыл бұрын
You are just awesome. That is one word how I can describe your excel skills.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thank you so much 😀
@deepanshi4321
@deepanshi4321 2 жыл бұрын
Thank you for sharing this amazing video. Definitely, I will practice this one also.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
You're so welcome!
@jamesgerber7923
@jamesgerber7923 2 жыл бұрын
Mynda, another great video and more helpful tips and tricks, as always.
@jamesgerber7923
@jamesgerber7923 2 жыл бұрын
I do need to ask though, where can i get a green "I Simply Excel" shirt???
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it, James 😊 you can get these t-shirts on redbubble.com.
@BananaBobMinion
@BananaBobMinion Жыл бұрын
Thank you for the GREAT video. I will try and make my own sheet with this tutorial. I am just a beginner and hope to learn more from your videos in the future.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful! Have fun building your dashboard 😊
@Inquire98
@Inquire98 2 жыл бұрын
As ALWAYS your presentation was REALLY REALLY great 😉
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much 😊
@shauncamilleri4451
@shauncamilleri4451 2 жыл бұрын
Brava!!!!! Thank you very much for this. I plan to use the ideas from here to make a year slicer rather than a month slicer.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad it was helpful!
@markjosephvillanueva
@markjosephvillanueva Жыл бұрын
Finally! Kudos KZbin for giving me an excellent recommendation! This video is brilliant.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Wow, thanks, Mark!
@Musashiden
@Musashiden Жыл бұрын
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
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@motogoa
@motogoa 2 жыл бұрын
Simply brilliant! And very generous of you, thanks :-)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure, Max 😊
@itorres008
@itorres008 2 жыл бұрын
Good job, thanks! It's remarkable how, after you explain the build, you just give the finished model away. I have built something functionally similar over time. Handles a bit more accounting and statements, but doesn't have the visual flair bc it's just for me. I am introducing some of your ideas into my model. Thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
So pleased you found it helpful 😊
@darrylmorgan
@darrylmorgan 2 жыл бұрын
Hi Mynda!Great Tips And Tricks Plus A Cool Looking Dashboard...Thank You :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Cheers, Darryl! 😊
@Devi1D0g04
@Devi1D0g04 2 жыл бұрын
Nice! Thank you for this. I did rebuild to fit me a little better and with a darker theme. Super cool
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad it was helpful, Gerardus!
@MrNotfake
@MrNotfake 2 жыл бұрын
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
@MyOnlineTrainingHub 2 жыл бұрын
You are most welcome!
@dcbarry101
@dcbarry101 2 жыл бұрын
Thank you so much. Your videos are so informative!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you like them!
@daliladuf
@daliladuf 2 жыл бұрын
Awesome dashboard! Again... Thank you, Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much 😊
@dsaint2one
@dsaint2one Жыл бұрын
You amazed me with your skills. 🙏🏼🤩 and for that reason, I subscribed. ⭐️⭐️⭐️⭐️⭐️🤓
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much 🙏
@lck2978
@lck2978 Жыл бұрын
It took me a few days, but I finally finished this! Like others on here, I love having a visual representation of where my money is going. Then being able to view trends and habits. What a great tutorial! Thanks again for sharing such an enormous wealth of information! There is so much to learn along the way too, that may not be a focus in the video. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Congratulations on building your own personal finance dashboard! I'm so pleased you found this video helpful 😊
@mrajiu
@mrajiu Жыл бұрын
Dont waste your time in any course other than this amazing ladies videos. You are a star mam
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thank you so much 🙂
@ThePhobosMusic
@ThePhobosMusic Жыл бұрын
I saw the preview and thought "ye, no way this is Excel", damn that was impressive, I'm gonna do it one of these days, thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it 😊
@bracho86
@bracho86 Жыл бұрын
Great video! appreciate i just learned a LOT! i just started to create my own dashboard using your techniquesm thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@nafiibrahimaj8870
@nafiibrahimaj8870 2 жыл бұрын
you did a magnificent work, I appreciate what you did, I thank you so much for such useful shared information. thank you so much.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure :-)
@kevinerose
@kevinerose 6 ай бұрын
I've been wondering why Excel always makes my shapes come in with filled in colors. Now I know. "Dashboards!". I look forward to making my own Dashboards now. I already know all the techniques we went through but just now learning about using them all together in Dashboards. I was initially annoyed by the changes Excel did with shapes but now I am loving it and understand why they made the change. For me, it is really more a design concept which is where I need the extra practice.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you enjoyed it, Kevin!
@tpsmith
@tpsmith Жыл бұрын
That was slick! I learned quite a bit, thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad to hear it!
@MasterBrain182
@MasterBrain182 2 жыл бұрын
You are awesome Mynda. Thanks to share your knowledge, time and joy with us. Thumbs Up from Brazil girl, yeeeh 😁😆😅
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
You are so welcome! 😊
@vasinnilyok7535
@vasinnilyok7535 2 жыл бұрын
Thank you for fantastic and simply tutorial. Easy to understand.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it 😊
@jameseichbaum
@jameseichbaum 2 жыл бұрын
Great video - opened my eyes to what excel can do!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you enjoyed it!
@ajzambranop
@ajzambranop 2 жыл бұрын
Your videos are excellent! Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you think so!
@Sams0040
@Sams0040 2 жыл бұрын
Thanks a lot for sharing this excellent course. Like it so much.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear 😊
ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template)
33:20
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 143 М.
Самый Молодой Актёр Без Оскара 😂
00:13
Глеб Рандалайнен
Рет қаралды 12 МЛН
Finger Heart - Fancy Refill (Inside Out Animation)
00:30
FASH
Рет қаралды 25 МЛН
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 33 МЛН
Best Budget Apps for Families (2024) RIP Mint 🙏
12:10
Marriage Kids and Money
Рет қаралды 155 М.
Make an Awesome Excel Dashboard in Just 15 Minutes
15:27
Kenji Explains
Рет қаралды 1,1 МЛН
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
The Mistake Almost EVERY Excel User Makes (Free File)
10:16
MyOnlineTrainingHub
Рет қаралды 149 М.
High-Income Excel Skills Worth Learning in 2024 (Free File)
29:19
MyOnlineTrainingHub
Рет қаралды 343 М.
How to Start Making Money with Excel (For All Skill Levels)
6:09
MyOnlineTrainingHub
Рет қаралды 65 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 270 М.
5 HIDDEN Excel Tools Almost Nobody Is Talking About
9:00
MyOnlineTrainingHub
Рет қаралды 41 М.
Здесь упор в процессор
18:02
Рома, Просто Рома
Рет қаралды 431 М.
Хакер взломал компьютер с USB кабеля. Кевин Митник.
0:58
Последний Оплот Безопасности
Рет қаралды 1,4 МЛН
iPhone 15 Pro в реальной жизни
24:07
HUDAKOV
Рет қаралды 469 М.
ОБСЛУЖИЛИ САМЫЙ ГРЯЗНЫЙ ПК
1:00
VA-PC
Рет қаралды 2,5 МЛН