How to easily automate boring Excel tasks with Power Query!

Подписаться 613 тыс.

Просмотров 1,6 млн

50% 1

Learn how Power Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button!
🔻 DOWNLOAD files for this lesson here: www.myonlinetraininghub.com/i...
🎓 LEARN MORE Power Query here: www.myonlinetraininghub.com/e...
Or view my comprehensive courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
POWER QUERY ADD-IN
Excel 2010 & 2013 users download the free Power Query add-in here: www.microsoft.com/en-au/downl...
⏲ TIMESTAMPS
0:00 What is Power Query
0:27 Where to find Power Query
1:14 Why should you use Power Query
3:44 Power Query example - get files from a folder
6:04 Power Query Editor - cleaning the data
13:37 Close & Load Options
14:27 Building PivotTables from Power Query data
15:37 Updating with new data with one click!

Опубликовано:

18 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1,4 тыс.

@weemanling 3 года назад

OK so, I start a job. Show my boss how incredibly time consuming the data gathering and cleaning is. Then, when my boss has left me alone, I develop a power query, get the task done in seconds, and spend the rest of the time my boss thinks I'm working on the data watching more of your RU-vid videos. Sounds good 👍

@MyOnlineTrainingHub 3 года назад

:-) Glad Power Query will be useful to you, Xigan!

@MyOnlineTrainingHub 3 года назад

Thanks for your kind words, Xigan! I sincerely appreciate it :-)

@Skandawin78 2 года назад

Hmm, I’m your boss..come to my room.

@robbebol10 2 года назад

This will be my plan, starting tomorrow as an intern.

@TrishaSimmons 2 года назад

Work smarter, not harder!

@sihamef2604 3 года назад

The discovery of PQ in your channel has changed my job since several months! Thank you very much. I still meet many errors while building my queries. A tuto handling the common errors will be much appreciated :)

@MyOnlineTrainingHub 3 года назад

Great to hear!

@TruthofDilly 3 года назад

Mynda, said it once and I will say it again, YOURE THE BEST EXCEL TEACHER OUT THERE! Thank you.😀

@MyOnlineTrainingHub 3 года назад

That's so kind of you :-)

@DebbieS-hm1ez 3 месяца назад

Thank you for your easy to follow videos. I am an older person and I love that I can rewind the video and re-watch a section if I need to watch the instructions again. It is also great that you have the practice files available. These videos help me to stay relevant in my job!! Thanks again.

@MyOnlineTrainingHub 3 месяца назад

Awesome to hear!

@MuhammadZubairAsifi 3 года назад

Sister, You killed me when you just refreshed it

@MuhammadZubairAsifi 3 года назад

Although i have been working for 12 years in MS Excel but this is a killer

@MyOnlineTrainingHub 3 года назад

Glad you'll find it useful, Muhammad!

@BodiLY0422 3 года назад

Definitely! When she pressed refresh my jaw dropped.... what have I been wasting my time with all this time????

@MuhammadZubairAsifi 3 года назад

@@MyOnlineTrainingHub I just implemented this Power Query Rocking magic in my working, I just received contractor's weekly report and drop it the folder, the rest is 💥 Boom

@JosQiNgMT 3 года назад

Seriously. She is the best. Clear, Details, steps by steps but not boring.

@MyOnlineTrainingHub 3 года назад

Thanks so much!

@roelfjoubert1128 3 года назад

This video has essentially, single-handedly, improved my report efficiency nine fold. Thank you so, so much!

@MyOnlineTrainingHub 3 года назад

Wow! Awesome to hear, Roelf :-)

@stefanspath1322 3 года назад

Thank you. This is really a great example how Power Query improves our worklife.

@MyOnlineTrainingHub 3 года назад

You're very welcome, Stefan!

@SuperBermondo 3 года назад

Thanks Mynda! You made me believe that I could do more with Excel! Thought I needed to be VBA expert but I am getting there gradually! My next step will be to try your short courses! You are the best!

@MyOnlineTrainingHub 3 года назад

Thanks, Nick! So pleased to hear you're excited to give Power Query a go. I'm sure you'll love it :-)

@maglerdon 3 года назад

Your tutorials are my favorite to watch of anyone I've found on RU-vid! Great pacing and you make sure to explain everything clearly and concisely. Thank you so much!

