How Power Query Will Change the Way You Use Excel

No video

How Power Query Will Change the Way You Use Excel

Рет қаралды 1,861,138

Leila Gharani

Күн бұрын

Пікірлер: 1 000

@LeilaGharani 4 жыл бұрын

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

@hanlieingels6634 4 жыл бұрын

How do I get a discount coupon - I am in Namibia and US very very expensive - I work for a wildlife NGO !

@faizanshah4434 4 жыл бұрын

)) Pool al

@firasmusmar2097 4 жыл бұрын

the discount code is not working !!

@williamstan1780 4 жыл бұрын

The coupon seems to be invalid

@erinmarie6047 4 жыл бұрын

My work computer has the option to “load Power Query Editor”, is that considered the same thing as “Power Query”?

@florentchif4551 4 жыл бұрын

To everyone new to power query: I started using it 1 year and half ago. I learned by myself as it is really easy for 98% of things you want to do. It totally changed my way of working. Since then I never had the feeling that I needed to re-do everything from scratch again and again. And Power Query is just the beginning, when you start using Power Pivot it gets even better (both work together). Ah and also, while you learn these 2 on excel... be aware that you are learning Power BI as well as the engines are the same at 99.9%. So yes, go for it, it will change your life forever. (Personally thanks to these new skills I got a better job at a bigger company).

@LeilaGharani 4 жыл бұрын

Thanks for sharing your experience, Florent!

@onwedavid9124 2 жыл бұрын

Motivating.

@zyver6784 Жыл бұрын

i wish i can as well, tried to learn by myself and gets annoying at time.. i only need to consolidate the inventory serial number i scanned.

@ashishsawant2406 Жыл бұрын

Please share the resources or channels you used

@jianjunhe3440 Жыл бұрын

Totally agree and really it's a game changer

@excelisfun 4 жыл бұрын

Power Query is the greatest Excel tool since the PivotTable, without a doubt!!! Making Excel better since 2013 : )

@LeilaGharani 4 жыл бұрын

Mike - I first learnt about Power Query from your amazing videos :) Thank you for all that you do for the community.

@excelisfun 4 жыл бұрын

@@LeilaGharani Thank you too, Teammate : )

@markmathews91 4 жыл бұрын

Clever plus humble. I have recommended and benefitted your channels massively. I'm in the middle of doing msptd course

@joshuamanampiu6489 4 жыл бұрын

@@LeilaGharani I love the appreciation between two of my favorite instructors.

@innosanto 4 жыл бұрын

I know some about powerquery and want to improve. I also know some M but want to improve it significantly and become strong in M. ( and Dax). But, up to know, what I have not specified what it is, is Powerpivot.

@ngwafabrice9561 Ай бұрын

I'm an advanced excel user and data analyst today because of Leila, I still have some of her exercises saved in my laptop from years back. Believe or not I came here with about 10 percent knowledge of excel today I can automate with vba vcuz of her.. thanks Leila. Wish u knew what u did for me❤

@RobertLongM 4 жыл бұрын

Wow - you even went to the length of showing how to do it BEFORE Power Q... That's a Great Teacher!

@ZL1LoVeR 3 жыл бұрын

The example at 3:05 is so relatable, this is a good chunk of what we FP&A Analysts deal with everyday. You nailed it Leila!

@Timurlane100 2 жыл бұрын

I've been out of the tech field for about a decade, but your walk through here was so clear and concise that I felt right at home, even to the point of standing up and shouting (metaphorically at least) "Yes! Where have you been all my life!"

@LeilaGharani 2 жыл бұрын

😁

@marilenatzortzi5175 22 күн бұрын

There are hundred thousands of not millions of tutorials out there, written or in video. The abundance for any little thing you want to learn is crazy. However, you watch and read and while the tutorial is going on, you actually follow along quite well. BUT, a day later or two, you remember nothing. With your approach, which is a very structured one focused on actually teaching concepts rather than excersice follow along, you teach know how in such an amazing why, you actually really learn. I am very thankful I found your videos because so far I intuitively try to understand from various sources but with your educative style I can really get it.

@Craig.Coates 2 жыл бұрын

You’ve no joke, just changed my life, and probably saved my career. THANK YOU

@andrewadams8601 3 жыл бұрын

