Grab the file I used in the video from here 👉 pages.xelplus.com/web-query-file

Best part of the video is when you said; "it is just part of Excel"! That seems to be our main job as Excel Trainers, to convince Excel users that Power Query is the greatest Excel Invention since the PivotTable : )

@LeilaGharani

4 жыл бұрын

Very well said Mike! The name power query does scare people away just like pivot tables. If pivot tables were called one-click-reports I think more people would be using it... that‘s probably why Microsoft renamed power query to „get and transform“ when they put it in the data tab.

@borstenpinsel

4 жыл бұрын

I find it's really inflexible like all external lookups, even to other excel files. I had lots and lots of trouble editing an existing query, for example. Ended up creating a whole new query from scratch, instead.

@ricos1497

4 жыл бұрын

@@borstenpinsel You should probably check out some videos on it. It's very straight forward to use. More so with the intellisense that comes in the latest versions. When just using 2016, I do find I have to google the correct formula syntax due to lack of assistance, but that's probably a good way to learn too. Make sure you read the formula bar each time you create a step to get an understanding of the formula syntax and how you might tweak it for your queries.

@brianxyz

4 жыл бұрын

@@borstenpinsel Power Query is super flexible. I don't think there's anything that it can't do.

@chriswall4795

3 жыл бұрын

Better than pivot tables

Thank you, Leila, I love the way you present things in such a simple and clear way!

what i like about Leila is, she has a sense of art beside Excel technics.

@corgikun2579

4 жыл бұрын

She has what I want ... Excel knaaawledge

@minshum

3 жыл бұрын

...and she's easy on the eye.

Leila is a combination of an artistic and techy person.. also, the best thing about her is she gives credit to whom she got the idea.

i have been trying to learn different skills over the past few months. But all where left incomplete half way in the journey. Today started with your videos. Have been practicing them since morning. Very effective. Concise, to the point and more importantly they address real time work challenges. Thank you very much

@LeilaGharani

3 жыл бұрын

My pleasure.

THIS IS ONE OF THE BEST VIDEOS I´VE EVER SEEN ABOUT EXCEL POWER QUERY. THANKS A LOT.

THANKS FOR ALL YOUR WONDERFUL VIDEOS! yes, I am shouting from the rooftops about your wonderful teaching skills!

Leila, you are amazing! Thank you for open to us this precious jewel

More amazing Excel majic described by Leila. What a wonderful world.

Nice. I learned something new. I also wanted to applaud you for giving credit for the work you borrowed from someone else. So many KZreadrs just steal and claim content as their own

Hi Leila. My name is Julio and I live in Brazil. I'm studying a lot about Excel. I need to give my career a boost and I believe that Excel will help me a lot. I love your channel and the way you teach. Congratulations.

Amazing.... I was given such task before which I couldn't... You just made my day Thank you Leila

Thanks so much for your videos, Leila. They have been so timely and have enabled me to make so much progress with my project.

Now that was 'Transformational' !! Great tutorial

Wow. This is a very sophisticated reporting format. Thanks for teaching these kind of useful things...

Great video. Quick and clean. Thanks!

Really appreciate your teachings.

Thank you, that was really useful. it will definitely save me a lot of time!

Amazing, Thankyou for sharing your knowledge and explaining so well.

While carefully reviewing all your videos (after discovering your amazing channel), I realize about this functionality. So,... I only can say to you, Thank You Very Much. Based on it I got a bunch of ideas that will make me progress in my complex reporting. I often say that if EXCEL would suddenly disappear, the whole world would have a deep impact at all levels. In the same way, I want to say that your video courses, your teaching skills, and advice make the world get a bit better. Faithfully Yours.

@LeilaGharani

3 жыл бұрын

Thank you! I'm happy the tutorials are helpful.

Am always amazed with your videos Thank you Leila

Great content!Thanks so much!

Beautifully explained, Excellent

Always great practical knowledge for learning.

Wow! I didn’t think this was possible in Excel. Thank you.

Excellent tutorial. Many thanks.

Thank you, Leila, for making things easy.

Excellent video! Thank you!

I am a regular watcher of technology videos but the you explain things is just awesome thank you so much your initiative

Predictive Excel so easy with YOU 🌟

Hi Liela, Thanks for this excellent video, it makes it simple to understand how to get data form a web page. I'm sure it will save me a lot of time. Regards Enrique PD: Your English is really clear and your pronunciation makes this video understandable for everybody.

I am learning not only Excel, but how to organize a video about a concept or concrete theme, and try to explain in a short time. Really impressive Leila, you have a special touch.

@LeilaGharani

4 жыл бұрын

I'm glad to hear that Francisco!

@neorvo5599

4 жыл бұрын

@@LeilaGharani This is a dream

Absolutely amazing. Never knew excel had this feature.

@shawnsmith1865

2 жыл бұрын

NOPE and i am thrilled to discover this. What a Power Tool at hand.

Amazing, very good. Thanks Leila!

I started to get used on your vedios, thanks thanks thanks a lot. You are really great inspire for all content creators.

Power Query is awesome. Thanks Leila..

@LeilaGharani

4 жыл бұрын

It sure is! Thank you for your support Matt.

Thank You... Learnt a lot

This is super. Thanks a lot Leila Gharani. I keep checking your video tutorial.

You are AWESOME! Thank you!

Wow, this is super useful!

