Power Query Keyboard Shortcuts Uncover HIDDEN Features!

0:00 Introduction
0:17 Opening the Query Editor
0:52 New Blank Query
1:18 Quick Access Toolbar
1:48 Query Editor Ribbon Tabs
2:18 Navigating the Query Editor
3:36 Selecting Columns
5:26 Navigating Menus
6:47 Zoom In/Out
7:11 Add Column by Example

[wayneedmondson]

Hi Mynda and Phil. Some great tips there! I love learning new keyboard shortcuts. Thanks and thumbs up!!

[chrism]

Excellent Mynda. For some reason I hadn’t thought of using the QAT. Thanks !

[benrogers]

Also:
1. Ctrl+[ or Ctrl+] = indent line of code (works with multiple lines and in formula bar)
2. ( or { or [ or " = enclose selected code in brackets/quotes (use shift key for chars that require it)
3. Alt+Click = create multiple cursors (to replace multiple column names or query step names in one go)
4. Ctrl+Shift+Space = show function arguments (must click inside function first)
5. Ctrl+Space = toggle function description when typing function name (intellisense)

[GrainneDuggan_Excel]

QAT inside PQ - who knew. Thanks Phil. Marvelous tips

[darrylmorgan]

Hi Mynda!Really Helpful Shortcut Tips From Phil...Thank You Both :):)

[IvanCortinas_ES]

Excellent tutorial Mynda. That's very useful. Thank you!!!

[GeertDelmulle]

I have the Launch PQ Editor in the first hot key position as well.
New Query is on the QAT inside PQ. Too bad though that the PQ-QAT cannot be reordered.
Nice video!

[SD-kojd]

Wow thanks a lot, really Helpful :) you are making my life much easier 🙏

[jazzista]

Great video... will set these shortcuts at, my QAT.

[Stenmark]

Hello Phil and thanks for these helpful tips!

Is there a shortcut or way to get to the last row when the data exceeds 1000 rows?

Best regards,

Ronnie

[TH-vwqn]

Professor Mynda, can you please do a video on rolling avg using pivot table? One for daily, 7 days, and monthly avg.

[rickgegenheimer]

How can you select Columns and quickly move them to another area within the table? ie. When I merge and add columns, I now want them adjacent to columns in the middle of the existing table for ease of reference. I know I can move them slowly across the table, I have 175 columns.

Any expedited method apart from modifying the mcode would be appreciated!

Thanks

[teoxengineer]

are there any additional shortcuts abour row operations? or loading / transfering data to excel?

[kerimerzurum]

Hi, file Im working with got around 15 000 rows, im using power query to import new data but it getting freezed 99% of the time and i dont want to copy&paste every time i got a new report to analyze (Im filtrering on the latest received to not include old data) please help me out

[Lavi]

I would like to know one thing before really getting into the power query.

1-) Let's say on sheet 1 I have my database that I basically copy paste from other excel and on sheet 2 i have some control formulas. As far as I understand with power query I can load the data on sheet one from other excels and editor will do everything I did on first sample to the others and combines them. But what i actually want is not combining the data only the editing part. Assume the data folder includes last 7 days excel but i only want the day I choose to be listed and be able to change it. Can I do that and will query going to do same adjustments i made for all of it?

2, can i use same query for multiple excel files? I couldn't find it. I want to use same data folder with the same adjustments i made on multiple different excels ( not sheets, different excels)

Please do reply if answers are yes i will be binge watching every excel video right now

[earthdigit]

So far these look like for PQ in Excel, maybe not PBI?