@MyOnlineTrainingHub 3 года назад

Thanks for your kind words!

@pavol.cernak 3 года назад

For me as a controllership analyst Power Query is a real gift from the sky. About 80% of my worktime was dedicated to getting, cleaning and merging huge sets of data. Now, it's about 20%, and the rest I can spend more effectively. Moreover, I'm able to offer new views on data to my customers. In combination with data models and your cool ideas about dashboards, it's pretty shocking them. Thank you, Mynda.

@MyOnlineTrainingHub 3 года назад

Wow, that's an amazing result, Pavol! Congratulations on your hard work.

@aakashraghunathwadagave7658 3 года назад

Your tutorials are extremely easy to follow, yesterday i created my first dashboard with help of your tutorial on Dashboards and I really felt happy and my work has really got reduced to 90% where i have to make MIS report for every month and it would have took me almost a day to get, cleaning, and adjusting the data. KUDOS MAM : - )

@MyOnlineTrainingHub 3 года назад

Wow! That's awesome to hear, Aakash!

@peterc2248 3 года назад

Oh my word, I've been wasting days and days every month cleaning up data. Thankyou, thankyou, thankyou :-)

@MyOnlineTrainingHub 3 года назад

So pleased to hear you'll be able to make use of Power Query, Richard!

@muhamadirfan9325 3 года назад

I just can't stop my eyes, seeing ur tricky tricks with excel, you did well or i can say it is the best.

@MyOnlineTrainingHub 3 года назад

Thanks so much, Muhammad!

@cscs3818 3 года назад

Very powerful. I tried it out with one of my daily routines and it made a complete chore to a quick refresh. :) Thank you for sharing.

@MyOnlineTrainingHub 3 года назад

Wow! That’s awesome to hear 😊

@kristofferthompson1176 3 года назад

Absolutely phenomenal. A significant part of my Excel knowledge is directly from you, and it's saving me far more time than I could ever have guessed when I started getting serious about it. Thank you so much Ms. Treacy!

@MyOnlineTrainingHub 3 года назад

Great to hear, Kristoffer!

@jangaiahburra3337 2 года назад

Pls tell us how to do the gstr2a reconciliation

@arturoaugustoperezjaramill8590 3 года назад

Dear lady, your way of teaching is simply amazing ... I really congratulate you ... I sincerely hope that Gd continues to bless you with that gift you have for teaching, for the benefit of you and all of us who want to continue learning POWER QUERY. Greetings from Panama, Central America.

@MyOnlineTrainingHub 3 года назад

Thanks for your kind words, Arturo!

@Julipson 3 года назад

I didnt need to learn it for my job, but now I will, because I just watched your video from my sofa in the evening and it was entertaining and perfectly explained. I also like to learn new things

@MyOnlineTrainingHub 3 года назад

What a great way to spend your evening!

@_ArcanoiD_ 2 года назад

very clear speaking and easy to understand for non-native English speakers. big fan of your tutorials.

@MyOnlineTrainingHub 2 года назад

Glad to hear that, Umit!

@vincentandrew4717 3 года назад

Thank you!!! I've always been intimidated by Power Query, but this is fantastic!

@MyOnlineTrainingHub 3 года назад

So pleased to hear that, Vincent! Have fun with Power Query :-)

@rachaelhanna8523 3 года назад

I was just thinking..... I have to find a good intro. to Power Query tutorial for a summer intern !Mynda .. You Rock!!

@MyOnlineTrainingHub 3 года назад

Awesome timing :-) Thank you!

@data_kom Год назад

Wow! Justice was done. Thank you for the time and effort put into the video. I was studying your video on How to Build Power BI Reports from Start to Finish, as I followed the steps I was a bit lost in the power query aspect so I decided to quickly watch this video and I really feel confident to return to the power BI video now. Thanks again 😊

@MyOnlineTrainingHub Год назад

Glad it helped!

@blahblah3349 3 года назад

Idk how to thanks you!!!! This save my life!! Starting my first job as analyst. Thank you!!!

@MyOnlineTrainingHub 3 года назад

So glad I could help :-) Best of luck!

@excel-businessinexcel5181 3 года назад

Всегда вас слушаю. Спасибо вам за полезную работу. Дай Бог вам всего хорошего, будьте здоровы!

