To return the transformed data to Excel, select Home > Close & Load. Provides additional options, such as opening the Advanced Query Editor. Provides advanced transformation options.Ĭalculates data from existing columns, such as the day of the week from a date or custom calculations. When finished, select to return the data to the worksheet. Use to preview your data and make transformations. The following table summarizes important features: Power Query has added a few steps for you. You can preview, change, and delete any steps. The Query Settings pane shows the transformation steps you have taken. As you add new tables, they are automatically listed here. The Product Sales table is listed last, then the World Cup Results table, and then the tables used earlier in the tutorial workbook. To display all query tables in the workbook from the Queries pane, select the arrow to the left of the preview pane. Position the cursor on the Excel table, Select Data > Get & Transform Data > From Table/Range.Įxcel opens the Power Query Editor with your data displayed in a preview pane. Notice that there are product categories and sales data worksheets. This makes it easy to experiment with the data without changing the data source. When you load the sales data into Power Query and apply some transformations, Power Query creates a new worksheet, but the original sales data worksheet stays the same.