Linked Data Type has connection to online data source. The data is dynamic and refreshable. This information automatically changes and are updated in your excel worksheet. For example stocks and geography are two dynamic data that you can get from online data sources.

When the mouse is hovered on a province:

To add information such as Capital or population, you may click the information or use .capital or .population notation. B is Capital of the province. C and D columns are population of the province and its capital.

By refering to a cell, the available online information is shown.

Stocks are another Linked Data Type. This is one type loaded in Power Query.

After transforming data (removing redundunt characters, changing type, removing blank data, renaming, ...) we get a clean dataset which can be loaded from Power Query to Excel. The top five rows are:

When data is linked, you may add information from online database to excel.

Linked Data Type can be loaded in Power Query for more conveniet editing. For text columns (Provice and City), some adjustments are needed)