@MyOnlineTrainingHub 3 года назад

Thanks so much!

@charlesbyrne71 Год назад

As a programmer I needed this functionality years ago. We get data sources from everywhere, CSV, Json, Mainframes. And yes we would have to spend most of our time building throwaway scripts, VBA macros, DTSX packages, SQL loaders, etc to get the data to load into spreadsheets, databases. I went back to a conversion I did a few years back that took me a 2-3 days of importing data, writing excel formulas, cleaning fields, normalizing data, converting to text for insert into sql server then running scripts to find orphans and duplicates, etc. With the instructions and documentation I had I was able to do almost all of the tasks on a 30 minute lunch break. Yes I had the benefit of having previously known what is needed, but it takes put the complexity and number of steps. Power query does tend to choke on large sets of data, but for smaller counts under 80K it is worthwhile. It's nice to have another tool. Hopefully Microsoft won't abandon the feature in the future.

@MyOnlineTrainingHub Год назад

Glad you like it. Power Query isn’t going away 😊

@SpencerBarfuss Год назад

Just curious about his comment about Power Query not performing well on large sets of data. Does that still hold true in February 2023? Or has Microsoft improved it's performance ability in this area?

@irwankurniawan1737 2 года назад

This is great. I've been using Excel since 1995, however these are all new to me. Thank you!

@MyOnlineTrainingHub 2 года назад

Awesome to hear, Irwan!

@stopthink9000 3 года назад

THANK YOU! I shudder to think how much time I've spent doing these tasks. This is a game changer!

@MyOnlineTrainingHub 3 года назад

Glad it’ll be useful to you, Philip!

@atuljain5272 3 года назад

Ma'am, I learned a lot from your videos. Thanks for explaining in such a good way

@MyOnlineTrainingHub 3 года назад

Glad to hear that, Atul!

@mrCetus 2 года назад

More people should learn this. Awesome training material and great work!

@MyOnlineTrainingHub 2 года назад

Glad you liked it!

@elmun21 2 года назад

Simply, amazing. It's incredible how much power fits in power query. You make it so easy to understand. Thank you.

@MyOnlineTrainingHub 2 года назад

Glad you liked it :-)

@LisaCocunubo Год назад

Wow! This is a game changer. I've learned excel so much from you in about 3 days that ever in my professional experience... Thanks!!!

@MyOnlineTrainingHub Год назад

Wonderful to hear 🙏

@kissxk 3 года назад

Your videos inspired me 2 years ago when my knowledge on power products was pretty much zero. It's rewarding to watch them now and yet i can still pick for handy tipps & elegant solutions I can steal for my queries. Keep Rockin!

@MyOnlineTrainingHub 3 года назад

So pleased to hear that, Calvin!

@reg_inforeg_info3691 5 дней назад

@@MyOnlineTrainingHub Thank you very much for a prompt reply/. I'm occasional excel user and try to stick only to formulas as lots of organizations block VBA. And so many times I've seen solutions that were based on PowerQuery... But my impression was that it is some 3rd party plugin/library so I was skipping it too. Now checked your video and will have another look at it. Thanks again!!!

@ChopRockMusic Год назад

I’m an old school excel nerd. This is amazing! Not needing to remember cumbersome/complex formulas and forgoing VBA… priceless!

@MyOnlineTrainingHub Год назад

Great to hear! Have fun with Power Query.

@mouatazbekkari8866 3 года назад

Thank you so much, You're a life saver !!! Great job

@MyOnlineTrainingHub 3 года назад

You're welcome, Mouataz!

@userkr5479 3 года назад

Absolutely brilliant from Excel! Mynda! Thank you so much for your hard work behind this wonderful video to make it easy for all of us, thank you!

@MyOnlineTrainingHub 3 года назад

You're very welcome!

@quizzmottal 3 года назад

Thank you so much for these videos, they are so helpful to me as im just starting out in a Business Analyst role. This video in particular has cut my work by over half!! I will definitely check out your other videos.

@MyOnlineTrainingHub 3 года назад

Wow! That's awesome to hear, Cieran. All the best with your new role.

@lamfh9707 3 года назад

I followed the steps and completed learning this new lesson. It is straight forward, easy to follow, and with sufficient explanation. What a marvelous video presentation for self-learning. Thank you!

