Get access to the complete Excel Power Query course HERE: www.xelplus.com/course/excel-power-query/

@xalidmlikov7322

3 жыл бұрын

How to import live data excel to spreadsheet? Please help me

@xalidmlikov7322

3 жыл бұрын

My e-mail adress is melikov_xalid@yahoo.com

@xalidmlikov7322

3 жыл бұрын

Please help me

@sustianrubel1808

3 жыл бұрын

I wanna learn excel from basic to advance in a sequent. What playlist should I follow?

@GiteshBajaj

3 жыл бұрын

Can we import data from one drive folder insted of local computer folder.

I love the way you explain and turn complex matters into easy ones. You have a very good syntax, perfect diction and a very comfortable voice tone. Excellent in all levels. Thank you!

Leila!!!!! You are a gifted instructed. This video was loaded last week but I was not really enthused to watch. The reason is I have some knowledge on this subject already and do apply them often. I decided to watch it today and was blown out. You have an amazing way of teaching even familiar subjects clear enough to impact further knowledge and deeper understanding. I am definitely signing up for your PQ course

@LeilaGharani

4 жыл бұрын

That's great! I'm happy to hear that.

I will forever go to your videos first when it comes to anything Excel related! I even watched your video on the Bing Chat and loved it! You're an amazing teacher and make your videos easy to follow and understand.

I use to append by individual files. Its time consuming. This is a life saving solution. Append by folder. Thanks Leila. You're truly a excel gem

@LeilaGharani

4 жыл бұрын

You're very welcome!

Perfect! Everytime I got trouble, searching google and reach your video, my solution was there. I must love you Leila!

This was so useful Leila. Thank you for putting it together!

Great tutorial! Everything is exactly what I need!

I always enjoy coming back to your videos if I need a refresher. You're an absolute superstar

Great teacher as usual ! Thanks a lot again and again !

Learned a lot from this as a beginner, thanks Leila

You are absolutely amazing. Your work is highly commendable.

Leila is an awesome trainer. This looks like powerBI implementations tool

@Hurairahgiri

2 жыл бұрын

You're right. Both Excel and Power BI have the same Load & Transform Data tool.

You saved my life today! thank you so much! I'm a beginner in Excel and had work to do with a bunch of workbooks. Power Query made it easy!

I've been looking for this exact tutorial, to combine non table formatted data sets from multiple file with bare cells above the excel data headers. This will save me so much time, Thank you so much. Cheers!

@LeilaGharani

4 жыл бұрын

Glad to help Joe!

Amazing and very useful tutorial. Thank you!

Thank you for sharing this useful clip!

Thank you. I had watched this video a million times, but finally came in handy at work. It has saved me so much time.

Thank you! Very straightforward and helpful!🙂

Thank you, it was really helpful!!!

As always, practical and great example. Thank you!

@LeilaGharani

4 жыл бұрын

Glad you enjoyed it!

This is the best video on KZread that explains how to do this. Thankyou for this!

Great video as usual Leila. You're the best! Thanks!!

Very well explained! This video purported to explain exactly what I needed to do!...and it did! Thank you.

Awesome, the Power Query course is coming!!!! I just can't wait to learn it from you Leila!!!

@LeilaGharani

4 жыл бұрын

It sure is! I'm very excited. 😘

Thank you for giving us your knowledge. You're a great teacher. Excel is great!😁💪

@LeilaGharani

4 жыл бұрын

I appreciate that Aleksander!

Excellent tutorial, Thanks Leila.

This was a lifesaver. So well explained. I’m in for the course.

@LeilaGharani

3 жыл бұрын

Glad to hear that, Steve!

Clear and concise Thank you for the guide

I append tables frequently. This will make it much easier. And it's great to know that column order doesn't change how it appends. Thank you so much.

@LeilaGharani

4 жыл бұрын

Glad it was helpful!

Thanks Leila. As always, there's some great info here. Power Query is so powerful!

@LeilaGharani

4 жыл бұрын

It really is!

Thank you! I could not figure out an error encountered after updating a transform sample file, but you addressed it right away w/ removing the "Changed Type" step.

Excellent content and presentation!

This is exactly what I needed. I've been looking for something like this for a while. Thank you.

@LeilaGharani

Жыл бұрын

Happy to help, Jorge!

Amazing. So clear. Thank you.

Awaited one from your end. Thank you.

@LeilaGharani

4 жыл бұрын

Hope you enjoyed it!

Thanks for another knowledge !!!!!

In love with your teaching and your sweet voice as well.... Enrolled for your excel course.....

@LeilaGharani

4 жыл бұрын

That's great! I hope you'll like them.

Leila, you absolutely blow me away. I had no idea this was even possible.

@LeilaGharani

4 жыл бұрын

Glad to hear that Cathy 😁 Power Query really is Power.

Thank you so much for this tutorial! Exactly what I needed! :-)

great info, thank you very much.

This has solved one big problem I have in my daily tasks. Thank you for the video, you are amazing

You just saved me hours of work! THANK YOU!

THANKS A LOT MAM ! VERY HELPFUL & TIME SAVING

So helpful. Thank you!

Leila, I could understand most of your videos but this one went over the head. Really looking forward to the power query course!

@LeilaGharani

4 жыл бұрын