I first heard about Power Query when looking into PowerBI. I was excited to learn that it's built in to Excel, and I recommend it to anyone that needs to transform data in Excel. I'll have to check out your course, because there's a lot that I have to learn about it. Thank you for the great content; you're a great teacher!

@nobodynobody1235 4 жыл бұрын

Leila, you are a great teacher. I am impressed that you even showed how's it's done the old school method (to be honest, the old school method was what driving my heart pumping and excited about using excel :)) But in the working environment we are in now where velocity + intelligent = success, power query no doubt is a very useful tool to have. And you are only showing the viewer on 228K+ rows of data, think about having more than 1 million rows where native excel just can't handle.

@LeilaGharani 4 жыл бұрын

So true! Glad you liked the video.

@rc.9764 4 жыл бұрын

You are more than a simple Microsoft MVP.. You have talent, you have an Hypnotic voice, you know how to communicate, you have a charme, you have the knowledge..but most of all... you know how to teach.Thumbs up. You are a number 1. Bravissima!

@LeilaGharani 4 жыл бұрын

Wow, thank you!

@cherijoli 3 жыл бұрын

I just signed up for the class. Please take my money LOL. There is literally no one on the internet that makes things as easy to understand for all levels of expertise, as fun, or as pleasant to watch! I am so glad I found your videos!! You have saved my life and made my job more tolerable.....and even exciting!

@LeilaGharani 3 жыл бұрын

Thank you! I hope you'll enjoy the course!

@faYte0607 4 жыл бұрын

Love this video format, Leila! You've thoroughly thought through the perspective of your audiences and created a video that justified signing up for your course, without being pushy at all. Thanks for all the years of teaching me Excel!

@LeilaGharani 4 жыл бұрын

Wow, thank you Peter!

@AShina-zn7nx 4 жыл бұрын

You see reason why I keep referring my folks at the office to this page, easy to assimilate. Your teachings have safe me many times, and this Power Query video is the best ever. Thanks Leila

@LeilaGharani 4 жыл бұрын

Wonderful! Many thanks for your support.

@alanhorowitz3796 4 жыл бұрын

To extract the customer ID, copy the entire column to a new one at the very end of your data set. Highlight the entire column, go to data, text to columns and perform a text to columns using the "-" as the delimiter. This will separate the sets of digits and the dashes into columns to the right hand side. The 2nd set of digits, will be isolated into one column. All other newly created columns can then be deleted. You've now isolated customer ID.

@firoj89 2 жыл бұрын

Your Power Query course already changed my life and got lots of appreciation in my work . Thanks for your wonderful and most interactive session for this course in Udemy.

@YvesAustin 4 жыл бұрын

Leila, thank you for this video. I cannot emphasize how much power query has changed my approach to Excel. You and Oz have been a real inspiration to me; now, I am working 99% of my excel analysis through PQ rather than regular Excel. Power query has a ton of features way better than regular Excel (the date functions are a great example of how much can be done). Power query is a real game changer. Thank you for sharing.

@LeilaGharani 4 жыл бұрын

Wonderful, Yves! Thank you for sharing your experience.

@YvesAustin 4 жыл бұрын

Leila Gharani - well I may have bragged a little about the 99%, but I am trying my hardest to manage data set transformations through PQ. Thank you again Leila☺️👍

@BestICan 4 жыл бұрын

Leila, you've brought the quality of your video production to the top of the mountain. So good!

@LeilaGharani 4 жыл бұрын

Wow, thank you Randy!

@ayoubdadda654 3 жыл бұрын

You've been around for many years, how come I didn't know about you until a few months ago, considering I'm huge Excel Fan. You're way of explaining things is magical. Well done, and keep up the great work. Sharing is caring.

@LeilaGharani 3 жыл бұрын

Welcome aboard!

@omnipop4936 4 жыл бұрын

Been using Power Query as an add-on to Excel 2010 for a year or two now. Love it.

@rasoulkhoshravan5912 4 жыл бұрын

I am using Excel 2013 but I couldn't add Power Query add-in. Could you please tell me how did you do that?

@gigiwan3335 4 жыл бұрын

@@rasoulkhoshravan5912 google power query for excel 2013 and download it from Microsoft office site, then choose the version (32bit or 64bit) and make sure you have an updated version of internet explorer and you're good to go.