@MyOnlineTrainingHub 3 года назад

Thanks for your kind words!

@jimfitch 3 года назад

“A ‘touch’ of OCD about number formatting.” Haha. Me, too, but more than a touch, I’m afraid. Good pitch on PQ. It has been a game-changer for me.

@MyOnlineTrainingHub 3 года назад

:-) cheers, Jim! Glad I'm not alone.

@dgoloks2896 3 года назад

My job involves developing financial models in excel and i can tell you i am learning new things from you every time!

@MyOnlineTrainingHub 3 года назад

So pleased to hear that!

@Guilopes99 3 года назад

The single best power query video ever. So simple. So valuable. Thanks!! I even feel bad how we don't need any programming...

@MyOnlineTrainingHub 3 года назад

Thanks so much, Guilherme! Don't feel bad :-)

@TheSkiggly 3 года назад

Your tutorials are always so easy to follow and learn.

@MyOnlineTrainingHub 3 года назад

Glad you like them, Mitch!

@clintonanderson9365 2 года назад

Wow, this is an amazing feature and explained so well. I used to spend about 2-3 days a week manually manipulating and purifying data then sorting and putting it into a readable format… now after watching this, it took me a couple of hours to create a Power Query that auto sorts and produces much better data by just putting the new report in the specified location and then refreshing. 😳 just gave me back half a week a month and some great recognition from the boss for the implementation of an innovative solution. 👍😃

@MyOnlineTrainingHub 2 года назад

Awesome to hear, Clinton! Congratulations 👏

@mirnesvelic1417 Год назад

I cant explain how greatful I am for your channel. I start a new position and the videos have been a life saver.

@MyOnlineTrainingHub Год назад

Wonderful to hear. All the best in your new role!

@massimoraballothescreening3947 2 года назад

There a lots of videos on Power Queries, but this flows particularly well and offers lots of time saving tips embedded in the main layer, awesome, thank you!!!!!

@MyOnlineTrainingHub 2 года назад

So pleased you enjoyed it!

@LuisRodriguez-gr4zq 3 года назад

This is great. I really love your tutorials, they make my life much easier. I have a quick question, if I need to share the dashboard like in the example with my team, and they want to access the raw data, would I need to share the originals files too? Or they will need just to double click the data in the pivot table? Thanks a lot for sharing your knowledge 🙂

@MyOnlineTrainingHub 3 года назад

My pleasure, Luis! You can just share the file as is and they can double click the PivotTable to drill down to the records as they are stored in the Pivot Cache which is part of the Excel file.

@LuisRodriguez-gr4zq 3 года назад

@@MyOnlineTrainingHub I already created the report and looks amazing. I have a quick question. In the actual report I am using information in the power query that I will need to use in other excel files. Can I create a power query to use in multiple files? I currently have Excel 2013. Thanks a lot for your support

@wndmier90 3 года назад

I just want to say thank you, this will save my lots of work in the future :)

@MyOnlineTrainingHub 3 года назад

Pleased to hear that, Claudio!

@syedhassan6409 3 года назад

@@MyOnlineTrainingHub What about those new data files that we will add in folder in future which may have less or more columns ? By clicking one refresh button would it work fine regardless of less/more number of columns in a new file ?

@muereelkin 3 года назад

II have been doing monthly reports completely manually for more than a year, this will save me many hours. thank you very much!

@MyOnlineTrainingHub 3 года назад

Wow! That’s great to hear 😊

@irislu7070 3 года назад

Wow! Very relevant to daily work, 17 minutes full of useful tricks!

@MyOnlineTrainingHub 3 года назад

Glad you think so, Iris!

@cordularaecke 3 года назад

Mynda, fantastic tutorial - I'm new to PowerQuery and it is truly amazing. Just a couple of questions please: - In the data - I find another Order Priority (Not Specified - 1672 rows?), should this data not be shown in the pivot table or did I miss something? - Is there a way in PowerQuery to automatically sequence the Order Priority columns e.g. Low, Medium, High, Critical?

@MyOnlineTrainingHub 3 года назад

Hi Cordula, Great to hear you enjoyed my tutorial :-) In my PivotTable there isn't any 'not specified' order priority, so I'm not sure where you're seeing this. You can manually sort the order priority columns by left clicking and dragging the headers in the PivotTable. If you have further questions, please post them and your sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum Mynda

