To edit a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. You may find the Queries & Connections pane is more …

You can open the Power Query Editor by selecting Launch Query Editor from the Get Data command in the Get & Transform Data group, but it also opens when you connect to a data …

The Power Query Editor provides a data query and shaping experience for Excel that you can use to reshape data from many data sources. To display the Power Query Editor window, import …

You can manage your queries either in the Queries pane of the Power Query Editor or on the Queries tab of the Queries & Connections pane in Excel. This is especially helpful if you have …

Sie können den Power-Query-Editor öffnen, indem Sie Abfrage-Editor starten aus dem Befehl Daten abrufen in der Gruppe Daten abrufen & transformieren wählen, aber er wird auch …

The Power Query Editor opens and displays all the files in the folder and any subfolders. To select the files you want, filter columns, such as Extension or Folder Path.

With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn …

This allows you to edit the data in the Power Query Editor before importing it into Excel. If you want to view the data on the Excel grid, select the Load button.

To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in …

使用 Power Query（在 Excel 中称为“获取和转换”），可以导入或连接到外部数据，然后 调整 该数据，例如删除列、更改数据类型或合并表以满足你的需求。