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

Amazing

Really good

Hi Leila, thanks for the video.

May be a silly question, but an organisation is not using PowerBi, can we still create data type directly in Excel?

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.

Love it

UAU

Will this still work if you upload the file to Sharepoint for users in the company? Will the custom Data Type "go with the file". I only want the Data Type for myself, use it in a report and upload the report to Sharepoint. Will they then be able to use it in only this file I have created?

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

Great to remember how this great feature can be used 😊

First of all Thank you. Can imagine how much research would be required to make such video. How many Power BI Pro licenses would be required. Is it just one user to publish or each user using that data.

Great video thanks. 2 questions is there a way to change a icon in excel for your created data type, and is there a way to disable showing an icon in excel cells?

Nice mam

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

The option : Data tab --> Data types is only present in Excel 365 or present also in excel 2016 desktop version ?
there is a little confusion . Please guide me if you can . Thank you .

I would really love to have data types for items that we use to build a project estimate consisting of items and assemblies where the item has a cost, cost, cost category, and several labor categories, labor units attached to it.

Hi Leila what if im using mac pro...do we have free downloader of power bi?

I love it

Instead of having image url, can you utilize this feature by linking to images saved locally on hard disk or on server?

Just great ❤

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

Very useful

سلام لیلا خانم
لطفا راجع به تقویم شمسی تو پاور ‌بی‌آی راهنمایی کنید

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

Home girl just pulled some sorcery🤯😵‍💫

You are amazing 🙏 thank you Leila

My baby love leila😍😍😍😍

Excellent Excel Videos. I have 40000 cells that I need to change to geography rich data type. Excel only allows a conversion of 100-200 cells at one time. Any way I can covert using a formula, power query or data model? Thanks

Excel always confused, but you made it incredibly understandable.

I want to know how to inserimagerscan in word 2013 like 2007 is there any helpful video please. Thanks in advance

how to extract unique value in column?
as all show row only

Can we use in Excel 2019 ?

Hi ,

Sub GoTo_Example1()

Application.Goto Reference:=Worksheets("Jan").Range("C5"),Scroll:=True

End Sub


This is VBA code which i use to go to a cell , but i want to use this code in VBA code for a automation tool , where the range value varies for every sheet. So for that , i have a range value in a cell , which i want to go, so can u please help me out , how the Above code should be used to take the range from a cell (which has range value, which changes from sheet to sheet). Thanks

It's Highly Helpful, Thanks for explaining

I think that this could be useful for property portfolios

Hey Leila Are you available for project work and/or can you recommend a good resource that might be? Need a consulting resource that can help create VBA logic to solve for recurring manual processes, and calculations that require multiple steps. Would need someone that can be available to review the datasets and requirements and can complete requests within agreed upon timeframes. Pay commensurate with skills.

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!

This is great! I am accountant with a firm. Do you have a video that intergrates QBO Accountant with Power BI Pro?

Hello Leila Thank u so much.can u help me in simple quistions please ?

Brilliant video and explanation. Thank you!

Which brand of laptop do you use?

Super 👌

Watching ED TECH PH

Thanks

Thank you 🙏

So my understanding is that PowerBI pulls the data from wherever - say SQL server. What happens if the original data is changed, for instance somebody gets a raise?

I dont have employee id & other option related to employee in Data meenu , how to get this option in my excel menu . plz suggest

thank you Leila for sharing this useful organization reporting structure

I'm trying to figure out if this would have been useful when I was tracking sustainability qualities of construction materials for green building rating systems. I no longer have that job, but we used Access as the database and that made it very difficult to update our Excel/VBA-deliverables-generating-tool as the rating systems that we were servicing evolved. Also, each product had too many attributes to be able to view one row in a spreadsheet, and Access was very clunky and made it difficult to view all of the data associated with one product. Would Power BI be appropriate for this scenario?

Thank you