No video :(

MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop

Подписаться 1 млн

Просмотров 206 тыс.

50% 1

Download Excel START File: people.highline.edu/mgirvin/A...
Download Access START File: people.highline.edu/mgirvin/A...
Download zipped folder with Text Files: people.highline.edu/mgirvin/A...
Download Excel FINISHED File: people.highline.edu/mgirvin/A...
Download Power BI FINISHED File: people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: people.highline.edu/mgirvin/A...
In this Video learn all about Power Query. A complete Introduction to all aspects of Power Query.
Topics:
1. (00:12) Introduction
2. (02:26) Example 1: Clean and Transform Data in Excel. Look at Excel Power Query User Interface & M Code. Look at Locations to Load Data. Edit, Delete and Add Steps to Power Query Solution. Add new data and Refresh Report and Power Query Transformation.
3. (27:20) Example 2: Extract & Import, Clean & Transform and Load Data from Relational Access Database into Excel Power Pivot Data Model and create Star Schema.
4. (40:37) Example 3: Extract & Import, Clean & Transform and Load Data From Multiple Text Files into Power BI Desktop Data Model. We will Combine all Text Files into Single Table.
5. (52:54) Example 4: Replace Complex Excel Array Formulas with Simple Power Query Solution. See how to Extract a Sorted Unique List.
6. (55:50) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Assigned Homework:
Download Word Document and read: people.highline.edu/mgirvin/A...
Then download the rest of the files and complete the homework:
people.highline.edu/mgirvin/A...
Examples of Finished Homework:
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
The Power Query logo used in this video is copyright of and used with the express permission of powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

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

1 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 641

@rodrigocustodio1955 4 года назад

I will never get tired of saying thank you for Mike for his outstanding contribution to the world, Mike should win a prize from Microsoft as the person who contributed the most for the spread of excel knowledge at a global level. I have been reading Mike's pdf notes and following his videos, Mike free classes here in youtube are thousands of times better than paid classes out there! Mike thank you so much!

@excelisfun 4 года назад

You are welcome so much, Rodrigo : ) : )

@1877Pegasus 4 года назад

I can't agree more!! It's too good to be true

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

This is so so true. His classes beat most of the paid classes hands down!

@DataPrasadS Год назад

Well.. God's grace is always free..Like the Sunshine 🙂

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

How is this free?! On top of the clearly explained and comprehensive videos, there are follow along files, both in their "start" and "finished" form, together with notes. And homework exercises as well! And even examples of completed homework so we can check we've done it properly! This is really above and beyond. Thank you Mike, thank you from the bottom of my heart.

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

That has been my goal for 13 years at RU-vid: Free Excel and Power BI education for the world : ) : ) Glad you like it, Holly!!!

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

Honestly i'm speechless by the quality of the video lecture you put on this platform

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

You are welcome! Been doing it for 13 years at RU-vid : ) Lots more for you to have fun with too, Anthony!!!

@excelisfun 6 лет назад

Homework Problems for you to practice are in the links below the videos. Also, 25 pages of pdf notes all about Power Query : )

@liztrama 5 лет назад

Thanks, Mike you are awesome!!!!

@excelisfun 5 лет назад

Glad you like the video and I hope you had fun with the homework! Thanks for the support with your comment, Thumbs Up and Sub : )

@talebbagazi1435 5 лет назад

can i download the power query and power bi or i need to buy it ?

@avivkoren527 5 лет назад

ur page is awsome, thank you

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

It’s amazing how simple Power Query/ Power BI and dynamic array formulas make complex ctrl + shift + enter array formulas

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

Sooooooooo TRUE : )

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

thank you, thanks to you in 2015 i was able to get a new job and now I have salay six times higher than few years ago. You can't even imagine how many lives you changed thanks to your tutorials and how much value you generate doing your job! this is simply amazing!

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

I am so glad to help, Michal!!!!

@XLJimmyHat 5 лет назад

The time and dedication you give to the excel community is bonkers. Thank you for this free series!

@excelisfun 5 лет назад

You are welcome for the free resources, XL JimmyHat! For 11 years and over 3000 videos, that has been my goal: fun, efficient Excel Methods, free education. Thanks for helping with your support : )

@a.achirou6547 Год назад

Your passion to teach effortless is amazing. Keep going Sir. You are doing a wonderful job. Thank you!

