Excel Power Query Course: Power Query Tutorial for Beginners

Рет қаралды 815,375

Күн бұрын

✅Download the demo files and follow along here ➡️www.simonsezit.com/power-quer...
In this Power Query tutorial, we introduce you to Power Query, get you familiar with the Power Query Editor, teach you how to import multiple files and data sources into Power Query, how to combine data, merge queries and so much more.
Power Query in Excel can open up a world of data analyzing possibilities. In this Power Query course, we assume that you are an intermediate to advanced Excel user, but that you haven't used Power Query in Excel before.
This Power Query tutorial was put together using videos from our full, Power Query, Power Pivot & DAX course ➡️ bit.ly/2UTBwPl
✅Become a Simon Sez IT Member to get access to the full course ➡️www.simonsezit.com/signup/
✅Try Simon Sez IT for free, and get your hands on 4, introductory courses here ➡️ www.simonsezit.com/four-free-...
📝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
💻Watch more free popular training tutorials from Simon Sez IT:
✅Check out our FREE 300+ hour training course playlist here 👉
• Simon Sez IT Long Trai...
✅Data Visualization playlist here
👉 • Data Visualization - M...
✅Excel 2021 Tutorials for Beginners playlist
👉 • Excel 2021/365 Trainin...
✅Power BI Tutorials for Beginners. Master Power BI! playlist
👉 • Power BI Tutorials for...
✅Alteryx for Beginners playlist
👉 • Alteryx Tutorials for ...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZfaq Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
🔔Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

Пікірлер: 462

@SimonSezIT 4 жыл бұрын

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: kzfaq.info/get/bejne/eN5phsmorpnVmJc.html

@erictsang789 4 жыл бұрын

Thanks and i am just about to ask

@ahsenshahid 3 жыл бұрын

Thanks a lot sir. One thing is sure, with power query lot of tailored excel formulas are gone now in traditional work books.

@erictsang789 3 жыл бұрын

Thanks and will check it out

@dariushrocks 3 жыл бұрын

Thank you so much, the best tutorial ever.

@macromancarter8076 3 жыл бұрын

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.

@bens.4397 3 жыл бұрын

Put it on 1.5X speed. You are welcome.

@SamPaguaga 3 жыл бұрын

lol.... definitely

@ndturp1 3 жыл бұрын

OMG, thank you

@oompster 3 жыл бұрын

Actually the normal speed is a good speed though . Some steps suits the normal speed

@julialewis8794 3 жыл бұрын

I split the difference at 1.25 and it was perfect

@rohankm 3 жыл бұрын

Thanks a lot.. That helped

@larahporter8123 Жыл бұрын

I like when teachers speak slowly and make pauses. It gives my brain a moment to process. Very good 👍

@Deedington 3 жыл бұрын

I love the clear precise style in which Simon Sez explains the content! Couldn't be any better for professionals. Thank you Simon!

@SimonSezIT 3 жыл бұрын

Happy to help!

@bolaowoade 3 жыл бұрын

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.

@haileandarg8508 Жыл бұрын

The way Simon Sez teaches the material is very clear and concise, and I really appreciate that!

@SimonSezIT Жыл бұрын

So nice of you. You're very welcome! 😊

@viswas1986 3 жыл бұрын

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.

@adhikarikabi09 2 жыл бұрын

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!

@meruyertbekniyazova5032 Жыл бұрын

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!

@harshababu8321 3 жыл бұрын

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.

@SimonSezIT 3 жыл бұрын

Thank you for sharing the tutorial with your friends and colleagues. I'm thrilled you found it to be wonderful! You are very welcome!

@SimonSezIT 2 жыл бұрын

We've made the instructor demo files used in this tutorial available for you for free! Download the demo files and follow along here ►www.simonsezit.com/power-query-in-excel-crash-course-instructor-files/

@javiersequeros9634 2 жыл бұрын

Great work. Im learning a whole deal. Unfortunately Download doesnt seem to work any longer? Could you please share it again? . Thanks in advance

@vinesa2 2 жыл бұрын

I am not able to download the file. Pls helps.

@SimonSezIT 2 жыл бұрын

@@javiersequeros9634 Hi! The link to download the files should be sent to the email address you provided. Please check your spam folder

@felipe4181 3 жыл бұрын

Amazing! Amazing! Amazing explanation! The tools and features used in this video are the best one I have found in KZfaq!!! 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!

@serdip Жыл бұрын

Absolutely BRILLIANT! Thank you for sharing this invaluable resource. It has been quite helpful in taking my proficiency in Excel to the next level.

@roberth.9558 Жыл бұрын

Outstanding presentation. Detailed and comprehensive in scope. Thank you for this training.

@TheRancidMoose 3 жыл бұрын

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.

