If you'd like to check out our brand new Automate with Power Query Course, here's the link: www.xelplus.com/course/power-query-recipes/ Over 3,000 people already signed up and started working through our automation recipes. If you've signed up already, THANK YOU 🙏
@mohammadtawhidulislam4459
Жыл бұрын
Already started without seeing any preview. Because it’s the Leila who never frustrated me.
@pl4195
Жыл бұрын
what are the differences between this course and the PQ begin to pro course?
@BrandonChoy-b9j
Жыл бұрын
Hi Leila, I have seen your videos and really enjoy them. Would like to learn more as my work involves analysing multiple excel sheets and use of pivot tables. My data comes in sheets with different headers as well as columns that have combinations of number and characters within the same column. I would like to automate and analyse these columns in number format. Which course should would you recommend that I attend: (1) Power pivot & Dax( beginner to pro) or (2) Power Query ? Thanks.
@higgs168
Жыл бұрын
@@pl4195 same question
@robmedinaXXI
Жыл бұрын
The addition of table names to the Quick Access Toolbar is a brilliant time-saver, enhancing workflow efficiency. The tip about not typing the dot in M functions until necessary is also very practical. Moreover, the use of slicers for user-friendly table filtering is a great touch. These tips are truly valuable!
@LeilaGharani
Жыл бұрын
Yay! Glad you like it
@MissPickles1980
Жыл бұрын
The table names QAT is a game-changer for me!
@duds_sn
Жыл бұрын
The "never type the dot" is mind-blowing. I use PQ every day in excel and PBI and I'm chocked that it's that simple to avoid that behavior! Thanks Leila!
@alperkins66
Жыл бұрын
Love the "no-dots" with M code, love the zoom up/down using Control-Shift&+ - and lastly love adding table name to the Quick Access Toolbar!! Thanks LG!!
@JJ_TheGreat
Жыл бұрын
Those tips are my 2 favorites of this video, too!
@DontCallMeScooterrr
10 ай бұрын
OMG. The zoom shortcut and the query copy & paste will make my life infinitely better. Thanks, Leila, you are the best!
@LeilaGharani
10 ай бұрын
Glad it was helpful!
@KhalidKhans55
Жыл бұрын
Wow! Leila, you are so genius! All these tools and tricks are to save time and work efficiently with less errors and great accuracy making you more proficient in front of your bosses.
@piggybankaccountant
Жыл бұрын
I really love the Quick Access Toolbar addon, even "outside" of power query, you cant "ALT + 1 (or 2 or 3)" any keyboard shortcut. Its so great. Good video!
@m.raedallulu4166
Жыл бұрын
No. 3 and No. 6 are life savers! and No. 10 is interesting one. Thank you so much.
@jeffreydheere4737
9 ай бұрын
I liked the Slicer function. I didn't even know about Power Query a couple days ago, now I'm assigned to learn all about it and how to use it in gathering our testing results.
@Manoo_Addu_Vlogs
Жыл бұрын
Thank you Leila for sharing these PQ tips... All these tips must be helpful for PQ users' productivity..
@biancawilkinson8757
Жыл бұрын
Table Names in the QAT literally just blew my mind. So good. Thank you!
@SystemsDeptKIOCL
Жыл бұрын
Tip no 5 is my favorite your tutorials are brilliant and they have helped me a lot in understanding the brilliant tools in excel. Thank you
@peterrender4716
3 күн бұрын
Thanks Leila. This is really helpful - as always. My favourite feature is the ability to copy queries directly into other models - I have been copying and pasting MCode in the advanced editor. I am trying to develop my power BI skills and wondered what you would recommend as the best approach - using Power Query and Power Pivot in Excel (and loading the files into Power BI) or importing the base or raw data from Excel, ETL in Power Query and data modelling in Power BI. Thanks again. Peter
@haydenn8210
Жыл бұрын
After extensive use of Power Query as an analyst in an SME that hasn't quite grown to needing a CRM and has disaggregated data, my 2 biggest efficiencies additional to what you've mentioned in this video have been: 1) Disabling "Enable background refresh" under query properties. When you have either many small or several large resource intense queries that you can't push further upstream (into SQL for example), this will force excel to execute the code in a single query at a time, drastically increasing refresh speed in my experience. It is also necessary to deselect this option if you want a MsgBox in VBA to appear AFTER the refresh has executed (really great feature for non savvy end users IMO). You'll also need to do this if you ever want to wrap a query refresh in a timer function in VBA to measure how long your queries take to refresh, which is great for the developer side of things. 2) Disabling M intellisense. Under Query Options > Global > Power Query Editor > Formula, there is the option to enable/disable M Intellisense. Having this enabled can be very handy when you're new to M code, but if you've been using it for a while, your projects are becoming larger and you find yourself manually editing the M code, this was an incredible timesave for me. Intellisense requires an insane amount of resources, so disabling it turned manually editing M code from borderline undoable to near instantaneous for me. Special mention: Ensure that you have fast data load enabled on BOTH individual queries AND under the Global > Data Load option. Global > Data Load will supersede individual queries, so if it's not enabled, your queries will still load slowly even if they individually have fast data load enabled.
@LeilaGharani
Жыл бұрын
These are great tips! Many thanks for sharing.
@abdelazizallam
Жыл бұрын
Hi Leila I learn so much from you and I love you simple way in teaching .. I like in this video trick of refresh setting that can make me auto refresh every specific time ..thanks
@jazzista1967
Жыл бұрын
Nice tricks. I knew a handful of those . on your tip # 3 ( It could be 3.1) if you type the first letters of the function for example Excel.Workbook you simpy type in EW , the function will appear. Same with Table.PromoteHeader you type TPH and the function shows in the formula Bar I use this a lot and it is a time saver. Regards
@farooqaulakh5482
Жыл бұрын
Dear Ms. Your lessons are really great. I have learnt so much from these lessons. I will be connected with you for learn more.
@JanetLee-g6d
Жыл бұрын
Love auto refresh when open. Thank you for all your tips sharing. Very very useful.
@ForeverMods
Жыл бұрын
Best teacher ever!! Been subbed for years. Thank you so much for sharing.
@pgcsec
Жыл бұрын
3, 7 and 10 - great to get to learn new ways to work with Power Query - thank you.
@freezendog7
Жыл бұрын
Hi Leila, #7 to keep an eye on things / quickly update table names. I'll start and use this quite a bit I think. Cheers. Pierre.
@pasztom84
11 ай бұрын
As always, great doze of useful knowledge. Every single tip is top. Thank you Leila
@ccroche
Жыл бұрын
Thanks for those tips! I already knew a few of them, but I still love them all!
@RichardJones73
Жыл бұрын
There I was only the other day wishing for a quicker way to start a new query from the code editor so that I can paste my template code. Thanks Leila 👍👍👍
@shirleymoreman6725
Жыл бұрын
I like #5 to sort column headers too. I wish we could have a feature that would allow us to select the sequence in this dropdown as well.
@Gorman-84
8 ай бұрын
You are such a sorceress. Get out of my mind. You are so in tune to what the average advanced user needs. It is amazing. I like #3 and #6 as well. I so look forward to all the videos you make. I am in the process of reengineering many of my "formula" spreadsheets. Thank you so much!🪄
@GeertDelmulle
Жыл бұрын
Some remarks: - I like that sorting columns trick and that implicit GoTo column trick as well. - Ha! I use the Table Name on the Excel QAT for the longest time, now. So, yes, great trick. - My current favorite is: the New Blank Query button on the Excel QAT (yes, exactly that). - if you first add a “(“ in your formula, you can use the dot w/o duplication issues. That’s how I do it. The intellisense is actually quite smart. I tend to wrap my argument and then write the function name, so the dot is no problem for me.
@LeilaGharani
Жыл бұрын
Always a pleasure reading your comments, Geert! Thanks for watching.
@tafmarasha
Жыл бұрын
Copy/Paste Query just changed my life! Thank you! 🙏🏾🙏🏾
@mattsnow2376
Жыл бұрын
Hi Leila, thanks for this video. I took advantage pf the the video to sign for your course. I just started it and in chapter 1 (module 1) talked about addressing some challenges dealing with messy pdf's which was really helpful to me. Great courses. Clear and good examples. Thanks again.
@chrism9037
Жыл бұрын
Thanks Leila! PQ is so amazing. I like #3 too
@LeilaGharani
Жыл бұрын
It really is. Thanks Chris!
@mkparker99
Жыл бұрын
Awesome! I love the ability to add to the QAT. I didn't know I could do that.
@naorshikyar7648
Жыл бұрын
Incredible! I think that copy queries from workbooks to others is so helpful, thank u🙏
@LeilaGharani
Жыл бұрын
You're so welcome!
@jerrydellasala7643
Жыл бұрын
Leila, great video as always! I'm on the Insider Beta version of 365. A month or two ago an update changed how the name of the table is made adding "Table_" to the beginning of the table name I already gave the Query with the intention of using it as the Table Name. Your tip about adding it to the QAT is great to help resolve that problem! I've sent feedback asking to either stop that behavior or add it as an option and maybe even allow the prefix to be able to be customized. I will give tables a SHORT prefix sometimes like when using table data in a Query to be able to easily distinguish Tables from Query Tables by prefixing Query tables with "tbl", but that's vastly different than imposing "Table_" on EVERY Query Table! Have you seen this "feature" yet? Do you like it? Thanks as always for a great video!
@shirleymoreman6725
Жыл бұрын
This "feature" now seems to be on general release and I agree - it's really annoying! Like you, if I want a prefix I usually add tbl rather than Table_ so I end up renaming every time. Leila's tip to add the table rename to the QAT is a great idea... but I really wish that this could be switched off!
@enocharthur4322
Жыл бұрын
Quick access toolbar and slicer were my favorite. Awesome video Leila. Keep them coming!!!
@andreashermle2716
Жыл бұрын
Leila, you are fantastic ... always coming up with things I haven't heard of yet
@LeilaGharani
Жыл бұрын
Thank you so much!
@RogerStocker
Жыл бұрын
Tip 8 I knew already and use it almost daily. for the rest I'm completely with you 3 & 6 are the most exiting ones.
@HarshilPatel497
Жыл бұрын
I usually do not like and comment on videos from years just keep on watching but..... certainly one of the best video i watched ever that deserve a like and a comment...
@LeilaGharani
Жыл бұрын
That's great to hear, thanks!
@davidunwin7868
Жыл бұрын
Adding Slicers is something I do a lot and I always forget which Table ribbon menu it's in. I'm adding it to my QAT - great idea!
@markandrow4010
Жыл бұрын
Thank you Leila , one of your best tutorial.
@LeilaGharani
Жыл бұрын
Glad you think so!
@TanteHela
11 ай бұрын
Another Leila "gem". My favorite is the do-not-dot (eye opener). Thank you, thank you, thank you. My personal favorite is to disable "Adjust Column width" as soon as PQ creates the table. Right mouse click in the table > Table > External Data Properties. As a result the columns-widths do not change every time the query refreshes.
@LeilaGharani
11 ай бұрын
Thanks for sharing!!
@leiterservices
Жыл бұрын
Thanks for the "Refresh when opening file" tip!!!
@iankr
Жыл бұрын
Many thanks, Leila. I wish you could resize the table name field to make it longer!
@thiagarajanneelamegam8640
Жыл бұрын
Always Awesome your teaching way. These 10 Shortcuts are very useful. Thanks Leila G
@LeilaGharani
Жыл бұрын
You're very welcome!
@GuillermoPalchik
Жыл бұрын
OMG! #3 was SO helpful! Thank you Leila! You rock!😎
@LeilaGharani
Жыл бұрын
Glad it was helpful!
@QcFrogMan
Жыл бұрын
Excellent video as always, especially for me a long time Excel user but newly converted to PQ. The #3 tip with the dot in M function is a LIFE SAVER!!! You can’t believe how annoying and counterintuitive I found it that I had to alway go back and delete the text I had just typed. Thank you, thank you, thank you!!!
@LeilaGharani
Жыл бұрын
Glad it was helpful!
@alterchannel2501
Жыл бұрын
To be honest I knew and use all of the tips and tricks shown except the one about omitting the dot. That for me is one of the most valuable things I've learned , thank you so much
@LeilaGharani
Жыл бұрын
Thanks for sharing!
@alterchannel2501
Жыл бұрын
@@LeilaGharani thank you so much for all your contents, i've learned so much from you
@carolinavisnadi
2 ай бұрын
Great tips!! I can't believe I didn't think about the ribbon buttons. It is great for end users. I used to have a tab with instructions how to refresh data manually.
@anjelarieder9924
10 ай бұрын
to be honest, I will use all of your tips! just made me a summary of all! thank you!
@LeilaGharani
10 ай бұрын
Perfect!
@mjbah
Жыл бұрын
Hi Leila. As always your videos are unbelievably helpful and resourceful. Nearly all are favourites. But Tip #1, Tip #3 and Tip #6 are the most gems you have revealed on this video. But Tip #3 is the top dog. I can't count how many times I have to edit an M code (which I believe will also be applicable when creating custom columns where you use M) after pressing a tab. Thanks again.
@Metzanine
Жыл бұрын
These tips are GOLD!
@jayashribordoloi305
Жыл бұрын
Thank you for sharing useful tips. My favorite tip is 8. This will make my life easy
@marcosahertian
5 ай бұрын
Hi Leila. I learnt to use PQ from your channel, and it has changed my life. Thanks for that. 1 question, is PQ in mac have all the features that found on Windows already?
@LeilaGharani
5 ай бұрын
Great to hear that! I'm not sure as I don't have a mac, but I do know that Microsoft is working hard to bring the features to mac.
@asmrindia
Жыл бұрын
Very Nice Mam Query Shortcut, Slicer and Copy & Paste are very useful features. Thanks 😊
@RichardJones73
Жыл бұрын
typing the dot caused me trigger issues so thank you Leila for curing me!
@FreakAzoiyd
Жыл бұрын
I used power query and Excel to create a dynamic PV tool to calculate PV energy yield with the help of PVGIS Web API, compare individuel yield years to electricity consumption to simulate own consumption rates, optional battery simulation, dynamicly chart it, generate presentation ready tables and graphics. Features 1 to 8 PV configurations in one calculation (like for different roofs). Just with new Excel features like spill and Power Query. It's super stable and in use since 2 years. What's really cool but quite complicated is wrapping code into functions. 🥰 Love how clean PowerQuery code can be produced, while most people's UI created code is a mess that breaks on minor disturbances 😅
@Quijanos1
Жыл бұрын
Thank you! Like always a clear explanation with an easy to follow. Example. As per your question, I thoroughly enjoyed how you displayed the slicer and made it look super easy. Have a great day but an even better weekend.
@eddywijaya2204
Жыл бұрын
Thanks for the tips Leila!
@Utubemop
Жыл бұрын
HI, my favourite was #9, not for the tip to add a slicer but for the fact that you can use the columns feature to bring the entries into one row...something I was looking for just earlier this week and could not resolve LOL 😂Thank you!
@JJ_TheGreat
Жыл бұрын
…But that’s not really at Power Query tip. That is more of a general Excel tip.
@Utubemop
Жыл бұрын
@@JJ_TheGreat ..yes...but still it was my favourite part when watching.
@Bourouwe
Жыл бұрын
Tip #8 is my favorite; thank you for all the tips!
@DingDongGrahamBell
Жыл бұрын
Love all Ten (10) of them! Thank YOU as always for the tips!
@imatzav
Жыл бұрын
#8: You can even paste into a text editor. What is pasted is the M code.
@shirleymoreman6725
Жыл бұрын
I do this all the time!
@LeilaGharani
Жыл бұрын
Thanks for the tip
@konstantinevseyenko9312
Жыл бұрын
I usually open two files in separate Excel instances and have to PQ editors. This allows me to copy queries between them more comfortable.
@elphau
Жыл бұрын
the best video i think i have to come replaying it everyday
@derekcapitaine8854
Жыл бұрын
#9 Slicers makes for a user-friendly table. Great tip. Thx.
@wallandbauf2678
Жыл бұрын
For sure yuo solved my issue with having functions with name duplicated by removing the dots..It was so annoying! Thank you!
@Henrik.Vestergaard
Жыл бұрын
1 and 6, nice, thanks. Used the rest allready.
@ahmedahmedgoma
Жыл бұрын
Thank you, the content is very helpful my favorite tip is to copy the query from file to file
@LeilaGharani
Жыл бұрын
Thank you for your feedback, Ahmed!
@karhukivi
Жыл бұрын
Thank you Leila! I still struggle with graphing in Excel, especially the x-axis settings. I'll have to focus on that again!
@MarcosAGazovic
7 ай бұрын
These features will have a big impact on my daily work. Thanks a lot. 🤓
@LeilaGharani
7 ай бұрын
Our pleasure!
@jayeshaw5705
Жыл бұрын
Amazing tips. You are a true master!
@englishwithabdullahsafi5034
9 ай бұрын
Thank you so much Leila!
@michaeldavenport9268
Жыл бұрын
Awesome 3 & 9 are my favorites! love these
@chh8860
Жыл бұрын
I still aspire to someday soar with eagles like Leila, ... but alas, today I am only a parakeet with great ambitions ... 😥 Favorite tips #9 & #10. Thank you ... thank you ... thank you ... 😍😍😍 PS Hot coffee with a slice of pound cake and a Leila video ... a wonderful way to start my Thursday.
@LeilaGharani
Жыл бұрын
Someone told me that ambition is the path to success. So, you're on the right track
@CassidyHood
8 ай бұрын
These are going to save me so much time! Thank you!!
@LeilaGharani
8 ай бұрын
You're so welcome!
@roywilson9580
Жыл бұрын
Cool video, the only one that was new to me was the alt F12 to bring up the Power Query Editor, you can also use the right click key and 'G' to do the same thing.
@adnanabbasi9482
Жыл бұрын
Another helpful video, bundle of thanks!
@gmsubu
3 ай бұрын
Very good compilation of useful tricks & techniques
@earthlingt8231
Жыл бұрын
Hi Leila, I love watching your videos, and have learned a great deal from you over the time. I work in consulting. Each day, I work on several projects and each with several tasks. I have been thinking of creating an integrated excel tool that would function as a time tracker for everyday (a timesheet); a to do list for everyday and a dashboard illustrating with a nice chart the various tasks I would have worked on in a given period (for example, budgeting, scheduling, communication, strategy, etc.). This tool would allow me to filter the chart results for any given time - it could be specific, weeks, or months. This could be used to show a summary of performance / work completed in a given period of time (for example, to a supervisor as part of performance review). I was thinking the graph would utilize the data from the time tracker, which would be filled in daily and perhaps archived into a separate sheet so that I have clean tracker for everyday (same would go for the to do list). Is there a cleaner and faster way to do this? It would be nice if you could kindly make a video on this. :) Many thanks in advance.
@godfreykariuki2473
Жыл бұрын
Tip#3! woooooW🤯You have no idea what you just did for me! My life is so much easier now... this till now was the most annoying piece in power query for me. Thanks a lot! Tip8 also. Very nice...
@LeilaGharani
Жыл бұрын
Happy to help, Godfrey!
@diegorestrepohincapie7762
Жыл бұрын
Hello, Leila! I've been following your channel for a while and I have to say you're an excellent teacher: I've learnt so much from your videos 😁 Though I'm new to Power Query, my favorite tips are #5, #6, #8 and #10. About tip #8, I have two questions: • Can I apply the same steps from a query to a different data source? I want to apply them to a website data that has the same structure than the original query. • And is there a way I can change that data source dinamically? Thank you very, VERY much for the knowledge you share with us!! 🤗
@peterlewis2255
Жыл бұрын
yes - copy across, then go to the "Source" line in the RH panel, click the gear icon, and you will have the option to edit to the new source,
@raffaelecamillo2690
22 күн бұрын
Hi Leila, your video is really helpful... I didn't know almost any of your tricks even though I've been using Power Query for a while... This convinced me to subscribe to your channel. Thanks for the great explanations, really clear!😀👋
@davidunwin7868
Жыл бұрын
I think your tip #6 just solved one problem I've been struggling with. I have one monthly data dump file that has a sheet for each date range of payroll data, so about 6-8 sheets. All the tables are the same format, but combining them all into a single table is a multi step process, creating connections to each table and then appending. But I think with tip#6 I can do it all in just a few clicks! 🤯
@dziadeck47
Жыл бұрын
So many good ones No.4 is a life saver when on multi-screen setup excel decides making tables xxxl is the way to go (really excel?) No 7 makes the housekeeping easier which is cool too
@Triet-n3s
7 ай бұрын
really like your 3th tips. Im still learning M so having an example for any function is awesome
@LeilaGharani
7 ай бұрын
Great to hear!
@DorothySolomona
Жыл бұрын
Love the tips. Have to practice it now. A bit fast though.
@CaseVance
Жыл бұрын
С удовольствием смотрю ваши ролики
@pablolazo977
Жыл бұрын
Tip9 was applied 2 mins after watching the video. Thanks!
@rpopecpa
Жыл бұрын
Hi Leila, Great video. I love tips #2, 3, 7 & 8!!
@LeilaGharani
Жыл бұрын
Thanks so much!
@canirmalchoudhary8173
Жыл бұрын
I like the "selecting folder" and "PQ launch shortcut"
@SiemionekTM
Жыл бұрын
Hi Leila, the best ones for me were the data pick up from the whole folder and copying the queries to other sheets
@LeilaGharani
Жыл бұрын
👍
@nazarenoman
Жыл бұрын
Hola. Son todos muy brillantes. Gracias.
@haydeecastillo4621
Жыл бұрын
I like the slicers filter for the table
@mostafaattia2476
11 ай бұрын
thank you so much Leila
@kristinalute6842
Жыл бұрын
I would love a tip on how to preserve case sensitivity when loading your query to a table! I need to keep each value in its original format, but the first format in the table takes over!
@Soulenergy31
Жыл бұрын
3:13 A good doctor does not come out of medical school but he/she come out from different clinics and hospitalization....... Loved this quote Leila!!!!!!!!!!!!!!!!!! Thanks for the inspiration
@rohitkarnani0506
Жыл бұрын
Tip 8 is savior, thank you so much:)
@meenatrainer
Жыл бұрын
Great video as always, all the tips are very informative 🙂
@davejl8982
Жыл бұрын
Yeah, that don't add the dot trick!! Omg..life saver. Annoyance of our lives!
@shielamontealegre8144
Жыл бұрын
Thanks Leila, very helpful tips. I really like Tip#6 and #10 and QAT. I tried also copying steps from one query to another query by copying the specific mcode of that step via Advance Editor 😊
@filip2585
Жыл бұрын
this copy querys is awesome :D I always do copy into notepad and than copy to new blank query
Пікірлер