@OldSpirit88 3 года назад

I thought I was above average but this makes me feel like an absolute peasant! Haha. This is amazing, thank you so much!!

@MyOnlineTrainingHub 3 года назад

Glad you learnt something new :-)

@regularhuman95 3 года назад

Lmao I told during an interview that my proficiency in excel was 8 out of 10, after watching pivots, dashboard, power query, I believe i was at level 4/10.

@dsqaredinc3291 3 года назад

Exactly what I felt lol

@kwakukumi4729 3 года назад

You are literally the best source for Excel related information.

@MyOnlineTrainingHub 3 года назад

Wow, thanks!

@BobT-gz2bm 5 месяцев назад

Wow, that was beautiful! What a great job showing the power and usefulness of this tool. I have been using it with Power BI for a few years now and learned some nice tricks today from your training. Great job and a big thumbs up!

@MyOnlineTrainingHub 5 месяцев назад

Great to hear! 🙏😊

@JW-ni7gr 3 года назад

Hi Mynda - does this include any tips to schedule power queries to run at specific times or intervals?

@MyOnlineTrainingHub 3 года назад

Hi JW, no, not this video, sorry.

@Acheiropoietos 3 года назад

Commas and no decimals for large numbers: I’m the same! Terrific presentation.

@MyOnlineTrainingHub 3 года назад

Great to hear :-)

@Mic_Glow 2 года назад

doesn't matter for a presentation.. it matters in programming and if you need to write stuff down manually. Comma is way easier to do than a dot.

@tosmanhype9419 2 года назад

OMG how come I never realize there was such a free powerful tool in Excel ? Thank you so much ! You're a life savior. I'm definitely subscribing to your channel

@MyOnlineTrainingHub 2 года назад

So pleased you're excited to give Power Query a try.

@CarlosMoreno-uo4io 2 года назад

This blows My mind and will change my entire structure. I just don't know how to thank you for this vídeo 🙌🙌🙌🙌🙌. Regards from Chile, SA.

@MyOnlineTrainingHub 2 года назад

Wow, that's awesome to hear, Carlos!

@amidaddingthisright 3 года назад

This is great stuff! Question: If I want to create multiple pivot tables / charts from the same data (to create a dashboard in excel), would I just create a connection (as opposed to going directly from PQ to the pivot table as you did)? Thanks! I really enjoy your videos and teaching style!

@MyOnlineTrainingHub 3 года назад

You need to load to a PivotTable to load the data to the Pivot cache. Then you can copy the first PivotTable and modify as required. Alternatively, if you load it to the data model you just load as connection only and 'add to data model'.

@amidaddingthisright 3 года назад

@@MyOnlineTrainingHub I see! Thanks!

@Luggruff 3 года назад

I don't know if you have it already, but a video on how to deal with source files having changed column order or names, or even new or deleted columns would be cool. As it is now, I keep having to manually rebuild (as I load them as tables, to then run custom columns against)

@MyOnlineTrainingHub 3 года назад

Unfortunately, it's not that straight forward because the subsequent transformations will be referring to these columns, so how you handle those is where it gets messy and really needs to be dealt with on a case by case basis, rather than one solution fits all.

@Luggruff 3 года назад

@@MyOnlineTrainingHub So I have to change the coding each time to adapt it you mean? Hopefully Excel gets smarter in the future to cover for this then.

@iskkeita Год назад

You're the best, my english is not good but I'm able to follow you easely. I have been able automate many area of my work by watching your tutorials. Many thank, God bless you!

@MyOnlineTrainingHub Год назад

Wow, that's wonderful to hear, Issaka!

@diogocosta4099 2 года назад

The detail with M language (after multiplication) helped me a lot! Thanks from Brazil!

@MyOnlineTrainingHub 2 года назад

Great to hear!

@Robay146 3 года назад

I feel like a huge veil has just been lifted. Thank you!

@MyOnlineTrainingHub 3 года назад

So pleased it was helpful!

@vijayarjunwadkar 3 года назад

WOW! What can I say? I got this video just in time, when I was thinking of explaining Power Query with an appropriate example to my colleague and Mynda, you probably sensed that! You made my job simple, just like Power Query! Power to you Mynda, stay blessed! 😊👍

