Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)

[@LeilaGharani]

Get access to the complete course about Excel Power Query here 👉 www.xelplus.com/course/excel-power-query/

[@onwedavid9124]

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.

[@LeilaGharani]

Glad to help!

[@razvantomsa]

Hi Leila, excellent solution to this! Really impressed! Extremely thankful for this video!

[@cdyard1]

Another "Wow!" video. THE video of all videos. Lots of hours of work to look at. Thanks once again.

[@LeilaGharani]

Thanks again, Claire!

[@LuisFernando-yd3mx]

You make things so clickable Leila. Thanks so much for your Excel videos.

[@MarwanAShareef]

You always perfect, big like to big teacher

[@mcd22630]

I've spent the last year in prayer for such a library.

[@LeilaGharani]

😁

[@NgwaCha-ahAssociates-NCA-ri2bb]

@@LeilaGharani Please how can i get hold of the excel sheet, list of free tutorials?

[@shaulbel3206]

Excellent, and very clear explanation. Helped me very much.

[@mohamedomarali1164]

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.

[@romulusmilea2747]

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.

[@djstone5518]

Never used a custom data type before. Great video as always. Many thanks!

[@NikVilluri]

Your channel deserves more subs. Highly underappreciated content.

[@LeilaGharani]

I appreciate that!

[@shaulbel3206]

Very good explanation. I succeeded to implement it for opening files on my local drive with a click. thank you.

[@DBO3671]

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.

[@LeilaGharani]

You're very welcome!

[@Mu00lia]

Just Speechless! You are awesome Leila

[@LeilaGharani]

Thank you! 😃

[@theRealDavidn]

Every day Leila drops a new video is a good day!! Best excel Sensei on the web!

[@LeilaGharani]

Wow, thank you!

[@rondoherty2806]

Unbelievable, fantastic, genius! Thank you so much.

[@LeilaGharani]

You're very welcome, Ron!

[@jimfitch]

Fabulous tip/workaround! Thanks, Leila!

[@gregorytaylor2749]

Thanks Lelia. You are both a genius and generous for sharing your knowledge!

[@gregorytaylor2749]

@Leila Gharani I suspect that this response is from a scammer

[@emmafeng55]

Another mind blowing video to me! Thank you Leila!

[@LeilaGharani]

You're so welcome!

[@timhaggerty7268]

The Full Tutorial List is amazing and so are you. Thank you so much

[@LeilaGharani]

You're very welcome, Tim!

[@JeffNeet]

So many powerful features in an easily digestible video. Wonderfully executed. 👏👏

[@goodtogo5612]

Namaste madam 🙏 you're doing great!

[@ArmandoReportes]

I kept asking myself:"why not just add a column with hyperlink in Excel and hide the original?" and loved the final result. Thanks.

[@davidferrick]

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!

[@LeilaGharani]

Great to hear, Dayve! It really is a cool feature.

[@stevensullivan9309]

That was awesome! Thanks for the tutorials and the lesson on Power Query

[@SimX9000]

Been trying to figure this out for months. Thank you so much, life-changing

[@LeilaGharani]

Happy to help!

[@DomingosCJM]

Excellent video!

[@ramakumarguntamadugu1299]

This is really a great video... Thank you very much!!!!

[@LeilaGharani]

You're very welcome!

[@vijayarjunwadkar]

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! 😊👍

[@LeilaGharani]

My pleasure! It really is a great addition.

[@Luciano_mp]

Good, cool trick. Thanks Leila!

[@akshaynm]

Excellent Tutorial. Many thanks Leila for sharing this with us.

[@LeilaGharani]

My pleasure!

[@antiquelady60]

Thank you! Thank you!

[@jerrydellasala7643]

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!

[@LeilaGharani]

Thanks for sharing, Jerry!

[@dhanicole]

This is insane-thank you for the tutorial!

[@LeilaGharani]

Glad you like it!

[@nelson_k_d]

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

[@LeilaGharani]

You'd have to use VBA for that.

[@MickyLion5527]

Love you sister you are amazing!! your bhai ❤️ from FP&A

[@HachiAdachi]

Niiiice! I would have never thought to use custom data types! Thanks, Leila!

[@LeilaGharani]

They're great!

[@arbazahmad7177]

Excellent !!!

[@RafaqatAli.91]

“AMAZING” Thumbs up again for another masterpiece !!!

[@OmidNejad-u6s]

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

[@andyid7440]

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.

[@eitancohen]

Thank you Leila, I ask that question at Udemy, so thank you for the video, exactly what I was looking for 😀

[@velocitypta]

heartthrobing teacher on youtube..

[@p0u1ka]

This is exactly what I've been looking for!

[@Trucpq]

It is exteemely helpful. You are great teacher.

[@LeilaGharani]

Thank you! 😃

[@beingdigitallearner3050]

You should a marketer. Brilliant way to get the traffic as well as learning :D