@mihirbandodkar9406 4 жыл бұрын

Hello can it replace macro?

@omnipop4936 4 жыл бұрын

@@rasoulkhoshravan5912 I followed the steps in the KZfaq video below (which also mentions 2013) - kzfaq.info/get/bejne/nd2HZaZ1ydy5hac.html

@Allday1219 3 жыл бұрын

@@mihirbandodkar9406 it can be used as an alternative

@kbuj3360 4 жыл бұрын

honestly.... i no longer watch her videos for excel...i'm an expert now.... her voice is so soothing....

@deepaksahu-nf1vb 4 жыл бұрын

Dear mam I bought your course just now .I had never trusted any teacher in past ,but you are the best ,thanks for your free classes in youtube that inspired me

@LeilaGharani 4 жыл бұрын

Glad to hear it. Hope you'll enjoy the course!

@hanrealistic 10 ай бұрын

You are showing yourself more than what you are trying to teach.. Your voice is enough, we need to see every step, in details.👍

@cesara7478 2 жыл бұрын

I love how you explain the long way steps to get to why PowerQuery is a better idea. Awesome video as always Leila

@LeilaGharani 2 жыл бұрын

Glad you enjoyed it!

@bearsjourney 4 жыл бұрын

Never know about Power Query until this. Thanks so much for this!

@LeilaGharani 4 жыл бұрын

It's one of those things that once you used it you'll ask yourself how you've ever worked without it :)

@nadeemmalik8031 4 жыл бұрын

Best teacher ever in the whole of KZfaq. Examples were simple to understand.

@LeilaGharani 4 жыл бұрын

😘

@farzadshams3260 16 күн бұрын

Thank you for the great video - the example of why we should use PQ couldn't explain it better!

@mariochacon1329 4 жыл бұрын

I've learned a lot from you. I'd love yo see Power BI lessons from you

@dhaval1489 4 жыл бұрын

Leila's Checklist : Adding humor check, improving video editing check, keeping excel inserting check

@LeilaGharani 4 жыл бұрын

😘

@ricksegalCanada 3 жыл бұрын

Taking nothing away from Leila's outstanding YT efforts and training: Be aware the O365 subscription - MAC, doesn't have Power Query as part of the product. Yell at MS (as.I did) but beware before signing up for this or any power query class.

@garylillich 2 жыл бұрын

It is my understanding that it was available back in 2019

@KedielSanchezMariano 4 жыл бұрын

The least I can say about this video is that "It's a revelation" Thanks for your tips.

@LeilaGharani 4 жыл бұрын

My pleasure :)

@AdrienneEC 3 жыл бұрын

Very interesting. A friend recommended that I check you out and I *think* this may be the solution I've been looking for

@LeilaGharani 3 жыл бұрын

I hope it'll be helpful Adrienne.

@NowWhat01 3 жыл бұрын

I shared this with my coworkers immediately. This sums up a multiple data source / VBA project that we're inundated with to perfection!

@LeilaGharani 3 жыл бұрын

I hope they'll find it helpful.

@ytsedome 3 жыл бұрын

My Lady, I've just discovered you and I'm in love. watching this video I felt the whole time: How did you know my situation. All respects and praises. Instant like and subscribe.

@LeilaGharani 3 жыл бұрын

Glad to have you onboard :)

@Hortster 4 жыл бұрын

I should use Power Query more, however I would have approached the 'old school' method a little differently. I would have used the Text to Columns feature, select Delimiter and choose the hyphen as the Delimiter to use. For extra spaces, I would use find and replace the space with no space. Then for the text file, just import that into a separate worksheet instead of waiting to try and receive an excel file. Nice video though!

@baonguyenthai3840 4 жыл бұрын

I have one problem with your usage of "Text to columns" feature. It's not that it's inappropriate or anything, it's just not automatic enough for this kind of report. I mean, what will you do if next month you need to update your workbook with the new sale figures ? You have no choice but to do the "text to columns" things and all other stuff again, right? By using formulas, it's (kinda) automatic. Next month you just need to copy-paste the new value underneath your current one.

@FutureCommentary1 4 жыл бұрын