brilliantly explained will definitely be enrolling for the course thanks

Thanks for the help! Super useful 👍

Very useful...Thanks a lot.

Mind blowing...! Saving money to buy your black belt course and add value to my life.

you are really genius EXCEL world no.1

If the external data source requires a password you can add that in "Data Source Settings" - check out this page: support.office.com/en-us/article/data-source-settings-power-query-9f24a631-f7eb-4729-88dd-6a4921380ca9 (If you don't see the option in the Ribbon, go to Power Query, File, Options and Settings, Data Source Settings - Edit Permissions - Edit - Basic - The input username and password. )

@mukesh1019

4 жыл бұрын

Was wondering if you could please help me. I have Excel for Mac and there appears to be no DATA>GET DATA >FROM WEB. Mac version instead has GET EXTERNAL DATA and then RUN WEB QUERY. How do I get this done on Mac. Thanks.

@barnold23

4 жыл бұрын

Leila, you’re the total package - beautiful, brilliant, and an Excel nerd! :) 😍😍😍 Marry me?

@isabellegueret8142

4 жыл бұрын

Hi, Is It possible to refresh based based on a cell change ? For ex if i fill cell E4 the refresh is done automatically? Thanks

@Learnunique007

4 жыл бұрын

I have 1000000 lakhs same data in 4 sheet how can i marge in one pivot

@ravisankar295

4 жыл бұрын

Thank you so much! I will try...

Very useful ! First class tutorial

I had no idea this was possible. Thanks!

I love the way you talk

That was literally phenomenal... Excel is really a power tool for entrepreneurs such as myself.

@LeilaGharani

Жыл бұрын

👍

Thank you for explaining this so well!

@LeilaGharani

3 жыл бұрын

You're very welcome!

This is amazing! Exactly what I've been wanting to do with large budget and actual datasets. 🎉

Sheer presentation wins my ❤️

Thank for the video, so interested.

Good info Leila. Keep it coming.

Extremely useful 👍👍👍

Bravissima!!! Super clear and useful!

Thank you for this, much appreciated!

Amazing video!!

Excatly what I needed, thank you.

Excelent video. Thank you.

You are amazing Leila! Thank you for these tips!

@LeilaGharani

4 жыл бұрын

My pleasure Gustavo.

Lifesaver. Thank you!

That was amazing, didn't even know about that....

@brandonhowarth2402

2 жыл бұрын

Like information feeding document not information breeding like make new documents? Like copying deleting paste share like that? Do those deleted files return if use special program? Emcase you wanted them back? I'll see you later on until next post? In next months?

@Bob-qs3sf

2 жыл бұрын

@@brandonhowarth2402 for sure I knew that way for easily importing data from web, I wonder for the fact, that I have to give up thumb and subscribe if I like this video. That's Amazing, never knew about this option on KZread.

this is quite helpful! saved me lots of time. thank you so much!

سپاسگزارم آموزش بسیار عالی لود. ،🌺

Thanks for this video

😀 happy to see this short entertaining tut, well done

Thumbs up for the last trick. It was amazing to use emojis in power query. Thanks

@LeilaGharani

4 жыл бұрын

Glad you like my little umbrella :)

Wow! That is amazing!!! 👍🏻👍🏻👍🏻

How cool it is to have emoji in Power Query! That's really creative!

I opened the Emog (Window Key + the period) in the area where you pasted the umbrella Equipped and selected all the different symbols I wanted. Then Cut and pasted them in the other cells. Thanls for the fun weather program.

Very cool features. Thanks Leila!

@LeilaGharani

4 жыл бұрын

agree - it's a really cool feature.

You are realy great. You saved my day and job. Thanks a lot.

Thanks for the awesome video.

I really appreciate your efforts

@LeilaGharani

3 жыл бұрын

It's my pleasure

Thank you Leila, nice and easy way to explain!!

@LeilaGharani

3 жыл бұрын

You're very welcome 😊

Leila you always amazed us with your versatile brain 🧠. You beauty with the brain.

Leila, eres brillante!!!!!! Muchas gracias.

@LeilaGharani

4 жыл бұрын

Con mucho gusto Carlos :)

Thank you once more.

Best excel guru on youtube :)

@LeilaGharani

4 жыл бұрын

😘

Amazing leila thanks a lot, you rock!!

Thanks a lot Leila ! 🙏

Thank you very much

Wow..that was excellent!

Absolutely amazing, thankkkkkk you Leila for this tutorial

@LeilaGharani

4 жыл бұрын

You're very welcome.

Nice! As always, you're full of brilliance. Question: Can you share with us some tips on how we can select a specific date such as MTD Report from the examples you've shown us?

Thank you our queen of Excel. Quite interesting.

@LeilaGharani

3 жыл бұрын

Glad you think so!

Thank you Leila!

Thank You Ma'am

Great stuff - thanks a lot LG!

Nice clear and concise explanation. I real like your videos.

☔☂☂ very nice video . thanks Leila

One of my most important aspirations in 2019 is that you have a course in business intelligence tools that are as fat and complete as the VBA

Maam ur presentation was awesome 👌 really a useful one

YOU are great Thanks alot

Wonderful!

I love this video! I'm beginning to build an Access Database, and I think a light bulb just turned on for me. Thanks so much!

@LeilaGharani

3 жыл бұрын

Great to hear, Bryan!

Very enjoyable and user friendly