Microsoft is finally giving businesses what they really want: data types based on their own customer data.

Excel can also work with Power BI and richly structured data within spreadsheets. Microsoft shares context about data types in a new post.

You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.

Microsoft is bringing custom data types to Excel. Businesses and consumers will be able to import structured data into a single cell and reference it throughout a spreadsheet.

Try these two ways of analyzing and reporting QuickBooks Online data using Microsoft’s Power BI Desktop Version.