Don't worry. In the course we'll start with the basics. It will make it easier to follow along.

Thanks! It worked well

Thank you - this really helped me alot

Dear Leila, Thank you for many many videos from which i have plenty of excel tips and tricks, and have managed to provide with more professional looking charts. Whilst i have learnt many i saw a beautiful chart with combining a doughnut chat with a bubble next to each slice, where the bubble size changes with the size of the slice. Would appreciate it very much if you could look at how we can do this in excel

Excellent, thank you

Really helpful lot.. thanks

Aha! I just registered for the alert, once the PQ course is available!

Thank you. You solved my problem. Great!

Great video Leila, but I have a question. I have 12 individual sheets, each represents a full month sales. Is there a certain way I should name each table or sheet that will work better to represent the data for analysis? Example, should it be Jun-2020 or June 2020 or 07-2020? I've searched online but can't identify a good solution. Any thoughts you have would be much appreciated!

Great Leila really helpful.

Terrific topic … perfect presentation … ;)

Fantastic!

This was amazing. Thank you. I googled around for this for months where every example was using VBA until I decided to search youtube and found your channel.

@LeilaGharani

3 жыл бұрын

Glad it helped!

All I say leila's Video too good for learner'.and very happy with.

Thanks for this video

Hi Leila.. thanks for the video.. great! Looking forward to more transformations inside your new course. Thumbs up!!

@LeilaGharani

3 жыл бұрын

I hope you'll enjoy the course, Wayne!

Thx, Leila, excellent!

Very good explanation. Thats helpful. Thanks 👍

Your video's quality are always awesome!! Love from INDIA 😍

This is just great!!! Thanks Leila

@LeilaGharani

4 жыл бұрын

Glad you like it!

Thank you Ms. Leila. Thanks a lot to help people to do better their office jobs.

@LeilaGharani

3 жыл бұрын

Our pleasure, Jorge!

I've read some interesting articles from Ken Puls on combining VBA and PowerQuery. I wonder to what level Excel can be pushed by combining these 2 great features.

Amazing video. Life saver for me!

Best lectures May she live long with health and wealth too

thank you so much for this

Yet another awesome tutorial! Thank you.

@LeilaGharani

3 жыл бұрын

My pleasure, Andrew!

You helped me overcome the fear and resistance I've had to learning how to use Excel effectively. I didn't even know that Power Query existed, and suddenly a world a pivot tables, grouping, and aggregating opened up where I could easily conquer my problems without even needing to use a formula. I could weep for the years of frustration and struggle seeing how easy you made this for me, in a few minutes. It's not just the easy to follow logic and excellent presentation but also your tone of voice that reassures me at every step that "This is easy I can do it". Thank you.

@niranjankumarcoimbatore5842

2 ай бұрын

nice review....no weep...only sweep victory....

Hi Leila!Great Tutorial,Power Query Is Simply Awesome Especially When You Add The Power Of DAX FUNCTIONS Into The Mix..Thank You :)

@LeilaGharani

4 жыл бұрын

So true! The combination is amazing.

@woljin

4 жыл бұрын

I almost wanted to report you for talking dirty LOL JK

Thank, it helps me a lot..

I just subscribed, partly because i needed much of your excel knowledge, and partly because you are incredibly beautiful.

@LeilaGharani

4 жыл бұрын

Welcome aboard :)

Great tutorial thank you

Hey Leila..thank you for this tutorial, very helpful! is there any way we can add new blank column in the power query table and, in that blank column, we create a hyperlink to connect to original data sheet? I am making a sort of progress tracking page by consolidating all the tables i have in different sheets so my audience can track their progress from 1 single sheet instead of opening 1 sheet to another. But this consolidated tables are not for them to edit/enter information, i still want them to go back to the individual sheet to update a data. And i want to provide a link to this individual sheet. Could you pls teach me? Thank you.

Thank you a million :)

Thank you so much.

great lecture

You are a genius...Thanks for sharing these tricks with us!

@LeilaGharani

4 жыл бұрын

My pleasure :)

thank you so much.. help simplify repetitive work of combining files.

@LeilaGharani

2 жыл бұрын

Welcome 👍

Thank you so much

Excellent video.

Thank you, thank you and thank you! And before I forget: thank you!!!

Nice explanation

Super clear, thank you, nice animation 5 star

Hey!! thanks very much!! Really it is helped me a lot:)

Very Nice Mam

Very insightful and easy to follow through 👍

@LeilaGharani

4 жыл бұрын

Glad you think so!

Great functionality! The more you can dispose of VBA the better.

This is my first lecture of Leila Gharani. But I am impressed the way she describe and show Power Query

Excellent Leila.....

EXCELlant! Thanks!

You are the best👍

Thank you🙏

Thank you! I had to pull together a few sale reports for a customer today, had find this tool very useful. However, I might have to practice this a few times to get it to work.

Excellence in training strikes again. Thanks, Leila.

@LeilaGharani

4 жыл бұрын

My pleasure Jim!

Thank you so much, this makes my life easier!

@LeilaGharani

3 жыл бұрын

You're welcome, José!

This is exactly what I need as a billing analyst to combine multiple sources of invoice data!!!! Awesome video

@LeilaGharani

3 жыл бұрын

Glad it was helpful!