Part V: Understanding Power Pivot and Power Query
Selecting columns in your queries faster
When dealing with a large table with dozens of columns in the Query Editor, it can be a
pain to find and select the right columns to work with. You can avoid all that scrolling back
and forth by clicking the Choose Columns command on the Home tab of the Power Query
Editor.
The dialog box in Figure 41.4 will activate and show you all of the available columns
(including custom columns that you may have added). Here, you can easily find and select
the columns you need.
FIGURE 41.4
Use the Choose Columns command to find and select columns faster.
Renaming query steps
Each time you apply an action in the Query Editor, a new entry is made in the Query
Settings pane (shown in Figure 41.5). Query steps serve as a kind of audit trail for all the
actions you’ve taken on the data.
