Thanks Power Query Unpivot - fix 4 common data layouts 2017 06 05 kzitem.info/news/bejne/jn-D15-dbGeSl3Y 19min23 00:00 intro 00:40 - Ideal format, Tabular 00:57 - Step by step instructions in downloaded example file 01:05 - Sales info by person by year with row totals 01:40 - How to start PowerQuery 02:00 - PowerQuery Editor Window 02:50 - Unpivot the year columns 03:49 - Rename Columns 04:05 - Change data types 04:25 - Rename Query 04:32 - Close and Load 04:48 - Refresh query output table 06:13 - Example 2: Partial tabular, repeating columns monthly hours and costs 06:42 - load to PowerQuery 07:00 - Unpivot the “values” columns 07:28 - Split month out to separate column: Split Column feature 08:02 - Pivot the Attribut column to separate Hours and Costs 08:39 - Close and Load to Excel 09:13 - Example 3: column headings over 2 rows 09:45 - Format data as table 10:18 - Load to PowerQuery 10:21 - Merge 2 header rows into 1, Transpose data 10:43 - Merge the first columns 10:50 - Fill down month values 11:04 - Perform merge: Transform tab > Text Columns group > Merge Columns command 12:05 - Trim leading spaces 12:10 - transpose back 12:14 - Promote first row to become header 12:27 - Unpivot 12:48 - Split month out of attribute column 12:57 - Trim unwanted space at front of column/ 13:03 - Pivot the attribute column to split Account hours and account costs 13:16 - Rename columns 13:20 - Close and Load 13:50 - Example 4: Stacks of repeating rows 14:25 - Convert data to table 14:38 - Load to PowerQuery 14:44 - Filter to delete blank rows and total rows 15:14 - Add index column for unique numbers 15:33 - Pivot Column don’t aggregate 15:56 - Values now in staggered stacks with null values between rows 16:19 - Fill up: Transform tab > Table group > Fill up button 16:41 - review result, filled rows 17:00 - Delete duplicate rows with null values 17:09 - Remove Index column 17:16 - format date column as date only 17:44 - close and load . Keep up the good work.
@MyOnlineTrainingHub
4 жыл бұрын
Thanks so much for sharing, Ross! Perhaps I should give you a job :-)
@damienadams2430
2 жыл бұрын
Hhhvohhhh. Hhhohv
@damienadams2430
2 жыл бұрын
Hhhvohhhh. Hhhohvv
@gungurung36
2 жыл бұрын
.
@jasonjackson4555
3 жыл бұрын
This video almost made me cry. This is going to be a massive time saver.
@MyOnlineTrainingHub
3 жыл бұрын
Wow, so pleased to hear that, Jason!
@aavv17
2 жыл бұрын
😢 just transposed some data yesterday from 20 columns into 400 rows. Did it now within 10mins! Thanks!
@ethofmeyr
Жыл бұрын
I watched this video 5 years ago and today it helped me with a task. These videos never lose their relevance. Thank you Mynda
@MyOnlineTrainingHub
Жыл бұрын
Wow, that's awesome to hear!
@dougmphilly
Жыл бұрын
same.
@flaviomelo530
4 жыл бұрын
This was the biggest amounts of "AHA's" I've said in ages! Amazing tutorial!
@MyOnlineTrainingHub
4 жыл бұрын
Awesome to hear, Flavio :-)
@ajzambranop
Жыл бұрын
Dear Mynda, You must be awarded the Accounting Data Cleaning Nobel Prize for this video at the very least! Thanks! :-)
@MyOnlineTrainingHub
Жыл бұрын
😁thanks so much!
@jared_musicSTC
4 жыл бұрын
this just blew my mind. I've solved so many of these problems by manually copy and pasting data over the years! 🤯
@MyOnlineTrainingHub
4 жыл бұрын
No more copying and pasting now then, Jared :-) Glad it'll save you some time.
@serdip
6 ай бұрын
Thanks for another extremely informative and practical Excel mastery video. I started teaching myself Power Query only a few months ago, after over 27 years as an Excel developer. I can honestly say that there's no turning back. Power Query will forever change how I interact with my favorite spreadsheet program. Thank you for explaining each of these common scenarios in concise and clear terms. Everything makes sense as you presented it. I think for me, the main challenge is to develop the insight and intuition to know which Power Query menu options to use and in what sequence. It is not always immediately obvious to me when to pivot/unpivot/transpose - sometimes repeatedly - to rearrange the data into a final tabular format ready for analysis. I've done dozens of Power Query exercises on datasets just like the ones you covered in the lecture. I guess I will get better at it with continued practice and patience. Sometimes I end up writing complex but effective custom reusable M Code functions to arrive at the desired result, only to find out later that it could have been accomplished strictly through the UI! 🙂 Thank you!
@MyOnlineTrainingHub
6 ай бұрын
Great to hear! I know what you mean about knowing which tools to use in what order is not always obvious, but in time you'll become adept at it. 😊
@gregbernard7861
Жыл бұрын
Wow - the download file is awesome! Best I have ever seen / just went through all the examples with 100% success rate!
@MyOnlineTrainingHub
Жыл бұрын
Awesome to hear, Greg 🙏
@JM-zm6fl
4 жыл бұрын
Madam, you are an excellent teacher!
@maggiepeng4822
2 жыл бұрын
this video really help. I work with Excel everyday and am slowly transitioning to power query to make things more automatic. thank you !!
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear, Maggie!
@bindur1765
Жыл бұрын
grateful Mynda for these amazing excel tips. you are kind
@MyOnlineTrainingHub
Жыл бұрын
Glad you like them!
@jirinakotkova4954
4 жыл бұрын
Thank you a lot. This is going to speed up my work for sure. I really didn't know there was such an option like unpivot! My jaws literally dropped!
@MyOnlineTrainingHub
4 жыл бұрын
:-) great to hear!
@bernieofalia
3 жыл бұрын
Thanks for this... I was stuck for about a month in trying to solve the reapeted rows thing. your solution is AWESOME!
@MyOnlineTrainingHub
3 жыл бұрын
Glad it helped!
@learnitinstructor5792
4 ай бұрын
Incredible! I've been training PowerPivot, PowerQuery, PivotTables for a very long time and didn't know there were such amazing tools to fix these data issues! Wow! Thank you so much!
@MyOnlineTrainingHub
4 ай бұрын
Glad to help! 😊
@jiky4296
3 жыл бұрын
The best tutor I have seen
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much!
@deanar
2 жыл бұрын
Greatest video ever not even gonna lie , this will save me hours 😂😂😂
@MyOnlineTrainingHub
2 жыл бұрын
Wow, awesome to hear!
@roberth.9558
5 ай бұрын
Brilliant and well presented. Thank you, Mynda.
@MyOnlineTrainingHub
5 ай бұрын
Glad you enjoyed it! 🙏😊
@megamundus
2 жыл бұрын
after 4years and a half ... this video of yours is still fresh and absolutely useful Thank you
@MyOnlineTrainingHub
2 жыл бұрын
So pleased to hear that!
@skd5432
5 жыл бұрын
Absolutely no expression....on my face. Well explained such a great video and contribution to the world of excel users.
@Blackgirl-in-Data
Жыл бұрын
Thank you for this! I'm literally screaming with joy over being able to get the nested columns done.
@MyOnlineTrainingHub
Жыл бұрын
Awesome to hear!
@felipe4181
3 жыл бұрын
These are perfect examples to solve many of the every day's issues when managing data models!!! Thank you Mynda!
@MyOnlineTrainingHub
3 жыл бұрын
You're very welcome!
@rdaleprice7184
3 жыл бұрын
Excellent video on Unpivot! Thank you for sharing the video!!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it!
@michaelpammit8647
2 жыл бұрын
Mynda, thank you for this video! You've changed my life. Over this weekend, I had to pull data from over 400 bi-weekly print-formatted timecards made in excel. They each had 2 non-formatted tables of weeks, and separate rows for each department worked in (thankfully, column & row numbers were consistent for all of them). Using a combination of your pivot scenarios plus your "multiple files containing multiple sheets" video, I was able to get the data from ALL of the timecards in tabular format (one row per dept-date-hours) in just about 8 hours' work! And I can just refresh the query as new timecards are added! Not to mention all the error-catching utility. Thank you!!!
@MyOnlineTrainingHub
2 жыл бұрын
So pleased to hear that, Michael!
@davidlee6139
2 жыл бұрын
Y
@davidlee6139
2 жыл бұрын
We
@vicBanga
2 жыл бұрын
The best and easy to understand video on this topic! thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear 🙏
@brunonapoleao3362
6 ай бұрын
Excellent content and teaching!! Congratulations and thank you very much for sharing this knowledge.
@MyOnlineTrainingHub
6 ай бұрын
Glad it was helpful! 🙏😊
@PrakashMurugamalai
Жыл бұрын
Wow ❤ It is amazing how you have shared such valuable knowledge with everyone. Thank you so much. The internet thrives because of people like you.
@MyOnlineTrainingHub
Жыл бұрын
So nice of you!
@mdexcelpro8495
4 жыл бұрын
The way you present is awesome thanks of lots 😊
@MyOnlineTrainingHub
4 жыл бұрын
Thank you 😊
@raghavan265
2 жыл бұрын
I work as a Power BI developer and I'm a fresher. Today I encountered a similar problem at my work and BAM! You're video just saved me so many hours of research! Thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear 😊
@jengiuliano1143
2 жыл бұрын
This was excellent! I always learn SO MUCH from you so THANK YOU again!
@MyOnlineTrainingHub
2 жыл бұрын
You are most welcome, Jen!
@ChengVincentckf
Жыл бұрын
I searched the last scenario for days and you finally show me how to do it. Thank you!
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful 😊
@silvo4880
5 ай бұрын
You are awesome, thank you. The repeating data issue has been driving me mad for weeks. I love the fill up method idk why I never thought of it as I’ve been using fill down.
@MyOnlineTrainingHub
5 ай бұрын
Glad it helped!
@matttownsend7119
5 ай бұрын
Two thumbs up from me. I've been working with Excel since the start, and did in fact have to hand massage lots of data sets manually or with the complex formulae you mention. If Power Query had been available then I would have saved months of work.
@MyOnlineTrainingHub
5 ай бұрын
Yeah, I hear you 😔
@christophwissing4877
Ай бұрын
Very very very helpful lesson for training my power query skills every weekend - hopefully I can use it at my work between the weeks :-). Also very pleasant that the file is available, thank you so much for that !!! 😊
@MyOnlineTrainingHub
Ай бұрын
Awesome! Have fun with Power Query!
@KaiHakai
Жыл бұрын
thank you so much. from your presentation I have found solutions from my bottleneck facing in day to day work
@MyOnlineTrainingHub
Жыл бұрын
Great to hear I could help!
@mdmahtabuddin9721
2 жыл бұрын
You don't know Dear, how much you save my times? Thank You soo much.
@MyOnlineTrainingHub
2 жыл бұрын
Wonderful to hear!
@sjd7aa
2 жыл бұрын
Brilliant! The more of your videos I watched the more impressed I am with Power Query's capabilities, to say nothing of the easy-to-follow and effective teaching methods you employ. Great work, and thank you! I am making a mental note of the work I can save, having previously used a witches' brew of clunky formulae to harvest data that I have to re-familiarize with each time I do the occasional work. Pity I can only upvote you once on this.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for your kind words, Steve! Great to hear you will have lots of uses for Power Query 😊
@sjd7aa
2 жыл бұрын
@@MyOnlineTrainingHub It's been a great learning experience for the past week. I joined your site and posted a question there, and I'm hoping to get some guidance on my little project (where PQ reduced my data collection/massaging time from 5 minutes - with risk of errors - to 18 SECONDS, error-free). Ciao, Mynda!
@rawshanali.bangladesh
3 жыл бұрын
Thank you Ma'am. I try to watch all your videos. I have learned power query, dashboard, advance pivot, pivot chart from your video. It helped me a lot to do my work properly and more efficiently and it makes my life easy and shortens my report making procedures.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Rawshan!
@doylemaleche9937
4 жыл бұрын
The BEST example to keep as reference! VERY professional and easy to follow. THANK YOU !!
@MyOnlineTrainingHub
4 жыл бұрын
Glad it was helpful!
@daisyye7254
3 жыл бұрын
THIS IS SO HELPFUL!!!! THANK YOU SOOOOOO MUCH!!!!!!!!!!!!!!!!
@MyOnlineTrainingHub
3 жыл бұрын
So happy I could help, Daisy!
@jamiebell5816
4 жыл бұрын
Thank you so much. I've recently started an online business that involves Microsoft Excel Power Query and your video was definitely an inspiration for that. Awesome teacher. I'd recommend you any day.
@MyOnlineTrainingHub
4 жыл бұрын
Thanks for your kind words, Jamie! Good luck with your new business :-)
@Acheiropoietos
3 жыл бұрын
This series is incredibly helpful for me. I always shied away from tables and pivot tables, but now I have the poweeeeerrrr! 💕
@MyOnlineTrainingHub
3 жыл бұрын
:-) great to hear!
@aphastus
3 жыл бұрын
First of all, it’s incredible how it looks like every problem has a solution with this method, how someone thought of all the options. Second, you’re a godsent, Miss, you’re my favorite Excel and data youtuber. I just sent a comment in another video about me having a problem with a very messy table and YT recommended me this video (I haven’t had seen yet) in my TL. This made me realize I have to keep practicing, there’s a lot to learn!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for your kind words!
@nkfore
4 жыл бұрын
One of the best PQ videos I've seen on here and easy to follow. THANK YOU!
@fabiolac67
23 күн бұрын
Thank you so much!!!! This video (and all your videos) are amazing!!!
@MyOnlineTrainingHub
23 күн бұрын
Thanks so much!
@dr.sushilkumarph.d.8186
11 сағат бұрын
most useful video......thanks to Mynda....
@MyOnlineTrainingHub
2 сағат бұрын
So nice of you 🙏
@hajasahib8943
4 жыл бұрын
I have to learning More Excel, from you.....
@MyOnlineTrainingHub
4 жыл бұрын
Glad to hear that, Haja!
@nishpreet85
5 жыл бұрын
I am an excel enthusiast and was soooo excited watching this video...I absolutely loved it... learned something so complex in such understanding and well explained tutorial... Thank you so much...
@MyOnlineTrainingHub
5 жыл бұрын
Thank you! Glad I could help. Please share this with your colleagues. We need to spread the word about how amazing Power Query is.
@ChinyeretheDataGirl
Жыл бұрын
Nice content . Please always share your dataset so that we can practice along
@MyOnlineTrainingHub
Жыл бұрын
Thank you. You can get the workbook here: www.myonlinetraininghub.com/power-query-unpivot-scenarios
@Bourouwe
4 жыл бұрын
You're extraordinary on handling data with Excel! I love your videos and thank you infinitely!
@MyOnlineTrainingHub
4 жыл бұрын
Thank you! I'm glad you found the video helpful :-)
@jezdel6298
2 ай бұрын
thanks for sharing this. you are heaven sent.
@MyOnlineTrainingHub
2 ай бұрын
You are so welcome 🤗
@zaighamuddinfarooqui1705
6 ай бұрын
Thanks, few days ago I was in search of transforming data as your last example but failed. I have asked the way out from a well known forum but no response was given to me till today. However I have made it by the help of PQ and formulas in excel. If I came to this video then I could safe me from a lot of hard working. I have learned a lot from your tutorials. Thanks again.
@MyOnlineTrainingHub
6 ай бұрын
Glad it helped! Better late than never 😊
@stephenmascarenhas1987
3 жыл бұрын
Fantastic explanation with different scenarios and an absolute time saver for many,
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
@SothearithKONGMrMuyKhmer
6 ай бұрын
Thanks a lot Mynda! This has helped me a lot. 🎉
@MyOnlineTrainingHub
6 ай бұрын
I'm so glad!
@AndrewWright26
3 жыл бұрын
Thank you, these are great tips! You explain this so well. 🤔
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, Andrew!
@109zxg
Жыл бұрын
Thank you Mynda! You have done a fantastic job to explain the concepts of power query, and this makes a big difference in my life. Your deep knowledge of excel, tone of voice and speed in the demonstrations are just perfectly blended in the video and it is entertaining to watch your KZitem channel. Two thumbs up!
@MyOnlineTrainingHub
Жыл бұрын
Wow! Thanks so much for your kind words 🙏
@kushkhan3219
4 жыл бұрын
You are great teacher👩🏫 .
@MyOnlineTrainingHub
4 жыл бұрын
Glad you think so!
@calvinc851
4 жыл бұрын
The last example was especially cool to watch! Thank-you!
@MyOnlineTrainingHub
4 жыл бұрын
Great to hear you enjoyed it, Calvin :-)
@amitshah8508
3 жыл бұрын
Very nicely explained, different scenarios.
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so!
@AashimGupta15
9 ай бұрын
Truly a masterful video. Thanks for all that you do.
@MyOnlineTrainingHub
9 ай бұрын
So glad it was helpful 🙏😊
@mazharhussain8871
5 жыл бұрын
you have beautifully explained the most common faulty format cleansing. you are better than Microsoft professional trainers.
@pauloelifaz
4 жыл бұрын
This video saved my life 2 times, in different periods, in different cases. THANK YOU!
@MyOnlineTrainingHub
4 жыл бұрын
Wow, that's awesome to hear, Paulo :-)
@justtisha
2 жыл бұрын
I LOVE these videos!! Thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear! 😊
@sanishtv
6 ай бұрын
Thanks Lynda for this very useful information for my most faced problems. Appreciate ur hardwork. I will soon jump into your course too..Thanks alot😍🙏
@MyOnlineTrainingHub
6 ай бұрын
Glad it was helpful! Look forward to teaching you more Power Query wonders in my course 😊
@dougmphilly
Жыл бұрын
this was a game changer when i learned about it.
@MyOnlineTrainingHub
Жыл бұрын
Great to hear!
@shoppersdream
3 жыл бұрын
Thanks, Mynda! You are so good. I will have to watch it a couple of times to totally understand.
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
@galinastefanova7770
4 жыл бұрын
Didactic, clear and calmly explained. Excellent video!
@MyOnlineTrainingHub
4 жыл бұрын
Thank you kindly, Galina!
@gustavanderson4633
2 жыл бұрын
Thank you Mynda! The second example was exactly what I was looking for. Works perferctly! Cheers!
@MyOnlineTrainingHub
2 жыл бұрын
Glad it was helpful!
@SonuPandey-me4fs
4 жыл бұрын
Great... Cover the difficulties as an example is great.
@MyOnlineTrainingHub
4 жыл бұрын
Glad you found it useful, Sonu :-)
@pardawala_Bhiwandi
3 жыл бұрын
U r the GOOD OF EXCEL
@joshuaiwl1ng
4 жыл бұрын
Super helpful and Advanced! Thanks so much
@MyOnlineTrainingHub
4 жыл бұрын
Great to hear you liked it, Ben!
@shday4
2 жыл бұрын
Wow, I'm so glad I found this video, it's clear, concise, and effective as hell, great job and format... definitely keeping this one!!!!😀
@MyOnlineTrainingHub
2 жыл бұрын
Awesome, thank you!
@wesszep9865
5 жыл бұрын
Thanks Mynda, I've already seen many power query preparation, never check how to start to prepare my data and the video was 2017! It's helpful to see that there's an start, thanks for help, be blessed.
@MyOnlineTrainingHub
5 жыл бұрын
Thanks, Wess! Glad I could help.
@aaronbasch1714
4 жыл бұрын
Great teaching. So clear, practical, and relevant to data issues I run into at work all the time. Thank you!
@MyOnlineTrainingHub
4 жыл бұрын
Glad it was helpful, Aaron!
@accountsvalue
2 жыл бұрын
Very helpful and on point. Thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
My pleasure 😊
@EricaDyson
3 жыл бұрын
Great explanation and so useful. Thanks a lot.
@MyOnlineTrainingHub
3 жыл бұрын
Glad to hear that, Erica!
@quocle124
3 жыл бұрын
This is the most practical and excellent tutorial I really need. Thank you Madam
@MyOnlineTrainingHub
3 жыл бұрын
Wow, so pleased you found it helpful :-)
@kimerared
4 жыл бұрын
This video explain most common format problems. It is great and straight to the point. Thank you!
@MyOnlineTrainingHub
4 жыл бұрын
Great to know it was helpful!
@kmetcalfe
2 жыл бұрын
Of all your very helpful videos, this one will actually save me the most time, and help me the most. It gives solutions to problems I've occasionally had over the years, but have lately been confronted with over and over again. Thank you!
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear!
@piero141980
2 жыл бұрын
Thanks a lot, this is going to save me a lot of time...
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear 😊
@sohilkumarchauhan4761
29 күн бұрын
2nd layout method helped lot.. thanks a lot for the solutions
@MyOnlineTrainingHub
29 күн бұрын
Great to hear!
@khalidmajeed2886
3 жыл бұрын
MARVELOUS---MAM YOU INCREASED MY APPETITE---------------NEED MORE
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Khalid!
@Bharatmsharma
4 жыл бұрын
Superb Video Madam, One of the best vidoe i have ever seen on Unpivot. Thank you viery much. I can related two sheets related to my work.
@MyOnlineTrainingHub
4 жыл бұрын
So pleased you found it useful, Bharat :-)
@khalidmajeed2886
3 жыл бұрын
WHAT A GREAT YOU ARE ALSO PROVIDING EXAMPLE WORKBOOK.
@MyOnlineTrainingHub
3 жыл бұрын
Yes, the link is in the video description.
@xiomaragotch9453
4 жыл бұрын
You saved my day! I have been thinking how to do case #2 and Voila!..you had it here so well explained. THANKS!!!!
@MyOnlineTrainingHub
4 жыл бұрын
Glad I could help, Xiomara!
@elicesroman7500
3 жыл бұрын
Great Video. I find it hard to get my head around Pivoting/Unpivoting data. Thanks for providing the file. I will practice more.
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it 😊
@salimman9346
2 жыл бұрын
You are my saviorrrrrr !!!!!! THANK YOUUUU
@MyOnlineTrainingHub
2 жыл бұрын
Glad I could help, Salim 😊
@janezklun
4 жыл бұрын
Great explanation, thank you for sharing, Best regards
@MyOnlineTrainingHub
4 жыл бұрын
Glad it was helpful, Janez!
@OrkunAkar
9 ай бұрын
I wish I found thıs video before I spent 2 weeks in my budget tables. :) thank you for sharing knowledge
@MyOnlineTrainingHub
9 ай бұрын
Hopefully you can use it next time 😁
@OrkunAkar
9 ай бұрын
@@MyOnlineTrainingHub for sure! :) I am excited to apply in future books thanks again!
@hajasahib8943
4 жыл бұрын
Awesome 👍 Training Sister Thankyou.👌☺️
@MyOnlineTrainingHub
4 жыл бұрын
My pleasure 😊
@rajeshvk4087
4 жыл бұрын
Thanks for putting these together. Love your videos, they are simple and straight forward
@cambike
5 жыл бұрын
Watched multiple videos on how to do this. By far the best video, great pace to the lesson and clear instructions. Thanks for the great work
@MyOnlineTrainingHub
5 жыл бұрын
Thank you! Great to know you found it helpful :-)
@DarrenSaw
2 жыл бұрын
Brilliant video, some of the data we get from third parties is something I'd be ashamed to send out myself! This is the perfect antidote to fix it. Thank you!
@MyOnlineTrainingHub
2 жыл бұрын
Glad you can make use of it 😊
@nattawut_chatwiriyacharoen
6 жыл бұрын
Thanks a lot Mynda. This is a great video, not only techniques but also supporting documents. I love it so much.
@MyOnlineTrainingHub
6 жыл бұрын
Thank you, Nattawut :-)
@ferasstaif6088
2 жыл бұрын
great presenter, thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it!
@AweshBhornya-ExcelforNewbies
4 жыл бұрын
Thanks for this video it helped me resolve a very complicated problem for one of my client. Love your videos keep them coming.
@dyglesias
3 жыл бұрын
Just great. Very powerful tool and info. Thanks
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it!
@dyglesias
3 жыл бұрын
@@MyOnlineTrainingHub saved me hours, thanks
@azwarmzafar
Жыл бұрын
Thank you so much, it was great and super clear.
@MyOnlineTrainingHub
Жыл бұрын
Great to hear!
@leorc564
4 жыл бұрын
Todas las explicaciones claras y sencillas de entender, muchas gracias, aprovechando para refrescar y aprender conocimientos, saludos, bonito acento!
Пікірлер: 623