@MyOnlineTrainingHub 3 года назад

I must have read your mind, Vijay ;-) glad it will be useful.

@vijayarjunwadkar 3 года назад

Sure, you did!

@alexa.pacaldo8731 Год назад

Wow! I got new learnings here. Before I used to clean and merge multiples files manually but because of this video Power Query is the tool to use. Thanks and more tutorials.

@MyOnlineTrainingHub Год назад

Fantastic to hear, Alex!

@EssKayTee1 3 года назад

What a revelation! This will save me hours when creating reports. Thank you 😃

@MyOnlineTrainingHub 3 года назад

Wow! Awesome to hear, Stephen :-)

@carlo6195 Год назад

Thank you! This will help me a lot on managing and working on large datasets. Much appreciated.

@MyOnlineTrainingHub Год назад

Great to hear!

@Mahmoud-mf8hn 2 года назад

Can not believe I was missing this for the past decade. Thanks for the video, I feel I ll have a new friend now.

@MyOnlineTrainingHub 2 года назад

Glad you liked it, Mahmoud!

@asheikh6940 3 года назад

This is amazing!! Thank you for the wonderful work you are doing.

@MyOnlineTrainingHub 3 года назад

My pleasure 😊

@HimanshuSingh-lh4qv 3 года назад

Awesome thank you i have been following up with all the tutorials you have shared, really people are paying huge sum for this you are really a great person for those who can't afford at present 🙂

@MyOnlineTrainingHub 3 года назад

Glad to help :-)

@EliotPowell 2 года назад

Mynda, again, your explanation is brilliant. Exactly what I need.

@MyOnlineTrainingHub 2 года назад

Great to hear 😊

@KN-wi4ns 2 года назад

Hello there. I have not attempted to use this yet, but your video is informative, and I already have a major data set that I will be using PQ now… Thanks for sharing your knowledge in a simple way!

@MyOnlineTrainingHub 2 года назад

Glad it was helpful!

@zeiss4652 3 года назад

Absolutely incredible! Thank you,

@MyOnlineTrainingHub 3 года назад

Thanks so much, Brandon! Enjoy Power Query and please tell your friends about it :-)

@wajdimatoussi 3 года назад

I adore the way you present things , A thousand Thanks

@MyOnlineTrainingHub 3 года назад

Thank you! 😃

@kalmarklara 2 года назад

Amazing content! I have only recently found your channel, but I'm hoooked. I learned more in a few days, then in the past ten years working with Excel. Thank you!

@MyOnlineTrainingHub 2 года назад

Great to hear, Klara!

@losshortsdelperro728 2 года назад

I love her, what a teacher she is!

@MyOnlineTrainingHub 2 года назад

Aw, thanks for your kind words 😊

@marjcsb8672 3 месяца назад

Wow thanks. I had such problems having ADD & ADHD with intermediate level & advanced level excel courses from Udemy. I'm no genius but need tools to run my business. This could be a game changer thanks for the ULTRA CLEAR explanations.😀

@MyOnlineTrainingHub 3 месяца назад

So pleased to hear it was helpful 😊🙏

@emilyzh5452 2 года назад

So clear with database and steps to follow!!! THANK YOU!

@MyOnlineTrainingHub 2 года назад

Glad it helped!

@krishnasanghavi7282 3 года назад

Simply amazing ma'am. I have a lot to learn from you. You make spending time on RU-vid worthwhile !

@MyOnlineTrainingHub 3 года назад

It's my pleasure, Krishna!

@StanEby1 2 года назад

Primo. I am quite adept at doing all that with tables and VBA, but I like learning new things especially if it helps me move on to PowerBI. Thanks. Well done.

@MyOnlineTrainingHub 2 года назад

Glad you liked it :-)

@YT-Momonchie 2 года назад

This is amazing! Been struggling with learning vba macros.. my work usually uses the same data format from different range of date's.. imma try this out to make my work less dull and time consuming

@MyOnlineTrainingHub 2 года назад

Great to hear!

@koothodilabhijithaugustine 3 года назад

This video is such a lifesaver. I had to find the average of a particular value in 365×2 .dat files. I was doing then manually, got tired by the tenth file😄 Then I came across this video. Thank-you soo much.