@excelisfun Год назад

You are welcome!!!

@simoiyahector-morales9521 6 лет назад

Always leave my computer feeling like Einstein after I watch your videos Sir Mike, your teachings are invaluable and free which btw is the bonus of it all. Thanks a million.

@excelisfun 6 лет назад

Thank you for your support, Simoiya!!! I have intentionally created all the materials (Videos, Excel Files, Other Files, pdf Notes, Homework Files, and more) all for free for over 10 years! The sad news is, that I am continually amazed that more people do not take advantage of the free Education Resource. AND... I have had many people tell me that I should not give everything away for free because humans do not appreciate free education. But I keep doing it because I believe that it is my duty as a human to make the world a better place. I hope that after 10 years, more people will find this free education and find it useful : )

@shoebhakeem 5 лет назад

@@excelisfun I consider you my guru (teacher) sir. I work as a data analyst and mentor people. People consider me the go-to guy for anything in excel and I attribute all my success to you. I am indebted to you for all the good work that you do. Whoever comes to me with any excel related question I refer him to your classes. May God bless you for the good work. Lastly, good work is not for people Sir, it is for your after life, if you believe in it!!

@excelisfun 5 лет назад

@@shoebhakeem , yes, said a different way: Life is like a Boomerang, Whatever you throw out will come back, in the long run!!!! I am glad that the materials I post help you to become the go-to-guru, shoebhakeem!!! I hope you will help me by always clicking Thumb Up and commenting (even if small) when you watch.

@shoebhakeem 5 лет назад

ExcelIsFun sure thing Sir!

@TouchdownHouse 4 года назад

Great video. I can't believe that after doing the video, excel sheets, PDF notes - you then give homework! This is amazing.

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

I’m amazed how articulated Mike is delivering these gems of thought! It will take a month or more for us to learn from a book or a typical classroom setting, what we get here in less than 60 minutes and for free! Mike, you have found your mission in life! Million thanks for sharing!

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

I am glad that you like the gems of thought, modernaone!!!! I have had this mission here at RU-vid for the past 14 years ; )

@karljolivet5991 6 лет назад

This is a start of an epic series. I never realize to reduce my steps in power query and how easy it is. The benefits are goods. Can’t wait for #4.

@excelisfun 6 лет назад

Yes, a little messing around can be a big help : ) Thanks for your support, Karl : )

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

Mike is the man! I learned so much from this video. I am amazed at how he can tie new and more information to every step and it is never becomes confusing regardless of how complex it gets. Mike you are a really gifted teacher!

@TheAnjana777 4 года назад

The content of your is an absolute treasure ! you go out of the way to give examples, make the lesson more comprehensive and provide materials to practice furthermore. Thanks you so much for all the work you do Mike ! Much appreciated.

@excelisfun 4 года назад

You are welcome so much! Providing free education to the world is what I have been doing for 11 years here at RU-vid! But I do depend on viewers like you to give support on each video that you learn from with your comment, thumbs up, and of course your Sub : ) Thanks for stopping by in the comments, Anjana!

@elhamiliat8389 4 года назад

It is hard to believe there is such a high quality course on youtube for free, how generous you are!!!. Thank you.

@excelisfun 4 года назад

Yes, indeed... for 12 years here at RU-vid I have been trying to provide Free Excel Education to the world! Glad you like it, Elham!!!

@sasavienne 5 лет назад

Thanks for your efforts Mike. I am watching every video from you so carefully in order to imrpove my Excel skills.

@zenia462 5 лет назад

Oh my goodness!!!!!! I can't even find the proper words to describe my feelings, my gratitude and appreciation to the totally free mind-blowing education that you provide!! I just discovered your channel and I can't get enough of it! Thank you so very much for every video and hard work to make our lives easier ! 🙏🙏🙏

@excelisfun 5 лет назад

Glad the resource I post help, Zenia! No need to find words, you can show true gratitude by clicking thumbs up on each vide that you watch, and leave a comment, and of course your Sub : )

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

Mike, I cannot say thank you enough to justify my urge to learn yet save some cash! You are truly gift to an Excel community! An Analyst Superstar! I owe you my humble thank you each and every time you make me a better professional.

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

I value your humble thank you, and I am happy to help : ) I charge no cash, just thumbs ups ; ) Enjoy the class, Martin!

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

OMG, this is the best Excel training I've ever watched. Thank you so much!

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