@SimonSezIT 3 жыл бұрын

Delighted to hear that! Thanks for commenting!

@Dogpotter69 4 жыл бұрын

Brilliant video & well explained just getting to grips with power Query and loved this THANKS :)

@SimonSezIT 4 жыл бұрын

Great to hear!

@skottjordan6431 3 жыл бұрын

yes its really brilliant. You got the point between explaining the function and the sense behind in a really structured way. Greetings from Germany.

@SimonSezIT 3 жыл бұрын

Thank you, I appreciate you leaving a comment and glad you've like the tutorial

@andresff0 4 жыл бұрын

Amazing! Thank you for this well prepared tutorial. I am sharing this with some friends at the office.

@SimonSezIT 4 жыл бұрын

Great to hear that its been useful to you and your colleagues. Thanks for sharing!

@lochuynh9568 2 жыл бұрын

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!

@SimonSezIT 2 жыл бұрын

Thanks for the feedback Lộc Huỳnh. Glad it helped!

@erictsang789 4 жыл бұрын

Simon Your tutorial is very very comprehensive. Appreciated Eric

@SimonSezIT 4 жыл бұрын

I'm thrilled by your amazing feedback. Thank you!

@stenkiyats 3 жыл бұрын

Thank you for this! This is really great and helpful!

@SimonSezIT 3 жыл бұрын

Thank you for watching Kirsten!

@lillifer4783 2 жыл бұрын

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

@lacosterbhx 9 ай бұрын

Most idiotic speech and accent I've heard in my life. Dude, have you been working in a mental hospital?

@jakhongirkhatamov3694 2 жыл бұрын

Amazing Tutorial!!! Love it!

@messiedoho4301 2 жыл бұрын

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

@mariosandino136 2 жыл бұрын

Amazingly well structured and comprehensive!

@SimonSezIT 2 жыл бұрын

Thank you for watching ;-)

@susank6122 Жыл бұрын

Fantastic. So well put together. Each and every step is explained thoroughly. Thank you Mr. Alan.

@SimonSezIT Жыл бұрын

Glad it was helpful! Thanks for watching :-)

@jcmartin1978 2 жыл бұрын

This was a great tutorial! Thank you so much for this- This tool is going to save me an immeasurable amount of time

@SimonSezIT 2 жыл бұрын

Glad it was helpful!

@user-nu6du8zl4h 8 ай бұрын

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!

@SimonSezIT 8 ай бұрын

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 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@Mahmoud-mf8hn 2 жыл бұрын

I cant thank you enough for this training. Just awesome.

@SimonSezIT 2 жыл бұрын

Glad you liked it!

@talya4431 Жыл бұрын

Very useful course, thank you very much!

@PRIYASINGH-cw9hu 3 жыл бұрын

Hello Alan, This is awesome. Undoubtedly you are an excellent instructor.

@SimonSezIT 3 жыл бұрын

Thank you kindly! Look out for more content coming soon !

@miqeladzemevele Жыл бұрын

such a genius teacher !!!!

@yasinwarsame3282 4 жыл бұрын

Very helpful! Thank you!

@SimonSezIT 4 жыл бұрын

Glad it was helpful!

@trueg261191 3 жыл бұрын

Thank you for this tutorial...I feel like I can be a lot more time efficient with excel tasks.

@SimonSezIT 3 жыл бұрын

Glad it was helpful Alex!

@louisd95714 2 жыл бұрын

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!

@SimonSezIT 2 жыл бұрын

Thanks for subscribing Louis, Delighted you’ve enjoyed the Power Query Course!

@samplaying4keeps 5 ай бұрын

This was super helpful! Thank you for taking the time to make this.

@SimonSezIT 5 ай бұрын

You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@9019828585 2 жыл бұрын

Highly clear , simple , cognitive . Well done sir !

@SimonSezIT 2 жыл бұрын

Glad it was helpful!

@miguelalvarado1440 Жыл бұрын

Thank you Sir. Very well explained.

@vijitajain801 3 жыл бұрын

thank you so much..!! wonderful crash course with so much learning. You got a new subscriber today.

@SimonSezIT 3 жыл бұрын

That is great to hear Vijita thank you so much look out for our new videos uploaded weekly !

@iliesboukhatem7803 Жыл бұрын

a great course, I really enjoy watching your videos, thank you so much !

@SimonSezIT Жыл бұрын

Glad you like them! Thanks for watching 😊

@mazafhakar3971 4 жыл бұрын

Got a stack out of this video - My Thanx to You.

@SimonSezIT 4 жыл бұрын

I'm pleased to hear this has helped you.

@iyyappnab 7 ай бұрын

Very much happy with this course. thank you Simon Sez IT

@SimonSezIT 7 ай бұрын

