From the course: Excel Business Intelligence: Power Query

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Modify Excel workbook queries

Modify Excel workbook queries - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Query

Start my 1-month free trial

Modify Excel workbook queries

“

- [Instructor] I want to take a minute and just step back for a second, talk about modifying workbook queries. So throughout this section of the course, we've been adding all sorts of queries, loading all of the CSV files into our model, but I hadn't really taken a minute to step back and tell you what we need to do, if we ever need to edit or modify some of the queries we've already created. So it's very, very simple. All you need to do in the get and transform section is show your queries, which will populate that queries pane on the right side of your screen, and then from here, you can either right-click or hover over one of your queries, and it will allow you to either press edit and jump right back into the query editor, or you can even use some of those query editing tools right here in the menu, without going into the editor. Generally speaking, I'm pretty comfortable in the editor, so I like to go ahead and press the edit button and make my changes there, but it's up to you…

Contents