You are welcome so much, V Dubs!!!!

@blessingclaudio4777 4 года назад

These videos made me pass my 70-778 exam everything is clear and when faced with a question remember the remarks he makes! Boom you get the answer!

@excelisfun 4 года назад

I LOVE to hear that!!!! Congrats on passing the 70-778 exam!!! Thanks for helping me too with your comments and thumbs ups on videos that you learn from, Blessing Claudio!!!

@rodrigocustodio1955 5 лет назад

Mike all your videos, same energy, same great delivery, I literally owe you for all your amazing Excel videos! Thank you!!!!!

@excelisfun 5 лет назад

You do not owe me anything because you pay me each time you watch with a comment and a thumbs up. Most viewers do NOT do that. Thanks you for your continued support : )

@5pctLowBattery 4 года назад

I’m so mad at myself for not watching these videos sooner. Ive saved this playlist. I’m helping out at work loading the hourly time from time_clock_plus into a spreadsheet, which my coworker did manually, but he’s injured and will be out for 2 months. Hoping to save time, so I can get back to my own work.

@TheMagmarunning 4 года назад

RU-vid must add an option to like a video multiple times. Thank you Mike!❤

@excelisfun 4 года назад

I wish they would : ) Thank you for your support, TheMagmarunning : )

@XLJimmyHat 6 лет назад

This channel is a global treasure! --such quality content for free. I have a slow week at work and this series is exactly what I was looking for to learn power query.

@excelisfun 6 лет назад

Glad it helps, XLJimmyHat! That is why I post! And thanks for your support with your comments, Thumbs Ups and Sub : )

@TedSedler 4 года назад

That is exactly where I am today and the same thoughts. Gold! Thanks Mike!

@LeilaGharani 6 лет назад

Wow! Amazing series & video Mike. Thank you!

@excelisfun 6 лет назад

You are welcome, Teammate Leila!!!!

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

Ma'am you also learn from here.

@1877Pegasus 4 года назад

I am running off of adjectives of appreciation of your amazing job. Clear, concise, well structured, with downloadable files and notes... It is just hard to believed the quality of your youtube courses. THANK YOU SO MUCH!!

@excelisfun 4 года назад

You are welcome so much, 1877pegasus!!!!! P.S. is there a cool story behind your username "1877pegasus"?

@pravinshingadia7337 4 года назад

Going over all your videos again after first learning Power BI from you to revise things I haven't used for a while and got rusty! You are easily the best teacher I have ever had.

@excelisfun 4 года назад

Glad I can hep, Pravin! Thank you for your support on each video : )

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

A natural born communicator... you are amazing!

@rodrigocustodio1955 5 лет назад

Hi Mike, you are exceptionally good, the minimum we can do is buy your books and shirts, your knowledge and energy define your excellent teaching style.

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

Thank you so much! You not only showed us the technical skills but also ways of database thinking models. Much appreciated!

@sherryizzie5309 5 лет назад

Thanks for the amazing video. I have been following your excel online training for years and each video is a epic!

@YogeshSharma-ui7xx 2 года назад

U r simply amazing in donating ur skills free of charge for every real learners. Thanks God bless u

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

You are welcome for the free education! For 13 years at RU-vid - that is what I have been doing. It is fun! I hope you are having fun too : )

@RobMichaels1 6 лет назад

Thanks Mike. I finally understand the difference between "Only Create Connection" which is PowerQuery, and "Add this data to the Data Model" which allows you to create relationships etc. Great video as always!

@excelisfun 6 лет назад

Yea!!! Glad it was helpful for you, Rob! Only Create Connection can be used in a few useful ways : )

@excelisfun 5 лет назад

The Power Query logo used in this video is copyright of and used with the express permission of powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

@AweshBhornya-ExcelforNewbies 4 года назад

Whoa that was a marathon session. Mike Girvin made sure there was a not a single moment which bored me. I am sure many will agree. Thanks for replying to my comments Mike. You are a pro at this. Awesome session, very very useful. I would like to point out that the new array functions like sort, filter, unique, etc. are great ways to extract unique records I am glad i didn't have to work with those long and tedious formulas for extracting unique items. Once again a big thank you. I will keep commenting and sharing your stuff. You are just too good. Keep going. You are an inspiration for me to constantly learn, be updated and teach my students all the new stuff.

