How to Create Custom Data Types 💼 in Excel 'Data Types' Menu (Intern vs manager vs Power BI)

Excel Data types allow you to bring in rich information such as linked data from external sources inside a single Microsoft Excel cell. You can insert images inside Excel cells. The new organizational data types sourced by Power BI change the game on how you're accessing company information. You can keep your master data in one place and have it accessed by specific people. This can be information on employees, products, customers and many more. This way you have ONE source of truth throughout the entire organization.

In this video I'll show you how you can use and create organizational data types.

00:00 Introducing Excel Organization Data types from Power BI
00:37 Access Rights Needed
01:15 How to Use Organization Data Types
04:16 Convert Data into Data Types
05:55 How to Create Organization Data Types
10:00 How to Manage Permissions
11:46 Wrap Up

🎬 LINKS to related videos:

🚩Let’s connect on social:

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 #powerbi

[chenying-jun]

This is the most clear tutorial of creating feature table I've seen from Youtube! Thanks!

[jawadahmadehssan]

Thank you Leila. Today I have built it and shared the data with HR. They were extremely happy to see the potential of their data.

[pmlind]

Leila is awesome. We use Excel at work & Ive learned so much from her.

[YvesAustin]

Absolutely amazing! I was able to discover this video from your Power BI course ( a must have!) Thank you.

[phiberoptik]

Outstanding explanation and presentation. Very useful across many organizational reporting requirements. Thanks for your efforts demonstrating the application and use of this functionality.

[marcelduonblonde]

Another amazing introducing. Thank you for these explanations!!

[itsattaullah]

It's Highly Helpful, Thanks for explaining

[jayeshsuthar]

Thanks Leila 😃 this one is an amazing feature by which I can impress my managers. Great video.

[DeployJeremy]

Brilliant video and explanation. Thank you!

[ahmedtareq]

This is great, I will implement it in my organization

[DavenneChua]

Not really gonna use this but amazed at how easy it is to understand... you're an excel wizard...

[GerhardHolzer]

Great to remember how this great feature can be used 😊

[steventezcan]

Thanks Leila! Great info, can you please make more videos on this? I can see this being used as a link to a master KPI database and pulling specific metrics at ad hoc.

[andybeux]

Never saw that suitcase before! Amazing video, like always!

[chh]

At the 11:47 mark Leila asks " So, what do you think? Do you see this being useful at your organization? ..."

Candidly, I'm not sure.

My 'simplistic' Application rule: I think of 'Excel' for numbers and 'Word' for letters, 'Power Point' for slides, Power BI for eye-popping illustrations etc. etc. etc. If presented with this assignment, I think I would default to 'Access' because I see a database as the solution, not a spreadsheet. Maybe for, an approved vendor list, or an approved parts list ... and located on SharePoint. But then again, maybe I learned something new this morning ... but have not realized it yet. Just one man's opinion ... 🤔.

Thank you again ... for an introduction to another topic/feature that I was totally unaware even existed.

[unnikrishnansanthosh]

thank you Leila for sharing this useful organization reporting structure

[officetricks]

Excel always confused, but you made it incredibly understandable.

[ashokganpathi]

Great tutorial. I had a follow up question on the topic. Do data type allow inheritance or hierarchy? eg. You have a user data type (name, ID, date of birth, department) with common fields and that can be inherited by an employee with more specific details (salary, grade etc), or a contractor for other different fields (vendor company, hourly rate)? Thank you!

[ExcelWithChris]

After all the updates I still only have the 4 original Data Types in my list. How do I get all the other available?

[meer]

really most informative first time I understand power bi more knowledge gain first time I watch you video pls why small video to make all public use. I am Mir taimur from Pakistan