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:
🎓 LEARN MORE Power Query here:
Or view my comprehensive courses:
🔔 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:
🎁 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:
POWER QUERY ADD-IN
Excel 2010 & 2013 users download the free Power Query add-in here:
⏲ TIMESTAMPS
0:00 Introduction
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!…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
HI Mynda! Question on the Transform Sample File, why all the changes were made there rather than in the final query file ("Data" in this example)? Is that always the case? I felt like I missed a step where all the changes/transformations done to the Sample File were applied to the Final Query file. Hope you can clarify. Thanks!
Thanks so much. I actually have a question. I changed the data type inside the query, when the data was loaded, it still kept the same format. e.g. I chose decimal for the sales result 1256.89 in power query, it did show me 1,256.89 in query transforming data. However, when I loaded the data, it showed me 1256.89 again. I have to use formatting to change it in excel. Is there a way to fix the issue I described, or power query is like that. Please advise me! Your help is highly appreciated! Thanks.
Holy hell! This is amazing wowww
Excellent video. Thank you for posting. Two questions – what if the files in a folder have columns with values based on a formula? Will it load up formula or only as (paste special) values? Also, what happens if files in a folder have multiple sheets? Thanks again.
That was so well explained. Great pace. Thank you+++
This terrific. Thank you!
wow so good
DataFormat.Error: We couldn't convert to Number.
Thank you so much for this.
Hi Mynda. Thanks a lot for this amazing video!
My question: the file I receive is incremental, that is, the same of week before plus X rows added.
Have I got to use the same solution you adopted here? I mean, putting the new one in the same folder and refresh?
excellent! thank you
Why did you delete the source column from the data query and not from the sample file?
Thank you for this, really shows how powerful of a tool Power Query is for cleaning up data!
Hello – Thanks for the great video on Power Query. Can you direct me to part where you can add your own "instructions" as applied steps for Excel to process on Power Query. I recall seeing it on one of your videos but I can't seem to find it on the toolbar.
Fantastic intro to Power Query. Thank you!
have a question that I have been searching the web for for awhile. I’m hoping you can help.
I was hoping to remove a list of about 170 customers from my query. I have their emails and that’s how I need to eliminate them. I know I can filter and copy and paste each and every email in to text does not contain but is there a way to copy and paste the whole list into the advanced editor ,not having to manually type all the and not text contains, etc around each and every email address?
Thanks in advance!
I'm having issues with excel not recording my power query action. I'm only changing the header of one column Int64.Type to type text. How do I add this to my vba?
c# project is good
Pls let me know in which office version i would get data from pdf option.
Great and informative video. I wish I had this knowledge when I traded in two vehicles
I don’t understand. Why not spend this time cleaning up the original data tables instead of leaving the messy and working with a copy?
Hi mam, can u give solution for my doubt. It collection no. Of days for each invoice. Invoice 1 rs. 10000 DT. 01.01.23, invoice 2 rs. 5000 dt.20.01.23 invoice 3. Rs. 3000 dt. 01.02.23 invoice no. 4 rs. 8000 dt.09.02.23 and collection 1 rs. 4000 dt. 10.01.23, collection 2 rs. 10000 dt. 29.01.23, collection 3 rs. 4000 st. 06.02.23 and collection 4 rs. 10000 st. 18.02.23. Can u pl invoice wise no. Of days from collection date. In excel formula.. Pl….