Creating a basic power query
In the topics we have covered so far, you learned a lot about the Power Query interface and mastered a number of layout techniques and tips. We will now go through the steps to create a basic power query using an Excel data table from scratch.
First, you need to determine where your data is coming from. For this example, we are going to use the workbook called MattsWinery.xlsx
:
- Once you have opened the workbook, press Ctrl + T to launch the Create Table dialog box for the Excel data (alternatively, use the Table/Range icon in the Get & Transform group):
- Check that the range selected is the range that you need to use to transform your data.
- Just under the selected range, check that the My table has headers checkbox is selected so that Excel identifies the top row as the header row.
- Click on the OK button to change the worksheet data into a table and launch the Power Query window. The Power...