@@baonguyenthai3840 The first time you do it you can just record a macro of you doing it. Next month you click on one keystroke and you have the same transformation with just one click.

@000EC 2 жыл бұрын

I have the same criticism. The first two "difficult" problems being presented are actually quite trivial, one by just opening the text file in Excel, and the other by doing a column split. I would be surprised if Leila didn't know that, so that part of the video ends up looking disingenuous. Send it to the IT department to convert a csv? Really?

@ulligruber1344 4 жыл бұрын

Thanks Leila for the new Power Query course. It is amazing! 🥰

@LeilaGharani 4 жыл бұрын

Glad you like it Ulli!

@abdirahmanhassanabdi5128 3 жыл бұрын

hi Lieila Gharani, i can't express in words how i made use of this live simplifying clip of power query and all other knowledges you share, keep going. thanks

@VinodReddyKisanagaram 10 ай бұрын

@atsrikumar1307 3 жыл бұрын

Ihre Lehren sind sehr beeindruckend. Großartig!

@marcosahertian 8 ай бұрын

Yes, it does change my life. I got my job from being able to perform power query. Thanks a lot, Leila

@LeilaGharani 7 ай бұрын

Wonderful!

@surfer3662 4 жыл бұрын

I've seen this already ... From your online courses 😁😁😁 Looking forward to complete the course. Thanks for your tutoring Leila. Please stay safe 🙂

@2_Bike_is_Life 4 жыл бұрын

"Wasn't there a second pivot table? Damn, there was..." Coffee on my screen now... haha

@LeilaGharani 4 жыл бұрын

😁

@aamermirza5410 2 жыл бұрын

Only you can change my world Leila and nothing else can ♥️ you are a beauty with brains

@theivanlendl 4 жыл бұрын

Hey Leila, sent this video to my boss asking him for office 365. He agreed to get a licensed pack. Thanks for the compiled info! Appreciate the effort in sharing the knowledge.

@LeilaGharani 4 жыл бұрын

Awesome! That's great.

@rory1653 4 жыл бұрын

@leila, That little wave you did from power query was so cute!

@marcorozzano3480 4 жыл бұрын

I just read a BBC article that mentions you, Leila ! :)

@rasoulkhoshravan5912 4 жыл бұрын

Please give the link for the rticle

@cazmaj Жыл бұрын

A very round about way for someone with strong excel skills to get to the goals. However, can see the compute benefits of using power query.

@abmxnq 3 жыл бұрын

dude thank you so much! live long and prosper!

@LeilaGharani 3 жыл бұрын

Same to you :)

@merbouni 4 жыл бұрын

Sincerely, I prefere the voluminous files anyway, i learned a lot of tricks and ideas through old school :D PS: i learned a lot from you, from the simplest things to the most complex formulas, thank you once again leila

@urza2005 4 жыл бұрын

After watching this video I was like "Shut up and take my money!"

@hapemokenela7388 4 жыл бұрын

😂😂

@hoiying-chan 3 жыл бұрын

What a blessing! Didn't even know such a tool existed. Sorry Python, going to leave you for a while. Thank you Leila!

@LeilaGharani 3 жыл бұрын

Hope it will come in handy for you.

@PhilCaisley 2 жыл бұрын

What an excellent advertisement for the value of your course. I found myself smiling as you built the value case. Great piece of work

@LeilaGharani 2 жыл бұрын

Thank you kindly!

@ilookafterthewater601 4 жыл бұрын

Ha! After all these long years with KZfaq I finally got to do the first thumbs-up! And this for one of my favourite subscriptions, so happy daze! I feel like I just won the lottery :o)

@LeilaGharani 4 жыл бұрын

Thank you for the thumbs up!

@meniporat3527 3 жыл бұрын

Hi Leila, will it be possible to upload the files you're using in this demo? I'd appreciate it very much. Thanks

@heshanpalliyaguruge6333 Жыл бұрын

What an amazing video. The way you presented it using a proper example. I’m learning power query in my management info systems class and I’m so excited!!

@angelbhaves1 4 жыл бұрын

I've been using power query for last year and I've been able to create some phenomenal data entry sheets for work.

@LeilaGharani 4 жыл бұрын

It's really a power tool :)

@shubhamsharma8373 4 жыл бұрын

