Mashallah You are absolutly doing great service to technology learners. Your channel is great place to build new much needed skills. I am sending you a massive thank you.
I love the date format you chose (d-mmm-yy), because the month is displayed with letters (Jan, Feb, Mar, etc.), rather than digits. This is excellent ! If you want to make it even better (actually, perfect), I would suggest to use "d-mmm-yyy", or "d-mmm-yyyy". It is the only date format I always use. I hope these help.
Wait Lelia wait. I'm on CZcams watching one of your wonderful Excel videos, that links to an Excel file that ... has CZcams videos in it. Are you trying to keep me busy with an infinite loop?! :P Ok but no really this is awesome! I've dabbled in C++ and that "X DOT Y" syntax makes me think of OOP classes, which I think is exactly what we are doing here!
You're awesome Leila! Not much I haven't tried in Excel, but then I watch your videos and keep learning new stuff each time. Thanks you so much for continuing to share your incredible knowledge.
Truly Amazing PQ Trick! This structured data type is surely going to unleash a lot of creativity and innovation for many! Thank you Leila for sharing this! Enjoyed it! 😊👍
Okay, after watching the full video this is one of the coolest features I've seen in a long time and you just helped me uber-enhance a report where I needed details in a card like format. Amazing as always!
Great tutorial on Data Types. Worth noting, I have hyperlinks turned off by default (Options -> Proofing -> AutoCorrect Options, Internet and network paths with hyperlinks: Unchecked), and was concerned that this wouldn't work without that being enabled. However, the HYPERLINK function does make the link clickable even with the option unchecked. In this case I do want them, but don't have to change the option. Thanks for yet another great video!
Hi Leila, I've been watching your videos regularly. Learnt a lot & implemented them in my work, it's been awesome. I have been challenged by a requirement at work: How can we append additional data (in a table), to the same source table using power query and load it back to the source table? Please create a video on the same. Presume I've not confused you!!😃
Thank you, shame Excel 2016 does not have this feature. What I like the most is that is the 1st time power query and excel functions can work together on instant refresh in the same table
Hello Leila. by far your channel is the best. I cannot do this on my exercise. Once I load the data on Excel, it doesn't give me the expansion option. Any advice pls?:)
Thank you for this tutorial! It illustrates an excellent way to keep your subscribers up to date with all the high quality videos! I wish more of course providers (Udemy, Datacamp, Coursera, O’reilly, SQLBi) could provide such TOC/metadata information about courses for their users. So the user easily could take notes and keep track of their favorite instruction videos and also implement spaced rrepetition for the more complex material.
I believe that Create a Data Type step is unnecessary. The reference to @[Link to Video] is valid without going through the bother of creating a card. If you move to a new column, and type equals "=" to begin a new function/formula, then click on a cell in the Link to Video column, the @[Link to Video] reference populates the function/formula. The function/formula can then be expanded upon in exactly the way you described, to include the HYPERLINK and friendly name portions. That works without creating any new data types.
How cool is that! Thank you for sharing this library and how to use the Data Type feature in Power Query. Great and super helpful as always😄,especially the trick to get the hyperlinks work.
Hi Leila! Thanks for helping me set up this video library! Will this video library be updated regularly? I noticed you have new content on your website, but I am not seeing the updates flow through to my video library. Thanks for all you do!
Leila, I really enjoyed this overview of Power Query. It is so nice to have the example to follow. I am wondering if you have a good example on how to mine data out of outlook. I saw the one video you did but I was looking to see how to mine the body of the email and pull out the information I need into separate columns. I am also taking your full course so perhaps there will be information in there that helps me. If you have a specific tutorial on mining information from the body of am email that would be great.
This is a super useful tool!! Thanks. This is a long list, so maybe it is useful to slice by tag/topic. But in some cells you have multiple tags, so how to select them individually by a slicer. Maybe split by delimmitter and put every tag on one row? Then you have many more rows, but I think this will definitively offset the advantage of making good selections. Other tip: it would be nice if the user could make remarks, for example, "good video, must see again..". But of course, after refresh this own remark should stay, and in the same row! Greetings Bart
Dear Leila, I am a great fan of your videos. just wanted to let you know that you have not updated the file you use in this video as an example or Power Query capabilities since september last year. I know that you have plenty of things and this file is certainly not your priority. But is a good reference (for me) to pick up the pointers of your videos and quickly share it with some colleagues I work with. Thanks for your contributions and knowledge sharing
Structured Column in not activated and also ”create data type ” button is missing. Tried to write the m code. But Table.CombineColumnsToRecord is not recognised. What to do?
Tried to follow along but my structured column does not look like that ( no drop down arrow and appears greyed out) what am I doing wrong or does my excel not have this feature)?
This is so helpful, but I am having trouble getting Excel to show the data type cards created in Power Query. It recognizes the built in ones like the stock tools. I have searched online and even repaired excel. Anyone have any recommendations?
Hi Leila. WOW!! This is so awesome! A very cool and clever use of Power Query and the new data types. Even better than that, it makes using your video and blog resources so much easier. Hope it drives more users to your site and courses. You deserve much success and please know of the endless appreciation for all that you offer and publish :)) Thumbs up!!
What a great video! I have been "dipping my toe" into this feature in power query but now I really want to go all in and see what all this feature can do! Thank you for the great video Leila!
Thanks Leila, it is such a good video. I tried to follow the video step by step, but I faced problem that "Structured Column" is greyed so I can't click on it!!!!
Get access to the complete course about Excel Power Query here 👉 www.xelplus.com/course/excel-power-query/
Very good explanation. I succeeded to implement it for opening files on my local drive with a click. thank you.
Hi Leila, excellent solution to this! Really impressed! Extremely thankful for this video!
Well, I've been trying to understand Power Query for Months and I get the hang on the basics to get me going in just 2 days.
Gracias.
Glad to help!
Excellent, and very clear explanation. Helped me very much.
You always perfect, big like to big teacher
Mashallah
You are absolutly doing great service to technology learners.
Your channel is great place to build new much needed skills.
I am sending you a massive thank you.
You make things so clickable Leila. Thanks so much for your Excel videos.
Another "Wow!" video. THE video of all videos. Lots of hours of work to look at. Thanks once again.
Thanks again, Claire!
I've spent the last year in prayer for such a library.
😁
@@LeilaGharani Please how can i get hold of the excel sheet, list of free tutorials?
Your channel deserves more subs. Highly underappreciated content.
I appreciate that!
I kept asking myself:"why not just add a column with hyperlink in Excel and hide the original?" and loved the final result. Thanks.
Unbelievable, fantastic, genius! Thank you so much.
You're very welcome, Ron!
I love the date format you chose (d-mmm-yy), because the month is displayed with letters (Jan, Feb, Mar, etc.), rather than digits. This is excellent ! If you want to make it even better (actually, perfect), I would suggest to use "d-mmm-yyy", or "d-mmm-yyyy". It is the only date format I always use. I hope these help.
Never used a custom data type before. Great video as always. Many thanks!
Wait Lelia wait. I'm on CZcams watching one of your wonderful Excel videos, that links to an Excel file that ... has CZcams videos in it. Are you trying to keep me busy with an infinite loop?! :P
Ok but no really this is awesome! I've dabbled in C++ and that "X DOT Y" syntax makes me think of OOP classes, which I think is exactly what we are doing here!
This is insane-thank you for the tutorial!
Glad you like it!
You're awesome Leila! Not much I haven't tried in Excel, but then I watch your videos and keep learning new stuff each time. Thanks you so much for continuing to share your incredible knowledge.
You're very welcome!
This is really a great video... Thank you very much!!!!
You're very welcome!
You should a marketer. Brilliant way to get the traffic as well as learning :D
Excellent Tutorial. Many thanks Leila for sharing this with us.
My pleasure!
Truly Amazing PQ Trick! This structured data type is surely going to unleash a lot of creativity and innovation for many! Thank you Leila for sharing this! Enjoyed it! 😊👍
My pleasure! It really is a great addition.
So many powerful features in an easily digestible video. Wonderfully executed. 👏👏
Thank you! Thank you!
Every day Leila drops a new video is a good day!! Best excel Sensei on the web!
Wow, thank you!
Okay, after watching the full video this is one of the coolest features I've seen in a long time and you just helped me uber-enhance a report where I needed details in a card like format. Amazing as always!
Great to hear, Dayve! It really is a cool feature.
Thanks Lelia. You are both a genius and generous for sharing your knowledge!
@Leila Gharani I suspect that this response is from a scammer
So it is not possible without the new data types? Can`t we just type the hyperlink formula in the imported table from PQ?
You can ,.. you can even make it dynamic by using hyperlink formula for the whole column of the table using #colname as an array
@@adham20801 Cool. I will have a go at it 👏
LOL, this video was great just because I did not know about the add prefix feature. All this time I was concatenating with a custom column. :)
The Full Tutorial List is amazing and so are you. Thank you so much
You're very welcome, Tim!
Love you sister you are amazing!!
your bhai ❤️ from FP&A
🌺🌺 the best just like always
Thank you! 😃
Damn! Thank you for being part of my life! (You don't even have to love me, it's free)
😁
Great tutorial on Data Types. Worth noting, I have hyperlinks turned off by default (Options -> Proofing -> AutoCorrect Options, Internet and network paths with hyperlinks: Unchecked), and was concerned that this wouldn't work without that being enabled. However, the HYPERLINK function does make the link clickable even with the option unchecked. In this case I do want them, but don't have to change the option.
Thanks for yet another great video!
Thanks for sharing, Jerry!
Thank you Leila, I ask that question at Udemy, so thank you for the video, exactly what I was looking for 😀
That was awesome! Thanks for the tutorials and the lesson on Power Query
Hi Leila, I've been watching your videos regularly.
Learnt a lot & implemented them in my work, it's been awesome.
I have been challenged by a requirement at work: How can we append additional data (in a table), to the same source table using power query and load it back to the source table?
Please create a video on the same.
Presume I've not confused you!!😃
You'd have to use VBA for that.
Been trying to figure this out for months. Thank you so much, life-changing
Happy to help!
Excellent !!!
Fabulous tip/workaround! Thanks, Leila!
I like you so much for your contribution 👍👍👍👍👍 thanks ❤️
Excellent video!
Thank you, shame Excel 2016 does not have this feature. What I like the most is that is the 1st time power query and excel functions can work together on instant refresh in the same table
Cool feature. I really want to know if people can think of other ways to use this.
Another mind blowing video to me! Thank you Leila!
You're so welcome!
thanks for the sharing and coming up with this idea, this will be very useful, outstanding
Hello Leila. by far your channel is the best.
I cannot do this on my exercise. Once I load the data on Excel, it doesn't give me the expansion option.
Any advice pls?:)
“AMAZING” Thumbs up again for another masterpiece !!!
Hi Leila . It's very useful to attach email body and details in an excel sheet for the reference after importing emails to excel table by pq
Awesome 👏🏿
THIS IS EXACTLY WHAT I NEEDED! THANK YOU! YOUR VIDEOS ARE EXTREMELY BENEFICIAL!
Glad it was helpful!
Thank you for this tutorial! It illustrates an excellent way to keep your subscribers up to date with all the high quality videos! I wish more of course providers (Udemy, Datacamp, Coursera, O’reilly, SQLBi) could provide such TOC/metadata information about courses for their users. So the user easily could take notes and keep track of their favorite instruction videos and also implement spaced rrepetition for the more complex material.
Thanks Leila. : ) : )
I believe that Create a Data Type step is unnecessary. The reference to @[Link to Video] is valid without going through the bother of creating a card. If you move to a new column, and type equals "=" to begin a new function/formula, then click on a cell in the Link to Video column, the @[Link to Video] reference populates the function/formula. The function/formula can then be expanded upon in exactly the way you described, to include the HYPERLINK and friendly name portions. That works without creating any new data types.
How cool is that! Thank you for sharing this library and how to use the Data Type feature in Power Query. Great and super helpful as always😄,especially the trick to get the hyperlinks work.
Glad you enjoyed it, Birgit!
Namaste madam 🙏 you're doing great!
Mam your style of speaking & voice is very sweet.
Hi Leila! Thanks for helping me set up this video library! Will this video library be updated regularly? I noticed you have new content on your website, but I am not seeing the updates flow through to my video library. Thanks for all you do!
Niiiice! I would have never thought to use custom data types! Thanks, Leila!
They're great!
It is exteemely helpful. You are great teacher.
Thank you! 😃
Leila, I really enjoyed this overview of Power Query. It is so nice to have the example to follow. I am wondering if you have a good example on how to mine data out of outlook. I saw the one video you did but I was looking to see how to mine the body of the email and pull out the information I need into separate columns. I am also taking your full course so perhaps there will be information in there that helps me. If you have a specific tutorial on mining information from the body of am email that would be great.
This is exactly what I've been looking for!
Thanks for the awesome video. Is there a way this data type works now across all excel files?
i like your videos
Leila.... Why do you look so much pretty
Good, cool trick. Thanks Leila!
This is a super useful tool!! Thanks. This is a long list, so maybe it is useful to slice by tag/topic. But in some cells you have multiple tags, so how to select them individually by a slicer. Maybe split by delimmitter and put every tag on one row? Then you have many more rows, but I think this will definitively offset the advantage of making good selections.
Other tip: it would be nice if the user could make remarks, for example, "good video, must see again..". But of course, after refresh this own remark should stay, and in the same row!
Greetings Bart
Thanks Bart. The comment is a good idea. Here we can work with self referencing query. Matt Allington has a post one this.
@@LeilaGharani exceleratorbi.com.au/self-referencing-tables-power-query/ Thanks I will try this...
I like your videos more that anything on internet.
Dear Leila, I am a great fan of your videos.
just wanted to let you know that you have not updated the file you use in this video as an example or Power Query capabilities since september last year.
I know that you have plenty of things and this file is certainly not your priority.
But is a good reference (for me) to pick up the pointers of your videos and quickly share it with some colleagues I work with.
Thanks for your contributions and knowledge sharing
heartthrobing teacher on youtube..
Just Speechless! You are awesome Leila
Thank you! 😃
Gosh this is so cool to play on excel this way.
Thank you yet again for saving the day!! 💫
OMG your voice is so satisfying to hear
Structured Column in not activated and also ”create data type ” button is missing. Tried to write the m code. But Table.CombineColumnsToRecord is not recognised. What to do?
Wow... Great... It's really more than we expected... Thanks Leila
Glad you liked it!
بهترینی
I award you an Olympic gold medal for this tutorial.
Thank you kindly :)
amazing master Leila, shall join your class soon
Always welcome!
@Leila Does PowerBI also have the Custom Data Type function? I can't find it.
Why don't add a column using hyperlink function to get the active link instead of using card column?
Tried to follow along but my structured column does not look like that ( no drop down arrow and appears greyed out) what am I doing wrong or does my excel not have this feature)?
Same issue. I researched and it looks like the Create Data Type was added last year. My work version is not yet updated.
👍👍
Hi , it is very useful information , and I want to ask if i can get copy of library excel file for all your videos in CZcams
Great learning... You are always a top notch! 🎉
This is so helpful, but I am having trouble getting Excel to show the data type cards created in Power Query. It recognizes the built in ones like the stock tools. I have searched online and even repaired excel. Anyone have any recommendations?
Hi Leila. WOW!! This is so awesome! A very cool and clever use of Power Query and the new data types. Even better than that, it makes using your video and blog resources so much easier. Hope it drives more users to your site and courses. You deserve much success and please know of the endless appreciation for all that you offer and publish :)) Thumbs up!!
Thank you so much for your ongoing support, Wayne!
Oh really interesting 🤩 thank you, you're the best 👏👏👏
Thank you! 😃
Obrigado 👏👏👏👏👏👏👏
Excellent!
You're so beautiful! I enjoy the way you simplify your lessons.
This is a great Trick!! Thanks!
Glad you liked it, Geert!
What a great video!
I have been "dipping my toe" into this feature in power query but now I really want to go all in and see what all this feature can do!
Thank you for the great video Leila!
Go for it, Eric!
Thanks Leila, it is such a good video. I tried to follow the video step by step, but I faced problem that "Structured Column" is greyed so I can't click on it!!!!
Thank you 👍
This is a great idea thanks Leila!
Thanks for watching, Chris!
Amazing gift....1000 Thanks Leila!! :)
You're most welcome, Antonio!
Thank you for this 🙏
You’re welcome, Helen 😊
Big like 👍
Big thanks 😊
This is awesome Leila! Thanks for always sharing useful tutorials 👍
My pleasure 😊