How Power Query Will Change the Way You Use Excel

Подписаться 2,6 млн

Просмотров 1,8 млн

50% 1

Get access to the full Power Query course here 👉 www.xelplus.com/course/excel-...
Struggling with repetitive or complicated tasks in Excel? Say hello to Power Query, your new best friend for automating and simplifying Excel work! Power Query is like an Instant Miracle Cure to your difficult data analysis problems.
🔍 Discover Power Query's Magic:
Import Data Easily: Fetch data from various sources, like other workbooks, text files, SharePoint, and even your Outlook emails.
Transform and Clean: Effortlessly shape your data. Split columns, compare datasets, and even calculate ages with a few clicks.
Efficient Data Loading: Load data directly to tables, pivot tables, or the data model for dynamic reports.
Here's the problem...
Excel Power Query has been a part of Excel since Excel 2016! It's in the Data tab under Get and Transform. Unfortunately many people haven't explored what it has to offer! They continue doing things the old "manual" way, Or the "complex" way with difficult formulas.
And something else you may not know ...
Generally, when you learn something, the more effort you put in, the more you get out. But it's NOT the same with learning Power Query! If you just put in a little effort, you get SO much in return! This is the difference with learning Power Query to learning other skills like VBA.
And that’s why I created this course!
To give you the tools to really make a difference at your workplace. I’m going to take you from Power Query Beginner to Pro!
Check out the full article: www.xelplus.com/excel-power-q...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #powerquery

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

21 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 1 тыс.

@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

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

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

@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.

@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!

@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!

@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!

@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 года назад

😁

@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☺️👍

@Craig.Coates Год назад

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

@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!

@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.

@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!

@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.

@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!

@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 🙂

@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!

@ngwafabrice9561 6 дней назад

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❤

@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!!

@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 3 года назад

@@rasoulkhoshravan5912 I followed the steps in the RU-vid video below (which also mentions 2013) - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gwW2CDdvUUs.html

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

@@mihirbandodkar9406 it can be used as an alternative

@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 :)

@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!

@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.

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

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.

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

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

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

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

@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

@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.

@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!

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

Best teacher ever in the whole of RU-vid. Examples were simple to understand.

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

😘

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

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

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

My pleasure :)

@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

@hanrealistic 9 месяцев назад

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

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

Very quick and easy been using lookups for checking 2 data tables. Now much simpler with power query. Thanks

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

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

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

😘

@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 9 месяцев назад

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

have been using this tool now for quite some time, once you are used to it is a joy to work with...

@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.

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

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

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

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

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

Thank you Leila! Just bought that course now. You convinced me! See you in the class.

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

Wonderful! Hope you'll enjoy it.

@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!

@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

@2_Bike_is_Life 4 года назад

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

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

😁

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

Leila, EXCELLENT! Thank you so very much. One question: I have a historical balance sheet, where: column F (2020), column G (2019), column H (2018)... column O (2010). In column E I have the percentages (divisions in column F (2020). The issue is that when I need to hide column F (2020), I need the divisions to happen in the column immediately after: column G (2019). Or, when I insert a new column between column E and F, I need the divisions to happen in the new column F, and not in the new column G. Do you know any way to do this? Thank you so very much. Kind regards.

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

Ok done sign up! I've been your watching a lot of your tutorial videos on youtube. So finally u managed to convinced me to sign up for this particular course! Lol.. Looking forward to learn more exciting tips and tricks from this course.

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

Great to hear! Hope you'll enjoy it.

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

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

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

Please give the link for the rticle

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

Ha! After all these long years with RU-vid 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!

@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 :)

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

It really was life changing when I first started using it. :) Its amazing very simple to use.

@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 3 года назад

@@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?

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

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

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

Haha. I hope the course will be helpful 😊

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

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

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

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

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

Glad you think so, Michael!

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

Hi Leila, I find your videos very knowledgeable and would like to make use, of what you teach. Can you use power query for boring data inputting workbooks or is it better to create a data entry form instead please? Im trying to clean up data in a Workbook that looks boring and requires alot of up and down scrolling. Please advice. Many thanks for your time.

@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 3 года назад

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 3 года назад

@@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

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

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

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

😂😂

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

Ihre Lehren sind sehr beeindruckend. Großartig!

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