@vero1552 6 лет назад

I got a new hobby: watching ur videos! Thanks a lot!

@excelisfun 6 лет назад

Glad the about the new hobby : ) You are welcome a lot, Veronica!!! AND, thank you for the support with your Thumbs Up on each video that you watch, comment when you are inspired, a Sub, and p[lease tell all your friends about the fun here at excelisfun : )

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

Brilliant, Mike. You're a great tutor. You explain the 'obvious' stuff that may not be obvious to everyone.

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

Thank you for the kind words, Ian! I am always glad to help : )

@ockipoki 4 года назад

This is a great intro video Mike! Essential viewing for those new to Power Query.

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

your channel has to get millions of subscriptions, that is not fair ,unfortunately discovered it by accident . you are the most brilliant instructor in Excel i ever seen in my life.

@jetg2111 4 года назад

Thank you very very much indeed! I've just created a workbook that will save a colleague three to four hours of paper printing, approval collection and searching through fifty companies for open invoices... Every week... All she needs to do now is click refresh twice and send the file for approval and comments.... her manager now sees the open invoices in one place, along with the bank balances available, and can click to approve and see immediately the affect of the run on cash, order cash movements and move on with the day. Wow I love it! :)

@excelisfun 4 года назад

Yes!!! I love to hear that : )

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

U r the beeeeest. Explaining with very simple language. easy to understand specially for someone like me where English is a second language. I love watching ur videos without skipping a second. Taking in consideration ur professional habits. Love love love ur unique way of teaching. Big support from my side. Will try to buy as much material from u.

@coccinelleladybird6364 5 лет назад

Bless you for being so generous with your knowledge. I have watched your great videos for years and loved them.

@excelisfun 5 лет назад

I am glad that I have been able to help for years!!!! Thank you for helping support this free education with your comment, thumbs up and of course your Sub, coccinelle ladybird : )

@barttitulaerexcelbart9400 6 лет назад

Great introduction! The PDF you provided is absolutely also of great value. Anyone reading this: download the PDF Notes about Power Query. One tip: please pay attention to the regional settings (date, comma/period), since we live somewhere else...:) Looking forward to the next movie....

@excelisfun 6 лет назад

Thanks for the pdf shout out, Bart!!!! Yes, the pdf takes as much time to make as the video : )

@excelisfun 6 лет назад

The homework problems are now listed in the links below the video. Can you edit this pinned comment to say that the homework problems are there too (since I do not want to unpin your comment). Thanks Bart : )

@tomferrara 5 лет назад

WOW. I learned so much for this one video. Played it on my iMac while executing the same steps on my PC. Like real time learning. Thanks Mike. Excited about the next lesson.

@excelisfun 5 лет назад

Glad it was WOW for you, Tom!!! Thanks for helping to support with your comments and Thumbs Ups on each video, and Sub : )

@krishnakd1980 5 лет назад

Tx for being there over the years...

@AHMEDALDAFAAE1 5 лет назад

Big LIKES and THANKS to that guy... The way he is teaching is awesome... and I like the way he is talking with elongated word at the end of his sentences

@johnborg5419 6 лет назад

Amazing Mike!!! This is why I Love this channel and have been following for years. You get to learn like Power Query from earlier videos and then you are taken back from the start which serves as a revision. Besides you get to learn new things which I might have missed. ALT+ A+P+T. Thanks Mike :) :)

@excelisfun 6 лет назад

You are welcome, John! Thanks for your consistent support : )

@francismacisaac6972 5 лет назад

Quality of Education is exceptional, Thank you

@excelisfun 5 лет назад

You are welcome, Francis! Thank you for the support with your comment and Thumbs Up : )

@abdulhaseeb8027 4 года назад

After watching this video I am in love with PQ and my respect for you and your amazing work has increased many fold. You are a true inspiration for everyone.

@excelisfun 4 года назад

Glad to help you, Abdul, and glad that you love PQ now : )

@farid1705 4 года назад

Again , another incredible introduction video. You make the use of these tools so seamless. I have shared these video with three colleagues who also use analysis tools . Thank you like always

@excelisfun 4 года назад

Thanks for the share! Glad you and your colleagues can benefit : )

@tinle4109 5 лет назад

All and all, The training from ExcelIsFun is a great resource to learn Excel, PowerBI and PowerQuery and last but not least Thanks ExcelIsFun. Own you a million Thanks

