【环球网科技综合报道】7月23日消息，微软公司宣布网页版Excel完成重大功能升级，推出Power Query Refresh能力。该功能支持个人及企业用户直接通过 ...

You can directly run SQL queries on a database from Excel. The traditional method was to create a Macro and write a long Visual Basic code by using ADO connection to get connected with the source.

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

This month’s column shows how to clean and join data using Excel’s Power Query.

Not surprisingly, Microsoft itself uses this to provide Big Data services right within Excel – Excel is one of the primary clients to enable big data analytics on Microsoft platforms.