[@birgitjohannes6804]

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.

[@LeilaGharani]

Glad you enjoyed it, Birgit!

[@MrDhunpagla]

Wow... Great... It's really more than we expected... Thanks Leila

[@LeilaGharani]

Glad you liked it!

[@nitindeshmukh675]

Mam your style of speaking & voice is very sweet.

[@davidferrick]

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

[@ChrisSmith-kw4ps]

Thank you yet again for saving the day!! 💫

[@spaceman6581]

OMG your voice is so satisfying to hear

[@realpulsecoin]

So it is not possible without the new data types? Can`t we just type the hyperlink formula in the imported table from PQ?

[@adham20801]

You can ,.. you can even make it dynamic by using hyperlink formula for the whole column of the table using #colname as an array

[@realpulsecoin]

@@adham20801 Cool. I will have a go at it 👏

[@musallamdado7536]

🌺🌺 the best just like always

[@LeilaGharani]

Thank you! 😃

[@leerv.]

Wait Lelia wait. I'm on KZbin watching one of your wonderful Excel videos, that links to an Excel file that ... has KZbin 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!

[@786STATESMAN]

i like your videos

[@rajeshs839]

I like you so much for your contribution 👍👍👍👍👍 thanks ❤️

[@johnborg5419]

Thanks Leila. : ) : )

[@rosesmary]

Cool feature. I really want to know if people can think of other ways to use this.

[@AlexRuu]

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

[@santoshpv321]

I award you an Olympic gold medal for this tutorial.

[@LeilaGharani]

Thank you kindly :)

[@rolf7135]

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.

[@rihanshaikh2888]

thanks for the sharing and coming up with this idea, this will be very useful, outstanding

[@antoniogarrido3058]

Amazing gift....1000 Thanks Leila!! :)

[@LeilaGharani]

You're most welcome, Antonio!

[@nickkincanon4582]

Excellent!

[@barttitulaerexcelbart9400]

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

[@LeilaGharani]

Thanks Bart. The comment is a good idea. Here we can work with self referencing query. Matt Allington has a post one this.

[@barttitulaerexcelbart9400]

@@LeilaGharani exceleratorbi.com.au/self-referencing-tables-power-query/ Thanks I will try this...

[@chrism9037]

This is a great idea thanks Leila!

[@LeilaGharani]

Thanks for watching, Chris!

[@franciscomarron2220]

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!

[@GeertDelmulle]

This is a great Trick!! Thanks!

[@LeilaGharani]

Glad you liked it, Geert!

[@reddragon7081]

بهترینی

[@educationaltutorials324]

I like your videos more that anything on internet.

[@YouExcelTutorials]

This is awesome Leila! Thanks for always sharing useful tutorials 👍

[@LeilaGharani]

My pleasure 😊

[@cgam1416]

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

[@alexkim7270]

Gosh this is so cool to play on excel this way.

[@power2analytics72]

Thanks for the awesome video. Is there a way this data type works now across all excel files?

[@v.vivekthamilarasan990]

Great learning... You are always a top notch! 🎉

[@tifouraamina1761]

Oh really interesting 🤩 thank you, you're the best 👏👏👏

[@LeilaGharani]

Thank you! 😃

[@johnedwards7024]

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.

[@jmstyle9760]

amazing master Leila, shall join your class soon

[@LeilaGharani]

Always welcome!

[@wayneedmondson1065]

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

[@LeilaGharani]

Thank you so much for your ongoing support, Wayne!

[@LandscapeInMotion]

Really great tips!

[@LeilaGharani]

Glad you like them!

[@alonaisrael]

Big like 👍

[@LeilaGharani]

Big thanks 😊

[@willm7994]

Awesome 👏🏿

[@stephanephaneuf2462]

Damn! Thank you for being part of my life! (You don't even have to love me, it's free)

[@LeilaGharani]

😁

[@HanifTutorial]

👍👍

[@helendroza3833]

Thank you for this 🙏

[@LeilaGharani]

You’re welcome, Helen 😊

[@overhearification]

@Leila Does PowerBI also have the Custom Data Type function? I can't find it.

[@NathanJohnsonNaterspotaters]

Would using text-to-columns apply the hyperlinks?

[@ramanhai6205]

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

[@taizoondean689]

Thank you 👍

[@makisalimhussain2334]

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

[@vssuresh]

Awesome.. really it helps..

[@LeilaGharani]

Glad to hear that

[@Nk-lg2rz]

Leila.... Why do you look so much pretty

[@edersilvarodrigues]

Obrigado 👏👏👏👏👏👏👏

[@aaronlowrey7302]

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?

[@alotfy3000]

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 KZbin

[@hernanperez912]

Excelente

[@EricHartwigExcelConsulting]

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!

[@LeilaGharani]

Go for it, Eric!

[@baffourohene-kena4962]

You're so beautiful! I enjoy the way you simplify your lessons.