@Officeinstructor 5 лет назад

The BEST tutorials of All Time = Mike Girvin Thank You from your loyal student for over 11 years (Nabil Mourad)

@excelisfun 5 лет назад

Thank you. I am glad that I have helped for 11 years. You make good videos too.

@hassanhafez6675 5 лет назад

Thank you Mike! As usual very great videos. You are smart like no other.

@1877Pegasus 4 года назад

I am so amazed with your videos and all the additional materials that I do not know what to say but THANK YOU SO MUCH!!!

@excelisfun 4 года назад

I am glad that you are amazed! If I help you, and you learn from all this cool stuff, you can help me with comments and thumbs ups on each video that you watch, and a sub too : )

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

My friend who is an excel guru and senior BI developer highly recommends your channel to me. he said without your video, he won't be able to reach today's achievement.

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

Awesome!!! I have been here at RU-vid for 13 years trying to provide free Education!!! You are going to do great, Yan Lau!

@coccinelleladybird6364 4 года назад

Amazing Excel trainings. Bless you, Mike!

@excelisfun 4 года назад

Glad it is amazing for you, cocconelle ladybird!!!! Thanks for your support with your comment, thumbs up and Sub : )

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

Best Power Query introduction in Excel. Bar none. Thanks very much Professor Mike!

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

You are welcome, Arif!!!

@user-nt9dl7lw6o 4 года назад

Much appreciated Mr Girvin. All my Excel knowledge is owed to you

@excelisfun 4 года назад

Glad the materials I posy help you! Thanks for helping me with comments and thumbs ups on each video that you learn from and of course your Sub : )

@abhishekstatus_7 5 лет назад

This is to much amazing series of #PowerQuery and #PowerBI, Thanks a lot for sharing this amazing information.....

@toyboxcheetah 5 лет назад

Mike is the best teacher ever!

@excelisfun 5 лет назад

Thanks for the kind words, toyboxcheetah!!!! Thanks for your support with your comment, thumbs up and your sub : )

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

Man, this is awesome. Thank you Mike! The two Data Analysis playlist are so good and very helpful.

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

Glad they help, Bolaji!!!

@victorgarzao 4 года назад

Thank you Mike, the way You are teaching us is always AMAZING.!!!!!!!! Thank you

@excelisfun 4 года назад

You are welcome : )

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

HOT DAMN!!! The first 20 seconds got me super pumped!! 🥰😀 Lesss go!!!

@birasafabrice 5 лет назад

what a wonderful teaching, I have never seen this tool before. thanks a million times for your hard work to have similar projects realized. MAY GOD BLESS YOU!

@excelisfun 5 лет назад

You aer welcome, BIRASA!!!! Thanks for your support : )

@birasafabrice 5 лет назад

@@excelisfun you're welcome! I will keep sharing such videos to other colleagues who are in need of them. thanks!

@ljubicar1987 4 года назад

It is pleasure watching your classes, I mean it!👏

@excelisfun 4 года назад

Thank you for the meaningful comments. I am happy it is so : )

@Hip-hopgranny 4 года назад

Mike I want to thank tremendously for uploading your lectures. I recently graduated from USF with a Bachelor's in Business Analytics Information Systems. Unfortunately, I was taught any advance or mid-level functions in Excel which makes getting hired even harder. I have watched a few of your videos and I am fond of your teaching style. You bring excitement and patience to a subject which can be dry. I have already subscribed to show my support. Thanks again for taking the time to upload and share your knowledge.

@excelisfun 4 года назад

You are 100% welcome! I become a teach two decades ago because non of my professors in grade school taught Excel. So I got into academia to change all that. Even now, 20 years later, academia around the world fails most graduates because they do not teach them Excel. Glad to help you, Mark!

@excelworx8712 4 года назад

wow, Mike. that is the most thorough lesson on anything i have seen in a while!

@excelisfun 4 года назад

That is what I do: provide the full story, for people like you who want to know : ) Thanks for your support on each video that you learn from with a comment and thumbs up, and of course your Sub : ) Those help me to further the goal of free education to the world : ) : )

@excelworx8712 4 года назад

your effort is much appreciated

@MrSemyonoff 5 лет назад

Mike, thank you so much for all these videos!

@parttimetrader7448 4 года назад

Fantastic videos series. This is just what I have been looking for on RU-vid and you are a great teacher - thank you so much!