At the end of the associated article you compare size of PQ file to formula equivalent. It would be interesting to see how much more space would be saved by using PQ to load the data into the Data Model so that data compression is applied. Granted, since this is a relatively small data set the compression saving would also be small.

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

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

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

Thanks Leila....Even in this intro video I have learned a few tips that I can add to me current PQ work flows. I can only imagine what I would learn if I subscribe to the full course.

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

Hope to see you inside the course, Matt!

@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!

@theHentySkeptic Год назад

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

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

Hi Leila, how are you today? Many Thanks for all your assistance making Excel learning journey much much much easier! Thank you. can point to me to which of your videosto learn about Chart able to react "dynamic" to a different search fill. Like 2 bedrooms chart dynamically change to 3 bedrooms when selected?

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

Hi, thanks for all your videos. Very helpful. When did the sepreate cells digit to non digit update come out? I cant see it in my version

@michaelcrosby7715 Год назад

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

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

Hi Leila, Is it possible to reference another query when constructing an IF statement in power query, similar to referencing different tables?

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

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

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

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

@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 :)

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

hi Leila, i have a csv file that when i load to power query it transforms all data into one column..😢 is there a way to make it recognize the columns from the csv?

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

Believe me that was the whole course to me. Thank you

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

Hi Leila, thanks for you videos. I have a simple question not related to this video though. I have a column of IDs (146 rows) and I want to randomly assign these to another column (about 50,000 rows). Please how do I go about it. Thanks in advance.

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

Hi Leila, this is great as always from you. Have not seen your courses available on linkedin learning. My firm and (many other organisations) i know have firm wide linkedin learning licenses, so it will be great to have your courses available on linkedin learning. Thanks

@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 RU-vid 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.

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

Thanks Leila.. glad to see the launch of your Power Query course. I already signed up on Udemy. Looking forward to the course. Thumbs up!!

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

Awesome, thank you!

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

You are amazing Guide when it comes to MS Office precisely Excel.

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

Hi Leila, Thanks for video. In most recent Excel version for data extraction from CSV to Excel file has eliminated the period location for the decimals. So all extracted number values now whole numbers and decimals merged into one. The old power query used to allow decimals. How do I fix this in the new version without manually changing values? It's a massive dataset. Thank you in advance!

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

Hi Leila. Your tutorial s are nice and easy to absorb. They are my ready reference. I am facing an error while doing power query with multiple WB. The error reads ' [Error.Expression] The key did not match any row in the table'. I am not able to get the resolution any where. Please guide to resolve the issue and understand the cause of error.

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

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

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

Thanks for sharing this Leila, once again an inspiring video from you. I think the flow on Power Query is the same as Transform feature in Power BI? I'm having considerations whether to use which one of them as my needs are the data more than 1 mio rows like excel limititation has.

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

you are great! i started use it recently and I totally agree.. it is incredibly more powerful and easy to get what i need

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

Great to hear!

@marcosahertian 6 месяцев назад

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

@LeilaGharani 6 месяцев назад

Wonderful!

@zp5808 10 месяцев назад

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 10 месяцев назад

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

@nirvab.1667 2 года назад

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

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

Hi Leila, Learned many things from your classes, one query I have, In excel Table how to delete multiple rows at once after filter, have tried but not being able to do. What I did selected the rows and pressed Alt +; and then Ctrl + - but it didn't work.

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

Is Power Query IntelliSense only available for the Insider Program? I seem to be on 365 ProPlus - Version 1808 (10730.20438 Click-to-Run) and don't have the highlighting.

@EmmanuelGidudu-k3t 2 года назад

i landed the right lesson for power query. thanks

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

An excellent tool. Thank you for the explanation.

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

Hi miss.i want ask you about data validation when i change data validation=USD and one row the same=USD but one row have to use sum.sorry i know weak english

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

Leila, I set up a hyperlink to send automatic emails from excel, is it possible to somehow go over de excel lillmit (WITHIN A SINGLE CELL) on how much I can write in them???

@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

@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!

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

Hey Leila thank your help although I am not able to find a video on how I can retrieve multiple data form other sheet using vlookup in google sheets.. can u plz share the link?

@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.

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

Do you offer any kind of support with this program such as emailing in a question if I don't understand something?

@carlo6195 Год назад

This will definitely help me with my new work. Thanks, Leila. :D

@mohammedhassan2808 Год назад

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