How to easily automate boring Excel tasks with Power Query!

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!

🔔 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 👍

POWER QUERY ADD-IN

⏲ 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!

[weemanling]

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 YouTube videos. Sounds good 👍

[JosQiNgMT]

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

[TruthofDilly]

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

[DebbieS-hmez]

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.

[sihamef]

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 :)

[MuhammadZubairAsifi]

Sister, You killed me when you just refreshed it

[roelfjoubert]

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

[stefanspath]

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

[maglerdon]

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

[pavol.cernak]

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.

[peterc]

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

[SuperBermondo]

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!

[kristofferthompson]

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!

[muhamadirfan]

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

[aakashraghunathwadagave]

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 : - )

[_ArcanoiD_]

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

[arturoaugustoperezjaramill]

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.

[kissxk]

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!

[mirnesvelic]

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

[Robay]

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