@excelisfun 4 года назад

You are welcome! That is why I post : ) You can help on each video that you learn from with a comment and thumbs up, and of course your Sub, Part Time Trader!

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

Thanks Mike, you are the best instructor, really appreciate your dedication!

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

You are welcome! Thanks for the support : )

@mihailela2267 5 лет назад

I think this video took you hours and hours Mike. I don't have words to thank you enough. This video has been "dissected", I'm going to the next one right now!

@excelisfun 5 лет назад

Each video in this series took 50 or more hours to make. A couple of them took over 200 hours with all the research, story boarding, Excel file creation, filming, editing, re-filming, post production prep and so on...

@excelisfun 5 лет назад

Thank you for helping to support this effort to bring free education to the worl with your comment and Thumbs Up on each video : ) With a Sub and tell all your friends too : ) Thanks, Mihai!!!!!

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

All your videos are amazing Sir. Great work. U have no idea how useful this is for me at the moment. Thank you very!

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

You are welcome very much, Hernan!!!!

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

Mr Excel , Boss Of innovation 💡

@kamalnaserkroor4834 4 года назад

Your are the master! an epic video as you call it. Very thorough and detail. Step by step.

@excelisfun 4 года назад

I am glad that the video helps, Kamal!!

@chitangwang3789 6 лет назад

It's really awesome ! I am so lucky to see this video and learn from Mike's video. Thank you so much , Mike !

@excelisfun 6 лет назад

You are so welcome, ChiTang!!!! Thank you very much for your support with comments, Thumbs Up and Sub : )

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

Thanks for offering this for free! This is great info!

@AbhishekRajput-vu9hu 4 года назад

I love your videos form India. Mate you are making great contribution. Very helpfull to practice with the videos & exercise files.

@excelisfun 4 года назад

You are welcome, Abhishek!!

@monicazheng4332 4 года назад

Best Excel channel . Learned a lot from you. Thanks

@excelisfun 4 года назад

You are welcome, monica! Thanks for the comment : )

@adipai 5 лет назад

Wow ! The best training videos on excel i found on the internet !!

@excelisfun 5 лет назад

Glad you found it and it was good for you, Adithya!!!! Thank you for your support with your comment, thumbs up and Sub : )

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

#MSPTDA. Such an amazing series of Video from Mike. Wonderful. So wonderful.

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

Power Query is power in both Excel and Power BI : )

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

Mind absolutely blown. Thank you for making this!

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

My pleasure! Blown minds lead to efficient work ; )

@salmanshah39 4 года назад

God Bless u Man. Keep on helping man kind. my first intro to Power Query and i loved it. Wanna Learn more

@subhadeepbhattacharya6179 Год назад

Amazing video!! Thanks, Mike, for delivering this. Hats off to you, the passion and dedication with which you have created these videos. For me your channel is the go-to place.

@excelisfun Год назад

Yes!!! Glad you like what I post : )

@arvinportugal4659 4 года назад

Thank you for sharing your knowledge in excel. Very helpful

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

You are just great sir... Thanks a lot for this such a valuable information... 🙏🏻

@corinnekennedysammieeisen4392 5 лет назад

Absolutely Genius Mike

@excelisfun 5 лет назад

You are welcome, CoCo Paris!!!! Thanks for the support : )

@khaledibrahim5268 5 лет назад

oh my god unbelievable >>> i want to be in your expert level in excel !!

@mattschoular8844 6 лет назад

Great work Mike.....thank you for sharing your knowledge. 👍

@excelisfun 6 лет назад

You are welcome!!! Thanks for the support, Matt : )

@bactran7799 6 лет назад

amazing with great details video, thanks so much Mike

@excelisfun 5 лет назад

You aer welcome so much - thanks for your support : )

@NimaIranian 5 лет назад

OMG, that's really great Man! ThanK you a bunch of PowerQuery

@excelisfun 5 лет назад

You are welcome a bunch, Mohammad!!! Thanks for the support with your comment, Thumbs Up and Sub : )

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

Love these DA videos. Thank you.

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

You are welcome!

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

Awesome stuff...even beginners can learn easily...all your content is awesome Mike...just love your work...I believe all those watching should like it...its the least we can do🙏

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

Glad you like my classes, SS!!! Yes, they are free classes, but I do charge a thumbs up ; )