Get & Transform in Excel can help you search for data sources, make connections, and shape that data in ways you deem fit. For instance, you can remove a column, change a data type, or merge tables.

In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it ...