Channel: Excel Campus - Jon

Category: Education

Tags: undo last actionpower query editoralt sequences for any buttonmicrosoft power queryamazing power query tips and trickshow to use power querypower biclose power query windowmicrosoft excelremove column(s)open filter drop-down menuexcelrename columnexcel power querypower query tutorialexcel campuspower query tipsselect all columnsquick access toolbar in the power query editormost useful power query tipsproductivity tips for power query

Description: In this video, you’ll discover 15 keyboard shortcuts to use in Power Query, including opening and closing the editor, deleting columns, navigating panes, undo, and more. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/powerquery/power-query-shortcuts 0:00 1. Open the Power Query Editor 1:49 2. Alt Sequences for Any Button 2:21 3. Quick Access toolbar in the Power Query Editor 2:46 4. Rename Column 3:08 5. Remove Column(s) 3:29 6. Undo Last Action 4:11 Free Excel Pro Tips Newsletter 4:31 7. Select All Columns 4:51 8. Select First or Last Column 5:10 9. Select Multiple Columns 6:05 10. Open Filter Drop-down Menu 6:56 Free Excel Training Webinar 7:41 11. Open Right-click Menus 8:39 12. Open Table Options Menu 9:19 13. Select Task Panes 10:28 14. Close Power Query Window 10:54 15. Close & Load Here's the link to register in the webinar: webinars.excelcampus.com/registration-blueprint Related Videos: Power Query Overview - Automate Data Tasks in Excel & Power BI: youtube.com/watch?v=vq9AgAtSvQg How to Combine Excel Tables or Worksheets with Power Query: youtube.com/watch?v=HcfKOusOJhA&t=74s How to Import PDF Files into Excel with Power Query: youtube.com/watch?v=C6vqy30PDnE #MsExcel #ExcelCampus