If you liked this tutorial, Alan has also put together a Power BI course for us. Here is the first 1.5 hours of it for free: czcams.com/video/Bx9SfwI3qhc/video.html
I enjoyed your tutorial but kept getting errors working with your practice sheet. Then I would get lost because my info didn't match your. I figured out that your dates are formatted for the UK. I felt pretty good that I was able to troubleshoot it and make it work. Now I'm going to go through the tutorial again and see if it works better. I expect my pivot table will still look a little different but I should at least get the technique. Thank you.
mate,!!!!we have so much sugar coated online sites and teachers and what not , flashy yet completely hollow, you are the best genuine teacher I have come across in internet for quite sometimes now. I mean I would be more than happy to contribute this gentleman`s hard work if there are ways to do so. I want to enrol in your classes if there are any and best fit for someone who is from Australia. Cheers!
Tutorial Markers: 0:00:00 - Welcome and Overview 0:03:09 - What is Power Query 0:08:34 - What is Power Pivot 0:12:17 - Exploring the Power Query Editor 0:18:47 - Common Power Query Transformations 0:27:46 - Editing an Existing Query 0:37:42 - Import Multiple Files from a Folder 0:48:48 - Connect to Data in Another Excel Workbook 0:58:26 - Checking the Location of your Query's Source 1:02:00 - Unpivoting Columns 1:07:33 - Combine Data from Multiple Tables with Merge Queries 1:13:44 - Use Merge Queries to Compare Two Tables 1:18:48 - Stack Data into One Table with Append Queries 1:24:51 - Duplicating and Referencing Queries 1:34:01 - Grouping and Aggregating Data 1:41:54 - Conditional Columns in Power Query
Thank you sir Alan for putting up such well structured and thought out course. 2 hours ago I didn't even know what Power Query was, but now after watching this video, I feel very confident to use it. I can't thank you enough.
So happy to hear you found the video helpful! Keep rocking those Power Query skills! 😊 We have additional free tutorials for various data analysis tools and services here 👉 czcams.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Pretty much really nice overview of what I needed in one place, who's not comfortable with the tempo can always speed it up. 1,5x worked absolute fine for me. Thanks!
If you don't have the addin Querystorm, you're missing one of the easiest ways of using Excel as a Database. You can write SQL scripts directly against Tables in your Workbooks and sheets and even use Excel function in the SQL query and view the results. You can add the results to your worksheet with 1 button click. You don't even need to establish a connection to the tables already in your workbook as that is done automatically when you use the addin. ALL your tables are now database tables and you can use the power of SQL (SQLite impementation) on your Tables.
Hey, thanks a bunch for the awesome comment! We're thrilled that you liked the video and found it easy to follow. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! CZcams Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► czcams.com/users/simonsezittraining ♥️ We appreciate your support!
Hello Alan, This is awesome. I am happy that I installed power query today and happened to see your wonderful video. Without a doubt you are an excellent instructor. I have shared this link to couple of my colleagues. Great preparation with hard work..appreciate it.
I've just finished the other course on Power Query, been sleeping all the time there and it seemed so boring and hard, happy to find out your lessons, I'm totally awakened in all meanings) Thank you for sharing your knowledge!
Question about the _Unpivot Columns_ section. When I select columns to unpivot, Power Query parses this as an _UnpivotOtherColumns()_ method call specifying the complement to the set of columns I selected. So, if I've got `column1`, `column2`, and `column3`, and select `column2` and click "Unpivot Columns", Power Query just writes this as `Table.UnpivotOtherColumns(#"Changed Type", {"column1", "column3"}, "Attribute", "Value")`. Adding another column to my table results in Power Query naturally including it in the column set to be unpivoted. So it seems Power Query is smart enough to manage this. I noticed this in your video and figured I just wasn't getting it. I thought I'd point it out, and maybe I'm still not getting something. Thanks for the video!
Amazing! Amazing! Amazing explanation! The tools and features used in this video are the best one I have found in CZcams!!! PLEASE make a video or videos explaining and using the reining tools with simple example to catch the idea of the function like in this video. Thank you for taking the time to make this video!
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you Allan and Simon Sez IT team. This course is awesome. The way Allan has presented is so good. I won’t subscribe to any of the training channels but this time I did subscribe to Simon Sez. Hearty thanks.
The get data table of your model is like DNA translation, the transform data is like DNA transcription to RNA, and the Load is like loading RNA with the necessary sugar chains as well as protein peptide chains and sodium attractive ability like giving the RNA liaison officer with travel allowance to deliver the message of letter with P.S I love you to an expecting pretty, though your English accent is comprehensible.
Excellent tutorial. Very clearly explained and a lot of great tips given. I’ve recently started using power query and this tutorial has given me ideas on better ways to approach my queries. Will definitely check out more of these tutorials and the paid for courses
Thanks for the kind comments 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
58:30 I moved the source folder part way because I kept finding it difficult to find in downloads. Even after changing source, it refused to look in the new location (error said not in downloads, but the formula bar clearly had desktop listed). Took me awhile to find it was the 'sample file' that also needed to be changed.
Thank you for the extremely helpful video Simon, I just automated my first report and now can't wait to learn/do more of it =)))) Great job with the explanation!
Sir, this is my 3rd time watching your video. Seems I have gone back to college, but this time no tuitiin fee. Am an avid fan. Excel is probably the most difficult discipline to learn in this universe. One would not fully understand it through books. Visualization is the key. But yours is above the rest.... The sequence.... the pace and the grammar. Am learning English grammar at the same time... Thank you and more knowledge power. Salute!......
It's very nice of you to take the time to provide positive comments and feedback 😊. If you need additional training, we have plenty more videos here here -> czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html. Wishing you all the best on your journey to master Excel and data ;-)
@@SimonSezIT Hi Simon, can you help with my problem, i.e. compare values from one column from source table that falls in between two other column value of lookup table and extract the corresponding value from third column of lookup table.
Wow, thanks for your feedback! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
You're welcome. Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! CZcams Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► czcams.com/users/simonsezittraining ♥️ We appreciate your support!
Just when you were starting to get to the good stuff… I need to be able to add functions and manipulate the data & was hoping you would touch up on that 😢
Thank you for your kind words! We're thrilled to hear that you learned something new from the video. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! CZcams Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► czcams.com/users/simonsezittraining ♥️ We appreciate your support!
Best teacher in the world! Wow, thank you for this tutorial. It's like you are teaching me one on one, perfectly explains everything and considers all scenarios. I have no questions at all after following this. Excellent work. Thank you once again sir.
Alan, this is the best and clearest overview of Power Query that I came across! Thank you for all the hard work you put into this. P.S. New Subscriber Here!
Thank you Alan for this wonderful and powerful tutorial. You are such an awesome teacher. I understood perfectly every bit of the tutorial. Also, I hope to find the Power Pivot/Data Model tutored by you
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thanks for this tutorial it is excellent. It is very helpful. Question, when I go to "get data -> from file -> from folder" everything is empty. It's there, just not when I try to retrieve it this way. Any ideas?
Very clear, poweful and understable explanations for a complex topic that I was afraid to learn and now I can use. All thanks to you. Thank you very much!
I really enjoyed and find your videos very helpful in my data work. If I have dataset with different variations of gender pronouns like below: he,him,his He / Him / His HE, HIM, HIS he him his he/ him/his he/him/his he, him, his HE/HIMHIS How can I go about standardizing the above to "He/him/his" using Power Query? Thank you.
Glad it was helpful! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! CZcams Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► czcams.com/users/simonsezittraining ♥️ We appreciate your support!
We don't have a follow up to this video, but we have additional Power Query videos: czcams.com/video/80htpBa6OaM/video.html czcams.com/video/8Ix_VVcihqg/video.html czcams.com/video/vz07hc510h0/video.html
Actually I was very confused to know what power query is? but after watching the whole series I am confident that I have understood what power query is and also learnt basics on the power query!!! Thank you @Simon.
Amazing video, thank you. There are a lot of tutorials on pulling source data from a folder to append new information to an existing query. What i need to understand is how to create a query on a specific source and how to apply it if that source document is replaced (with same name) OR applying the same query to a new source (with similar if not exact headings). I export a CSV regularly that needs to be cleaned in the same way each time. I dont want to ADD this data to the existing query, i want to basically reapply it. I've tried simply pointing the query to a new source, but i get a lot of errors when i do that and haven't been successful. Do you have a video on how this might work? (Also what to do if my export doesn't have 100% identical column names?)
What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?
When I select my column in Power Query, I'm unable to see Column Profiling. Can you tell how I can see this? I have Excel 2016 version. Moreover, when I transform and Load the first table you showed in this course to current worksheet it is not loading, saying that "The selected range is in different workbook. Please select a range in the current workbook". Kindly guide me!
Consolidating data? What if some of those multitude of data's that comes are of the confidential type I'm not referring always to business model but in other applications of such, can those data collected when expecting some confidentiality be cloaked in data codes which appears like ordinary data but with some sequence unnoticed alteration? Y'know the moles. Like James Bond 007 on the works.
If you liked this tutorial, Alan has also put together a Power BI course for us. Here is the first 1.5 hours of it for free: czcams.com/video/Bx9SfwI3qhc/video.html
Thanks and i am just about to ask
Thanks a lot sir.
One thing is sure, with power query lot of tailored excel formulas are gone now in traditional work books.
Thanks and will check it out
Thank you so much, the best tutorial ever.
I enjoyed your tutorial but kept getting errors working with your practice sheet. Then I would get lost because my info didn't match your. I figured out that your dates are formatted for the UK. I felt pretty good that I was able to troubleshoot it and make it work. Now I'm going to go through the tutorial again and see if it works better. I expect my pivot table will still look a little different but I should at least get the technique. Thank you.
Put it on 1.5X speed. You are welcome.
lol.... definitely
OMG, thank you
Actually the normal speed is a good speed though . Some steps suits the normal speed
I split the difference at 1.25 and it was perfect
Thanks a lot.. That helped
I like when teachers speak slowly and make pauses. It gives my brain a moment to process. Very good 👍
I love the clear precise style in which Simon Sez explains the content! Couldn't be any better for professionals. Thank you Simon!
Happy to help!
mate,!!!!we have so much sugar coated online sites and teachers and what not , flashy yet completely hollow, you are the best genuine teacher I have come across in internet for quite sometimes now. I mean I would be more than happy to contribute this gentleman`s hard work if there are ways to do so. I want to enrol in your classes if there are any and best fit for someone who is from Australia. Cheers!
Tutorial Markers:
0:00:00 - Welcome and Overview
0:03:09 - What is Power Query
0:08:34 - What is Power Pivot
0:12:17 - Exploring the Power Query Editor
0:18:47 - Common Power Query Transformations
0:27:46 - Editing an Existing Query
0:37:42 - Import Multiple Files from a Folder
0:48:48 - Connect to Data in Another Excel Workbook
0:58:26 - Checking the Location of your Query's Source
1:02:00 - Unpivoting Columns
1:07:33 - Combine Data from Multiple Tables with Merge Queries
1:13:44 - Use Merge Queries to Compare Two Tables
1:18:48 - Stack Data into One Table with Append Queries
1:24:51 - Duplicating and Referencing Queries
1:34:01 - Grouping and Aggregating Data
1:41:54 - Conditional Columns in Power Query
The way Simon Sez teaches the material is very clear and concise, and I really appreciate that!
So nice of you. You're very welcome! 😊
Thank you sir Alan for putting up such well structured and thought out course. 2 hours ago I didn't even know what Power Query was, but now after watching this video, I feel very confident to use it. I can't thank you enough.
So happy to hear you found the video helpful! Keep rocking those Power Query skills! 😊
We have additional free tutorials for various data analysis tools and services here 👉
czcams.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Pretty much really nice overview of what I needed in one place, who's not comfortable with the tempo can always speed it up. 1,5x worked absolute fine for me. Thanks!
Glad you enjoyed it!
If you don't have the addin Querystorm, you're missing one of the easiest ways of using Excel as a Database. You can write SQL scripts directly against Tables in your Workbooks and sheets and even use Excel function in the SQL query and view the results. You can add the results to your worksheet with 1 button click. You don't even need to establish a connection to the tables already in your workbook as that is done automatically when you use the addin. ALL your tables are now database tables and you can use the power of SQL (SQLite impementation) on your Tables.
Thank you!! I don't know what this means exactly 😏, but I'll remember it and learn it down the road.
This video is really great. This one of the best videos I have seen. Very clearly explained and not spoken too quickly, so it's easy to follow. Top!
Hey, thanks a bunch for the awesome comment! We're thrilled that you liked the video and found it easy to follow. 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
Hi Simon - any chance you can provide the data files for Practise?
if anyone got sample file, do let me know
Hello Alan, This is awesome. I am happy that I installed power query today and happened to see your wonderful video. Without a doubt you are an excellent instructor. I have shared this link to couple of my colleagues. Great preparation with hard work..appreciate it.
Thank you for sharing the tutorial with your friends and colleagues. I'm thrilled you found it to be wonderful! You are very welcome!
I've just finished the other course on Power Query, been sleeping all the time there and it seemed so boring and hard, happy to find out your lessons, I'm totally awakened in all meanings) Thank you for sharing your knowledge!
This was more than I was looking for, but I watched the whole thing and learned a lot about steps that I didn't know I needed to know.
Delighted to hear that! Thanks for commenting!
Really good and clear tutorial. I've struggles with Power Query previously but this tutorial has helped me learn the basics of it. Thank you.
yes its really brilliant. You got the point between explaining the function and the sense behind in a really structured way. Greetings from Germany.
Thank you, I appreciate you leaving a comment and glad you've like the tutorial
One of the best explanation i have ever had on Power Query. 👍👍
Glad you think so!
Absolutely BRILLIANT! Thank you for sharing this invaluable resource. It has been quite helpful in taking my proficiency in Excel to the next level.
Question about the _Unpivot Columns_ section. When I select columns to unpivot, Power Query parses this as an _UnpivotOtherColumns()_ method call specifying the complement to the set of columns I selected. So, if I've got `column1`, `column2`, and `column3`, and select `column2` and click "Unpivot Columns", Power Query just writes this as `Table.UnpivotOtherColumns(#"Changed Type", {"column1", "column3"}, "Attribute", "Value")`. Adding another column to my table results in Power Query naturally including it in the column set to be unpivoted. So it seems Power Query is smart enough to manage this.
I noticed this in your video and figured I just wasn't getting it. I thought I'd point it out, and maybe I'm still not getting something.
Thanks for the video!
Great tutorial. Where are the example files?
Amazing! Amazing! Amazing explanation!
The tools and features used in this video are the best one I have found in CZcams!!!
PLEASE make a video or videos explaining and using the reining tools with simple example to catch the idea of the function like in this video.
Thank you for taking the time to make this video!
Highly clear , simple , cognitive . Well done sir !
Glad it was helpful!
I am watching this today on the 29 February 2024. Thank you so much for the detail .You do everthing so clearly
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Hello Simon. I appreciate you being a nice instructor. But we could have practice our own if you please share the demo excel sheet. Is it possible?
I think the point is to sign up to their paid course - then you'll get the demo files - but this free course is fantastic anyway.
Thank you Allan and Simon Sez IT team. This course is awesome. The way Allan has presented is so good. I won’t subscribe to any of the training channels but this time I did subscribe to Simon Sez. Hearty thanks.
Brilliant video & well explained just getting to grips with power Query and loved this THANKS :)
Great to hear!
Fantastic. So well put together. Each and every step is explained thoroughly. Thank you Mr. Alan.
Glad it was helpful! Thanks for watching :-)
I ran the video on x2 because it was too slow, but the content is perfect. Thanks !
The get data table of your model is like DNA translation, the transform data is like DNA transcription to RNA, and the Load is like loading RNA with the necessary sugar chains as well as protein peptide chains and sodium attractive ability like giving the RNA liaison officer with travel allowance to deliver the message of letter with P.S I love you to an expecting pretty, though your English accent is comprehensible.
Outstanding presentation. Detailed and comprehensive in scope. Thank you for this training.
Excellent tutorial. Very clearly explained and a lot of great tips given. I’ve recently started using power query and this tutorial has given me ideas on better ways to approach my queries. Will definitely check out more of these tutorials and the paid for courses
Most idiotic speech and accent I've heard in my life. Dude, have you been working in a mental hospital?
Simon
Your tutorial is very very comprehensive.
Appreciated
Eric
I'm thrilled by your amazing feedback. Thank you!
you are awesome. Doubtless Recommended this whose have poor understanding about Power Query.
Thanks for the kind comments 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
After watching this for two hours, I had the feeling of being covered with spit. But it sure was worth it!
58:30 I moved the source folder part way because I kept finding it difficult to find in downloads. Even after changing source, it refused to look in the new location (error said not in downloads, but the formula bar clearly had desktop listed). Took me awhile to find it was the 'sample file' that also needed to be changed.
Thank you for the extremely helpful video Simon, I just automated my first report and now can't wait to learn/do more of it =)))) Great job with the explanation!
Thanks for the feedback Lộc Huỳnh. Glad it helped!
Alan is such an amazing teacher!!
Thanks Amayar, keep watching!
Power Query can really save you some valuable time
Absolutely! Power Query is an incredible tool for transforming and cleaning data quickly and efficiently.
Thank you for this tutorial...I feel like I can be a lot more time efficient with excel tasks.
Glad it was helpful Alex!
Sir, this is my 3rd time watching your video. Seems I have gone back to college, but this time no tuitiin fee. Am an avid fan. Excel is probably the most difficult discipline to learn in this universe. One would not fully understand it through books. Visualization is the key. But yours is above the rest.... The sequence.... the pace and the grammar. Am learning English grammar at the same time... Thank you and more knowledge power. Salute!......
It's very nice of you to take the time to provide positive comments and feedback 😊. If you need additional training, we have plenty more videos here here -> czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html.
Wishing you all the best on your journey to master Excel and data ;-)
Very nice explanation. I fully understand because of the pace that is very detailed and not fast..... Thanks for the knowledge.
Thank you, we appreciate that 😀
Its really very productive tutorial on Power Query, simple & easy to understand the basic of PQ
Thanks Naveen
@@SimonSezIT Hi Simon, can you help with my problem, i.e. compare values from one column from source table that falls in between two other column value of lookup table and extract the corresponding value from third column of lookup table.
Great tutorial, thank you for this this! It has been extremely useful - everything explained clearly and easy to follow.
Wow, thanks for your feedback! Glad it was helpful. 🤩
🔥Check out our FREE 300+ hour training course playlist here 👉
czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Great tutorial, and can't wait to try it, once they roll out the Power Query in full to MACs (non-365 users).
That would be cool!
Simply Awesome Sir very easy way to Teach...love from Pakistan
Thanks for comments and love Huzaifah Shah
Thanks a lot, your explanation is very clear and very useful. Appreciate your hard-work in preparing this tutorial. 👍
Happy to help 007! Glad to hear you've enjoyed it
Simon Sez IT How to undelete a particular applied step if you have deleted by mistake
Amazing! Thank you for this well prepared tutorial. I am sharing this with some friends at the office.
Great to hear that its been useful to you and your colleagues. Thanks for sharing!
Very much happy with this course. thank you Simon Sez IT
You're welcome. Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
Please provide the file used in this course for practice.
It is an excellent tutorial. I have learned a lot about Power Query. Thanks
Glad it was helpful!
Just when you were starting to get to the good stuff… I need to be able to add functions and manipulate the data & was hoping you would touch up on that 😢
Can't download the demo files!
I like your dramatic british accent, mate... jokes apart, the content is very informative. Thanks for the upload.
Why thank you! I’m delighted to hear that you have been enjoying the content! Keep watching! 😌
Thank you. I learned quite a few new things in this video.
Thank you for your kind words! We're thrilled to hear that you learned something new from the video. 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
thank you simon , you best of best teacher . demo file cant download after 50% stop it!
Thanks Ali! Please try another web browser or try clearing your browser cache, thanks!
Best teacher in the world! Wow, thank you for this tutorial. It's like you are teaching me one on one, perfectly explains everything and considers all scenarios. I have no questions at all after following this. Excellent work. Thank you once again sir.
You're very welcome, Uche Ofia!
Alan, this is the best and clearest overview of Power Query that I came across! Thank you for all the hard work you put into this. P.S. New Subscriber Here!
Thanks for subscribing Louis, Delighted you’ve enjoyed the Power Query Course!
Thank you Alan for this wonderful and powerful tutorial. You are such an awesome teacher. I understood perfectly every bit of the tutorial. Also, I hope to find the Power Pivot/Data Model tutored by you
This was super helpful! Thank you for taking the time to make this.
You are very welcome! Glad it was helpful. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thanks for this tutorial it is excellent. It is very helpful. Question, when I go to "get data -> from file -> from folder" everything is empty. It's there, just not when I try to retrieve it this way. Any ideas?
Hello Alan, This is awesome. Undoubtedly you are an excellent instructor.
Thank you kindly! Look out for more content coming soon !
Awesome! Thanks so much!
PS: Yes, I recommend to watch it on 2x speed.
can you tell which version he is using? i can't match with him. a lot of thing missing in my app
Happy to hear you’ve enjoyed the tutorial Caio!
Very clear, poweful and understable explanations for a complex topic that I was afraid to learn and now I can use. All thanks to you.
Thank you very much!
You're very welcome!
You're very welcome, appreciate the kind comments, Pere!
Thank you so much for your great and fantastic video, I have learnd a lot. Thanks again.
Happy to hear that, AlHassan Alzorqah! :-)
Great video..question: can the source data folder be changed at a later date? I.E. change C:/ power query to D:/ ACME/Datasource
such a genius teacher !!!!
I really enjoyed and find your videos very helpful in my data work. If I have dataset with different variations of gender pronouns like below:
he,him,his
He / Him / His
HE, HIM, HIS
he him his
he/ him/his
he/him/his
he, him, his
HE/HIMHIS
How can I go about standardizing the above to "He/him/his" using Power Query? Thank you.
It's really helpful for me to understand how to use Power Query, thanks alot Simon 😁👍
Happy to help!
Kindly bring some content on advanced data cleaning techniques using formulas too!!
Very simple and useful tutorial
Glad you liked it
Allan your teaching method is great! thank you very much but where are the downloadable worksheets?
This was a great tutorial! Thank you so much for this- This tool is going to save me an immeasurable amount of time
Glad it was helpful!
a great course, I really enjoy watching your videos, thank you so much !
Glad you like them! Thanks for watching 😊
Thanks for sharing and your explanation is very well communicated.
Glad you enjoyed it, Sandri :-)
Thanks a lot team.
Thanks for watching!
Excellent Instructional Style!
Glad you enjoyed it, Brian J!
Nice video and got good insights from this. ☺
Glad it was helpful! 🤩 We have additional free PowerPoint tips and tricks here 👉
czcams.com/play/PLzj7TwUeMQ3jpj7USSM9CiqKDYMzhfPmS.html
Got a stack out of this video - My Thanx to You.
I'm pleased to hear this has helped you.
Alan Murray is a great Excel person !
Glad you think so!
The narrator's voice is so great!
Thank you Katherine! 😊
This is so helpful. Thank you very much!
Glad it was helpful! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
czcams.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
Excellent video, clear, easy to follow.😉👍👍👍
Glad it was helpful! 😉
Click gear icon bottom right > Playback speed > 1.75x > thank me later. Other than that, excellent video.
Love this video. Is there any tutorial for intermediate and advanced users of power query?
We don't have a follow up to this video, but we have additional Power Query videos:
czcams.com/video/80htpBa6OaM/video.html
czcams.com/video/8Ix_VVcihqg/video.html
czcams.com/video/vz07hc510h0/video.html
Actually I was very confused to know what power query is? but after watching the whole series I am confident that I have understood what power query is and also learnt basics on the power query!!! Thank you @Simon.
Why would we want to create "group by" in Power Query if we can do the same using the pivot table? Thanks!
This is amazing. thanks man. you are awesom
You are very welcome! Thanks for watching :-)
Amazing video, thank you. There are a lot of tutorials on pulling source data from a folder to append new information to an existing query. What i need to understand is how to create a query on a specific source and how to apply it if that source document is replaced (with same name) OR applying the same query to a new source (with similar if not exact headings). I export a CSV regularly that needs to be cleaned in the same way each time. I dont want to ADD this data to the existing query, i want to basically reapply it. I've tried simply pointing the query to a new source, but i get a lot of errors when i do that and haven't been successful. Do you have a video on how this might work? (Also what to do if my export doesn't have 100% identical column names?)
What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?
where can I find data used in this video
And yet another a great video
Thank you!
When I select my column in Power Query, I'm unable to see Column Profiling. Can you tell how I can see this? I have Excel 2016 version. Moreover, when I transform and Load the first table you showed in this course to current worksheet it is not loading, saying that "The selected range is in different workbook. Please select a range in the current workbook". Kindly guide me!
Fabulous boss, this is an excellent course. Thanks
You are welcome! Thanks for watching ;-)
Many thanks, this is insightful
You are very welcome! Thanks for watching 😃
I cant thank you enough for this training. Just awesome.
Glad you liked it!
Thank you Sir. Very well explained.
My power query tab looks nothing like in your video..
Consolidating data? What if some of those multitude of data's that comes are of the confidential type I'm not referring always to business model but in other applications of such, can those data collected when expecting some confidentiality be cloaked in data codes which appears like ordinary data but with some sequence unnoticed alteration? Y'know the moles. Like James Bond 007 on the works.
Very useful course, thank you very much!