Beginner's Guide to Excel Get & Transform / Power Query

Рет қаралды 120,387

Technology for Teachers and Students

Күн бұрын

This video will show you the basics of Excel "Get & Transform" (also know as Power Query) so you can get started using it. Get & Transform can help you clean up irregular data in Excel, and this video shows you how to do so. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... See my entire playlist of Excel videos: bit.ly/tech4excel Here is the practice file that goes with this video: bit.ly/gettransform1 You'll find the Intermediate Guide here: • Intermediate Guide to ... #excel #exceltutorial

Пікірлер: 46

@moshelieberman732 4 жыл бұрын

Amazing! Thanks to this as well as all your tutorials, I have gained a vast array of knowledge in navigating Excel. You are a true wiz in teaching, articulating everything so clearly.

@sarvavishy8154 3 жыл бұрын

This is great and explained in a very simple way. Thanks

@mgonzalez7412 4 жыл бұрын

Thank you! Very clear and extremely helpful. 👍

@toml8569 Жыл бұрын

This was a great tutorial. You made it very simple, Plus a bonus sample spreadsheet.

@emmywong8093 4 жыл бұрын

This is great, Now I know what is Power query for the first time. Thank you for sharing!

@danemmerich6775 2 жыл бұрын

That is a Great tool! You are so Talented!! You definitely know how to get your point across so quickly where anyone can understand it!!....on all your Vids!

@vlerasaraci6309 2 жыл бұрын

this was the best video I have ever seen for Get and Transform Data! Thank You soo muchh

@muhammadsawaidafridi4204 4 жыл бұрын

You are doing an amazing job, Great work.

@vcn1945 4 жыл бұрын

Thanks again! You made my day once more. Thanks

@RossMaynardProcessExcellence 3 жыл бұрын

Lovely clear explanation. Top marks!

@jennifergreggs750 2 жыл бұрын

So helpful! I was intimidated by Excel but this makes me feel confident. Thank you

@arshadullah1066 2 жыл бұрын

Jennifer, which MS Office version is this?

@BBB-fe9up Жыл бұрын

You just saved me a lot of time! Thank you so much!

@wazmink2459 8 ай бұрын

Very simple and easy to understand teaching about power query. thanks for this channel.

@weihuang6207 2 жыл бұрын

Very helpful. Thank you!

@jeff14861 4 жыл бұрын

Thanks so much for the great video. Please create more windows showing how to clean up data with Get & Transform.

@abbysav886 3 жыл бұрын

thanks for this video! really helpful!

@apn6824 4 жыл бұрын

Excellent... Awaiting your further videos in power query..God bless

@moumoussa935 4 жыл бұрын

Thank's it really perfect!

@marklockhart7555 2 жыл бұрын

Fantastic, Thank you for this!

3 жыл бұрын

It was very helpful! Thanks

@oliversantos8310 4 жыл бұрын

Wow WOW! I really enjoy these videos, best teacher ever!

@danemmerich6775 2 жыл бұрын

Yes him and Kevin are by far the Best. I prefer Teachers!!!!

@sekotlampolokeng-oj2jz Жыл бұрын

You have contents. You are clear. I can't wait for the next tutorial

@renegarcia6204 2 жыл бұрын

Thank you so much. Very helpful 👌

@missbecky2571 Жыл бұрын

Thank you! Very helpful video!

@user-vs4tk8ih7l 6 ай бұрын

Amazing video. Thank you!

@KlutseHilda Ай бұрын

Thank you very much for this tutorial. It's beneficial.

@deebaxley7800 4 жыл бұрын

How many thumbs-up can I give this video? 100?? Terrific lesson. You make it so easy.

@klauswang9094 4 жыл бұрын

That’s soooo cool!!!! I didn’t find this option on mac 😭

@adaezevera 2 ай бұрын

Wow I really find this so helpful Thank you

@richiebambara3980 2 ай бұрын

I found this to be really helpful for the job that I will be doing very soon.

@gillybee3606 4 жыл бұрын

Do you have any lesson of how to create an aviator. I’m doing lesson plans for my students on Google and this would be awesome for their first assignment. Your channel is great, and I look forward to Monday’s

@philisiwesibeko56 Жыл бұрын

This is so amazing thank you

@raahimirfan5996 4 жыл бұрын

Sir which graphics table will you recommend for online teaching? Is Huion H640P a good choice?

@bareeraaftab2305 2 жыл бұрын

You are great teacher

@hectormercedes6553 2 жыл бұрын

Hello teacher.Very important video for me that i am beginner.

@thangaveluraj Жыл бұрын

Very interesting and useful

@nihayatsabah2166 4 жыл бұрын

Thanks 🌹 😍

@halalsharesstockexchange278 2 жыл бұрын

Great sir

@ndelpurg 2 жыл бұрын

More videos on more power query functions Thank U

@edcooper1471 4 ай бұрын

Thanks!

@techteachersandstudents 4 ай бұрын

Thanks so much for your kind gift. I really appreciate it!

@joshuaajibade1572 2 жыл бұрын

I have seen several videos with no one doing this on Excel 2016. I have Excel 2016 Professional 64-bit which comes with Power Query already installed. It doesn't have "Get Data" but "New Query" and there's nothing like "Launch Power Query Editor" option. Worst of it is that: I cannot see any option like Combine and Transform Data (after doing New Query > From Folder) in earlier versions of Excel. Please help me people.