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

You can create your own free video library with Power Query Custom Data Types. You'll learn about Excel Power Query custom data types and how you can use this to optimize your Excel reports. Excel has a number of linked data types that you can use right away. But, you can also create your own data type from any supported data source by using Power Query. With this new feature, you can create custom data types and you can view the data in an Excel table, display it as an easy-to-read card, or use it in formulas. Power Query doesn't have a hyperlink data type, but you can create hyperlinks using data from Power Query by following the steps I show in the video. This way your Power Query results will be hyperlinked and clickable.

We'll use Power Query custom data types to create a free library of all my YouTube tutorials in Excel. I'll also show you a great trick in Power Query to return clickable hyperlinks with friendly names to Excel.

00:00 How to Use Power Query Custom Data Types
02:08 Create a Connection to a File From the Web
03:11 How to Fix Missing Hyperlinks in Power Query
05:34 Create Custom Data Types in Power Query
07:24 How to Expand Cards and Use in Excel Formula
08:35 Convert Links from Power Query to Hyperlinks
9:28 Updating Table after Website File is Updated
10:25 Wrap Up

🚩Let’s connect on social:

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

[onwedavid]

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.

[razvantomsa]

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

[LuisFernando-ydmx]

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

[mcd]

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

[shaulbel]

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

[djstone]

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

[shaulbel]

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

[romulusmilea]

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.

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

[cdyard]

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

[NikVilluri]

Your channel deserves more subs. Highly underappreciated content.

[MarwanAShareef]

You always perfect, big like to big teacher

[mohamedomarali]

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.

[theRealDavidn]

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

[JeffNeet]

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

[DBO]

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.

[jimfitch]

Fabulous tip/workaround! Thanks, Leila!

[stevensullivan]

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

[rondoherty]

Unbelievable, fantastic, genius! Thank you so much.

[gregorytaylor]

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