hello, ma'am, I wanna do an analysis of one Fiscal year balance sheet where we have columns of opening, debt, credit, closing. please suggest me a video to do this properly

@TheTioram 4 жыл бұрын

The first thing that came to my mind was “use ms access”. Nevertheless there is probably a lot to be learned from power query

@matsudakodo 4 жыл бұрын

Agreed

@FutureCommentary1 4 жыл бұрын

ikr! When I saw that I google "is MS access still being used." Maybe they are trying to phase it out and consolidate everything into EXCEL overtime.

@SKarea51 4 жыл бұрын

@@FutureCommentary1 well power query is a dumb down version of MSAccess. I have been using MS access incl VBA and forms for 15 years, pretty much creating enclosed data sharing applications for smaller companies. MS access has lot more to offer then just data transformation and simple joins. If you wanna be skilled analyst you need Excel-SQL-VBA. And this has been the case for last 15+ years. Excel only now contains more predefined solutions at the cost of learning them all. The only advantage of power query might be the processing speed optimization - which is aparent compared to using formulas, but question is how much compared to Access (SQL), they might be using the same engine. But at the end of the day, MS access was/is part of the most expensive MS office package, so this might be viable option for you if you were using MS access only to link soruce files do some simple data transformation so you can save some money...

@fictionaddiction4706 3 жыл бұрын

@@SKarea51 So would you say learning Access is still relevant today. Or just learn power query and it's a good non complicated substitute ?

@SKarea51 3 жыл бұрын

@@fictionaddiction4706 I would say learning access is better solution

3 жыл бұрын

Yes, PQ changed my life. 🙏 Now I can easy solve problems, which were impossible without programming..

@LeilaGharani 3 жыл бұрын

It really is an amazing tool!

@LadyLier17 2 жыл бұрын

Aaaaaaaah I have been stressing for the last 2 weeks because of this kind of tables!! And now I will have the answer!!!

@Kiyoshi_9606 4 жыл бұрын

"damn, there was" --> *realizes i've had this pain before* --> buys course

@LeilaGharani 4 жыл бұрын

Haha. I hope the course will be helpful 😊

@Pistol2040 4 жыл бұрын

My favorite part of the video. Her reaction lets you know, she has actually been there before. lol

@KorawichKavee 4 жыл бұрын

If we all just use "format as table" and power query, we can say goodbye to VLOOKUP() !.

@theHentySkeptic Жыл бұрын

Watching this has me convinced - I need to start using these great tools. Thanks.

@zp5808 11 ай бұрын

I'm quite good with formulas and although I found the first one pretty easy and straightforward and I also had no idea whatsoever what was going on in the second one I was pretty impressed. Not only because of the live data feed but because of eliminating a lot of the chances for human errors. I kinda hated Power Query due to the reason I didn't understand what happened but I was amazed at the same time. I felt like a kid watching magic the first time. Thanks!

@LeilaGharani 11 ай бұрын

Glad you liked it. Power Query really is an amazing tool.

@K6TJO 3 жыл бұрын

Leila, please please please do a series on tools and techniques for producing your videos. I love your video productions as well as the lessons.

@LeilaGharani 3 жыл бұрын

I'll think about. Thanks for the suggestion, Tim!

@mustafahussainmohsin320 4 жыл бұрын

Need Some Excel Assistance? Call Leila Gharani!!! Master of Excel !!! Again a Good Series of Excel! Learned a lot from your videos. Keep up the good work. Thanks

@nirvab.1667 2 жыл бұрын

Why am I so excited to learn this.... you are amazing!

@alreadydeadfunk 4 жыл бұрын

Power Query is such a powerful tool and what's more. It is accessible because of the easy-to-use UI. I used to be getting a lot of things done on Excel by using VBA. But now I am done most of the things by Power Query. If you are interested in coding, you may want to learn more about M language.

@amargunjal1 9 ай бұрын

Thanks Leila it's really changed my life...

@LeilaGharani 9 ай бұрын

Happy to hear that!

@roger_rogers 4 жыл бұрын

power query is amazing! i have a program i built in python that runs queries ever 15 minutes or so and saves data to a csv. i then utilize power query to remove duplicates, convert UTC date time into time formatting i can understand, and to maintain my "data" for further manipulation. amazing tool. concatenates data sets that may have duplicate rows with total automation