You're welcome. Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@MohamedAhmed-training 2 жыл бұрын

Excellent & Clear explanation 👏🏻

@NikhilVerma-go1dz 2 жыл бұрын

This is amazing. thanks man. you are awesom

@SimonSezIT 2 жыл бұрын

You are very welcome! Thanks for watching :-)

@cofucan 2 жыл бұрын

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.

@SimonSezIT 2 жыл бұрын

You're very welcome, Uche Ofia!

@____kklw7148 2 жыл бұрын

Thanks, great video and learn a lots

@axeemx 2 жыл бұрын

One of the best explanation i have ever had on Power Query. 👍👍

@SimonSezIT 2 жыл бұрын

Glad you think so!

@user-lx6bg1mz9o 3 жыл бұрын

Great video! Highly recommend

@SimonSezIT 3 жыл бұрын

Much appreciated!

@M1ytwo 3 жыл бұрын

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!

@SimonSezIT 3 жыл бұрын

Glad you enjoyed it!

@harshvardhanmittal673 4 ай бұрын

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.

@SimonSezIT 4 ай бұрын

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 👉 kzfaq.info/sun/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2

@JamesBond-qg5gx 3 жыл бұрын

Thanks a lot, your explanation is very clear and very useful. Appreciate your hard-work in preparing this tutorial. 👍

@SimonSezIT 3 жыл бұрын

Happy to help 007! Glad to hear you've enjoyed it

@JamesBond-qg5gx 3 жыл бұрын

Simon Sez IT How to undelete a particular applied step if you have deleted by mistake

@amayardaewii6961 2 жыл бұрын

Alan is such an amazing teacher!!

@SimonSezIT 2 жыл бұрын

Thanks Amayar, keep watching!

@MohsinKhan-tu5lx 11 ай бұрын

Thank you very much!

@qww760 8 ай бұрын

Thank you. I learned quite a few new things in this video.

@SimonSezIT 8 ай бұрын

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 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@Matt-rq6wz Жыл бұрын

Thank you! This was an excellent introduction to PQ

@SimonSezIT Жыл бұрын

Glad it was helpful! Thanks for watching 😊

@ManojAg 3 жыл бұрын

I promise I ll complete the course today

@peremoral 2 жыл бұрын

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!

@SimonSezIT 2 жыл бұрын

You're very welcome!

@SimonSezIT 2 жыл бұрын

You're very welcome, appreciate the kind comments, Pere!

@cakirankale Жыл бұрын

So Greateful.

@agnieszkabartoszewicz7163 5 ай бұрын

Great tutorial, thank you for this this! It has been extremely useful - everything explained clearly and easy to follow.

@SimonSezIT 5 ай бұрын

Wow, thanks for your feedback! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@lizabeta9347 8 ай бұрын

This is so helpful. Thank you very much!

@SimonSezIT 8 ай бұрын

Glad it was helpful! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@BestRestaurantToEat 3 жыл бұрын

Hi, If there are new fields in the new file, it is possible to add into the query

@richardmas4983 3 жыл бұрын

What an awesome course !

@SimonSezIT 3 жыл бұрын

We agree!

@adarshpandey8023 Жыл бұрын

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

@ashuverma2742 2 жыл бұрын

Much appreciated stuff.

@SimonSezIT 2 жыл бұрын

Thanks!

@success4624 Жыл бұрын

Very helpful, thank you so much

@SimonSezIT Жыл бұрын

You're very welcome! 😊

@tonyng6448 2 жыл бұрын

It's really helpful for me to understand how to use Power Query, thanks alot Simon 😁👍

@SimonSezIT 2 жыл бұрын

Happy to help!

@aloobi 2 жыл бұрын

Brilliant! Thanks a lot!

@SimonSezIT 2 жыл бұрын

You're welcome!

@fengfuxu4822 Жыл бұрын

Excellent video, clear, easy to follow.😉👍👍👍

@SimonSezIT Жыл бұрын

Glad it was helpful! 😉

@BenDieselBasicAutomotive Жыл бұрын

Very nice explanation. I fully understand because of the pace that is very detailed and not fast..... Thanks for the knowledge.

@SimonSezIT Жыл бұрын

Thank you, we appreciate that 😀

@GrumpyOldMan9 Жыл бұрын

After watching this for two hours, I had the feeling of being covered with spit. But it sure was worth it!

@alhassanalzorqah1401 Жыл бұрын

Thank you so much for your great and fantastic video, I have learnd a lot. Thanks again.

@SimonSezIT Жыл бұрын

Happy to hear that, AlHassan Alzorqah! :-)

@orelshema911 3 жыл бұрын

Excellent Guide!

@SimonSezIT 3 жыл бұрын

Glad it was helpful!😊

@amenaislam4573 3 жыл бұрын