@MyOnlineTrainingHub 3 года назад

Glad it helped!

@shivaaynamah6612 8 месяцев назад

It is the first time i have subscribed a channel even before starting or watching the video and it paid in return a meaningful insight after watching the video. Good work

@MyOnlineTrainingHub 8 месяцев назад

Wow! That's wonderful to hear 🙏😊

@georgebasalic9425 3 года назад

Hi Mynda, thank you for your tutorials, you are amazing, I like the way that you explain. I have learned a lot from you. Thank you so so much for shining our minds and rich us our thirsty interest with your knowledges using Microsoft Office Excel. Thank you so much for your help and God bless you.

@MyOnlineTrainingHub 3 года назад

Thanks for your kind words, George! So pleased you enjoy my tutorials 😊

@BooMBooMitsMayhem 3 года назад

This video saved me weeks of work! Thank you so much for this!

@MyOnlineTrainingHub 3 года назад

Wow, that's wonderful to hear!

@c.s.m.k5737 11 месяцев назад

Power Query is such a beautiful tool. Thank you for this lesson

@MyOnlineTrainingHub 11 месяцев назад

You're very welcome!

@user-zx3xg5jp1o 10 месяцев назад

Your tutorials are always so easy to follow and learn.. Wow! Very relevant to daily work, 17 minutes full of useful tricks!.

@MyOnlineTrainingHub 10 месяцев назад

Glad you like them!

@brentjellicoe7089 3 года назад

Mynda, you are simply amazing (and so is Excel!)

@MyOnlineTrainingHub 3 года назад

Thanks so much, Brent! Glad you liked the video :-) Have fun with Power Query.

@TheYouhou94 2 года назад

Thanks a lot ! I am spending so much time to clean my data and updating my charts ! I will be very usefull ! Thanks again

@MyOnlineTrainingHub 2 года назад

So glad it was helpful!

@rajeshvk4087 3 года назад

Thanks for your crisp video. Its so simple to understand. Your tutorials are amazing.

@MyOnlineTrainingHub 3 года назад

Glad you think so!

@alexparedes9727 2 года назад

wow, in less than 20 minutes you made my work life so much easier, AWESOME!

@MyOnlineTrainingHub 2 года назад

Fantastic to hear, Alex!

@cherianiype 3 года назад

Thank you Mynda and team for this awesome video!

@MyOnlineTrainingHub 3 года назад

Glad you enjoyed it, Cherian!

@mickaell3451 2 года назад

Thanks Mynda! I've just started to get familiarized with power query. This was really usefull. Cheers

@MyOnlineTrainingHub 2 года назад

Glad it was helpful!

@bigdaddy5621 2 года назад

One of the best Excel tutorials i have ever seen! I'm a fan! Thanks a lot!

@MyOnlineTrainingHub 2 года назад

Wow, thanks!

@tityan 3 года назад

It’s just WOW! Amazing work! Thank you!

@MyOnlineTrainingHub 3 года назад

Glad you like it, Katy!

@darrylmorgan 3 года назад

Hi Mynda!Great Tutorial.Power Query Is The Greatest Gift Microsoft Has Given Us!!!Simply Awesome...Thank You :)

@MyOnlineTrainingHub 3 года назад

I completely agree, Darryl! Power Query is the best thing since PivotTables :-)

@bjbrooks 3 года назад

Excellent overview of a powerful tool. Very impressed.

@MyOnlineTrainingHub 3 года назад

Glad you liked it, Brian!

@user-uk9pz9nh1t 3 года назад

Best training about PQ ever

@MyOnlineTrainingHub 3 года назад

So pleased you liked it :-)

@Luciano_mp 3 года назад

Power query is awesome, good work. Thank you Mynda!👍

@MyOnlineTrainingHub 3 года назад

Thanks, Luciano! Glad you agree :-)

@HedroomMax 3 года назад

I just fell in love with Power Query! Just a week ago, I created a VBA macro just to import add pivot tables and graph a voluminous warranty database that used to take a lot of my time each month. Thanks a lot, Mynda! Really helpful! I also want to remark that you own an engaging voice and teaching style, key to captivating your audience.

@MyOnlineTrainingHub 3 года назад

Thanks so much for your kind words! It's so good to hear you're now a Power Query fan :-)