@LeilaGharani 4 жыл бұрын

That's what I call an efficient setup :)

@evertondel 4 жыл бұрын

For the last couple of weeks, I have been wondering where I could get good resources to learn Power Query without jumping in between KZfaq videos and them BAM!! I couldn't have signed up any quicker than I did, good value too, thank you.

@LeilaGharani 4 жыл бұрын

Great to hear, Derek! I hope you'll enjoy the course.

@dougmphilly 4 жыл бұрын

i learned power query about 5 years ago. i had to take over a project which required 100% certification that each charge was backed by a purchase order and proof of payment. thankfully, the data was all under one roof but the application did not come with canned reports to just that. i am loathed to spend the next 6 weeks 24/7 doing EXACT/MATCH, VLOOKUP, SUMIF and still not get it right. luckily, a team member asked me if i knew SQL. i mentioned that in prior position, i used SQL on multiple data tables. he said you are in luck, if you can grasp that, you can use power query. i built it from scratch, proving 99% of a $350 million job, that took me a couple of hours per day.

@LeilaGharani 4 жыл бұрын

Thanks for sharing your experience Doug!

@RehanFarhat 4 жыл бұрын

This is a brilliant approach to compare two types of processes to show which is better (i.e. Power Query).

@RogerClubv 4 жыл бұрын

I'm a huge fan and a follower of your channel. Just signed up for this class. It's fantastic. Thank you!!!

@LeilaGharani 4 жыл бұрын

Awesome! Thank you!

@davifortes9685 2 жыл бұрын

It's been 4 months since I've seen these videos about Power Query... It is Truth, my life has changed lol ETL is the new black!!!

@EmmanuelGidudu-k3t 2 жыл бұрын

i landed the right lesson for power query. thanks

@pablorages1241 2 жыл бұрын

She's pretty easy on the eye !

@BeastmanG 3 жыл бұрын

The slightly tense but exciting music in the background along with these jokes is making this really entertaining. I'm hooked for the big reveal! =D

@LeilaGharani 3 жыл бұрын

So, was the reveal worth the wait? 😎

@BeastmanG 3 жыл бұрын

@@LeilaGharani Yes, I'm very likely to sign up for this course. Power Query is something I have not explored fully and you seem to have an effective teaching style. Thanks for sharing these snippets.

@derach3 4 жыл бұрын

Leila, you’re my hero. And you’ve made me the hero at work!

@LeilaGharani 4 жыл бұрын

😘

@Gaajinikanth 4 жыл бұрын

I learn excel by watching your videos. Your video is very easy to understand and interesting.

@LeilaGharani 4 жыл бұрын

Glad to hear that!

@Gaajinikanth 4 жыл бұрын

@@LeilaGharani love you so much...

@Gaajinikanth 4 жыл бұрын

@@LeilaGharani i work as compliance officer. I need to filter and sort big data for my company. The most challenging task is based on that data, i need to prepare report which is by entering manually risk scoring for each customer. I worried i might insert wrong scoring while preparing this report. For your information there are few parameters to cross checked before entering score. Hope i can send you email regarding this doubt. I apologise because my english is not good.

@shabbirkanchwala-abwaab6263 4 жыл бұрын

Thnx Power Query Lectures by you has changed a lot ......... for excel user I think Power Query will overtake Access ... in the way you explain it in .... a very very simpler style.

@edot2068 4 жыл бұрын

You make teaching so sweet. Every student would want to be in your class. Thanks

@LeilaGharani 4 жыл бұрын

😘

@jamajama7159 3 жыл бұрын

@@LeilaGharani is this course for excel advanced users only ?

@JohnLin0821 4 жыл бұрын

You are amazing ! I use to be a MS Office user specialist master in 2000. I am surprise this Power Query technique make repeatable analysis, report so much simpler. I enroll to your course and found it very beneficial. My only regret is I should have done this much earlier ! Well worth the investment and as you said. This little skill in Excel give so much benefit for the rest of my career. Keep up the good work and I forward to learn more from you !

@meberoth 3 жыл бұрын

Very interesting. I love the way you show examples. Your teaching style rocks!

@LeilaGharani 3 жыл бұрын

Glad you think so, Michael!

@vignesh8542 3 жыл бұрын