thank you for this great tutorial.

@SimonSezIT 3 жыл бұрын

Thanks for watching!

@mobious888 3 жыл бұрын

Thank you so much for this i have learnt so much

@SimonSezIT 3 жыл бұрын

Glad it was helpful!

@valentinguillaume4579 Жыл бұрын

I ran the video on x2 because it was too slow, but the content is perfect. Thanks !

@tallswar 2 жыл бұрын

Fabulous boss, this is an excellent course. Thanks

@SimonSezIT 2 жыл бұрын

You are welcome! Thanks for watching ;-)

@siammostafiz 6 ай бұрын

you are awesome. Doubtless Recommended this whose have poor understanding about Power Query.

@SimonSezIT 5 ай бұрын

Thanks for the kind comments 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@johnsonfbrian 2 жыл бұрын

Excellent Instructional Style!

@SimonSezIT 2 жыл бұрын

Glad you enjoyed it, Brian J!

@nathinasilo7594 4 ай бұрын

I am watching this today on the 29 February 2024. Thank you so much for the detail .You do everthing so clearly

@SimonSezIT 4 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@mihirbandodkar9406 3 жыл бұрын

Hello i have a question - like you can link a VBA macro to mainframel similarly can you link power query to mainframe?

@jamesdep8128 2 жыл бұрын

And yet another a great video

@SimonSezIT 2 жыл бұрын

Thank you!

@momforone7946 2 жыл бұрын

Thank you so much.

@SimonSezIT 2 жыл бұрын

You're welcome 😊 Thanks for watching!

@caiofariasgs 3 жыл бұрын

Awesome! Thanks so much! PS: Yes, I recommend to watch it on 2x speed.

@crimsontide4415 3 жыл бұрын

can you tell which version he is using? i can't match with him. a lot of thing missing in my app

@SimonSezIT 3 жыл бұрын

Happy to hear you’ve enjoyed the tutorial Caio!

@sandrisim549 2 жыл бұрын

Thanks for sharing and your explanation is very well communicated.

@SimonSezIT 2 жыл бұрын

Glad you enjoyed it, Sandri :-)

@deshn21 11 ай бұрын

You are a genius. Thanks for the vid. Very helpful.

@salehfaruk6478 3 жыл бұрын

Thank u for ur helpful video.

@SimonSezIT 3 жыл бұрын

My pleasure 😊

@BenDieselBasicAutomotive Жыл бұрын

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

@SimonSezIT Жыл бұрын

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 -> kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU. Wishing you all the best on your journey to master Excel and data ;-)

@godbhaigod 6 ай бұрын

Extremely helpful ❤

@SimonSezIT 6 ай бұрын

Thank you so much! We're glad you found it helpful. 🙂 We have additional free tutorials for various data analysis tools and services here 👉 kzfaq.info/sun/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@harikanagapuri3420 3 жыл бұрын

Thanks a lot team.

@SimonSezIT 3 жыл бұрын

Thanks for watching!

@huzaifahshah3841 2 жыл бұрын

Simply Awesome Sir very easy way to Teach...love from Pakistan

@SimonSezIT 2 жыл бұрын

Thanks for comments and love Huzaifah Shah

@subhasishdey2670 3 жыл бұрын

Helpful Present. in a word awsome

@SimonSezIT 3 жыл бұрын

Thank you! Much appreciated.

@user-dx8fu1xg5t 7 ай бұрын

It is an excellent tutorial. I have learned a lot about Power Query. Thanks

@SimonSezIT 7 ай бұрын

Glad it was helpful!

@kebincui 3 жыл бұрын

Very clear explanation, very good tutorial👍👍👍👍

@SimonSezIT 3 жыл бұрын

Glad you think so!

@toddwadding4459 3 жыл бұрын

thank you!!

@SimonSezIT 3 жыл бұрын

You're welcome Todd!

@Sai-jh5ti 3 жыл бұрын

@42:42 what happens if different excel work books are having different column heads or same column heads arranged in different order? Will power query act dynamically?

@vanvo561 Жыл бұрын

Thank you very much

@SimonSezIT Жыл бұрын

You are very welcome 😊

@Nextwhatguru 3 жыл бұрын

Its really very productive tutorial on Power Query, simple & easy to understand the basic of PQ

@SimonSezIT 3 жыл бұрын

Thanks Naveen

@Nextwhatguru 3 жыл бұрын

@@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.

@syw2476 Жыл бұрын

Danke!

@SimonSezIT Жыл бұрын

Thank you/Danke, greatly appreciated!

@thecentralscrutinizerr 2 жыл бұрын

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.

@chrysanth267 Жыл бұрын

Thank you!! I don't know what this means exactly 😏, but I'll remember it and learn it down the road.