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.
** LINKS **
► LEARN POWER QUERY FOR 80% OFF THIS BLACK FRIDAY: https://www.excelcampus.com/power-query-pro-course-offer/
► Download the workbook: //www.excelcampus.com/powerquery/power-query-shortcuts
**********
EXCEL-FRIENDLY ACCESSORIES WE USE: LOGITECH KEYBOARD
Check out all the tech we use and recommend at https://www.excelcampus.com/store
**********
-- Learn 15 keyboard shortcuts to use in Power Query, including opening and closing the editor, deleting columns, navigating panes, undo, and more.
~ Related Videos ~
- Power Query Overview - Automate Data Tasks in Excel & Power BI: https://www.youtube.com/watch?v=vq9AgAtSvQg
- How to Combine Excel Tables or Worksheets with Power Query: https://www.youtube.com/watch?v=HcfKOusOJhA&t=96s
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: https://webinars.excelcampus.com/registration-blueprint
Related Videos:
Power Query Overview - Automate Data Tasks in Excel & Power BI: https://www.youtube.com/watch?v=vq9AgAtSvQg
How to Combine Excel Tables or Worksheets with Power Query: https://www.youtube.com/watch?v=HcfKOusOJhA&t=74s
How to Import PDF Files into Excel with Power Query: https://www.youtube.com/watch?v=C6vqy30PDnE
#MsExcel #ExcelCampus