Thank you so much mam Pls upload videos how to reconcile the two ledgers in excel using power query or macros I'm awaiting your upcoming videos

@mohammedhassan2808 2 жыл бұрын

you are well prepared comparison will legacy method vs Power Query and shown how time saving and storage saving as well Thanks and keepitup your free sharing habit

@Imzadi76 Жыл бұрын

Thank you, it really, really did. And this video was the initiator. Since than I have changed so much in my daily work. This was also what lead met to use vba and later vba with sap. Truly life changing in terms of work.

@LeilaGharani Жыл бұрын

Wonderful! Glad I could inspire you 😃

@IssueBoyStefan 4 жыл бұрын

PoweQuery is a beast in terms of transforming data. One of the best things except for all filtering data, remove subtotals, merging, and split columns for me personally is that you can unpivot data. I hope that you'll publish some tips and tricks for PowerQuery too, Leila. As always - love your content.

@LeilaGharani 4 жыл бұрын

Pivot, Unpivot, Custom columns... it really is a beast :)

@tomd1434 3 жыл бұрын

I pretty new to excel and really like it so far. I have no idea what you’re talking about yet, but hopefully one day I’ll get there 😆

@garylillich 2 жыл бұрын

Hope your journey is coming along. I have used Excel for 13 years, still learning. Power Query was not available until Excel 2016

@aliasbadshah 2 жыл бұрын

Hi Laila. Thank you for sharing all the Excel goodness. Can you create a video on how to share a power query report/dashboard with multiple connections.

@michaelcrosby7715 2 жыл бұрын

definitely a good pitch. about to check out the course now

@evandawson1037 2 жыл бұрын

You are a wonderful teacher

@DustinSchneider 4 жыл бұрын

One thing I would stress, and perhaps you mentioned it and I missed it, is that when creating additional picot tables from the same data you want to make copies of the pivot table itself and DO NOT go back and create a new one from the data model. Doing this has it work from the same data image and keeps the file running more smoothly. Creating another pivot table from the data model screen or the ribbon will conjure another data image even if it's from the same data set. Excel does NOT like database sized data sets and keeping the data from growing unnecessarily will also help keep it from crashing.

@LeilaGharani 4 жыл бұрын

Great tip, Dustin. Thank you for sharing!

@vivekananthradhakrishnan2339 2 жыл бұрын

Leila .. I ❤ u. Usually I follow all your free stuff. Today I was motivated to checkout your training course on power query . 99 Rs is good. 99 dollars isn't for me. Ofcourse you need to make money. However, you should consider differential pricing for different parts of the world

@imranali-iy5wk 3 жыл бұрын

I have a folder containing 19 Excel worksheets with each worksheet containing 16 sheets inside it. While the name of the excel files are different, the name of individual sheets inside them is same i.e. they start from "Sheet 1" and go till "Sheet 16". What I have to do is append each sheet at the end of the next one and continue the same to get a new excel file containing only one sheet. (In other words, sheet 1 from file two (say, B) will be appended at the end of sheet 1 from file one (say, A) and sheet 1 from file three (say, C) will be appended at the end of the above two files containing sheet 1 from files A and B, respectively and so on untill every file is added).

@netanelOnline 3 жыл бұрын

Im prepared to amazed every time I see you

@GwendolyndeAshboroughLady 2 жыл бұрын

Im going to your Tutorial and learning this new skill now !

@LeilaGharani 2 жыл бұрын

Great!

@jamesphillipdeguzman6495 3 жыл бұрын

I've subsribed and turned on all notifications after seeing this. Good stuff Leila! Thanks :)

@Quijanos1 2 жыл бұрын

Leila, You are amazing!!! Thank you so much for your remarkable instruction and sharing your mastery.

@LeilaGharani 2 жыл бұрын

You are so welcome!

@MrMalgoro 5 ай бұрын

Great videos Leila, thank you. Could you provide some guidance as to in what order does PowerQuery execute its queries. I developed a tool that has multiple queries, merges, appends, etc. The result of some queries depend on the execution of the previous one and so forth. The only way I have "sort of" managed to control this is by not allowing certain queries to execute with "Refresh All" but by making the them stand-alone queries and have the user refresh them at the appropriate time. Thanks again.