Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

XelplusVis

Leila Gharani

Advanced Excel tricks

Excel online course

Excel tips and tricks

Excel for analysts

Microsoft Excel tutorials

Microsoft Excel

Excel 2016

Excel 2013

Excel 2019

XelPlus

Microsoft 365

Excel 365

excel power query

power query

pq

power query hidden

power query tips

power query editor

Автор: Leila Gharani

Загружено: 15 июн. 2023 г.

Просмотров: 324 842 просмотра

Описание:

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

Ready to explore hidden features in Excel's Power Query Editor? Whether you're a seasoned pro or a budding enthusiast, these tips and tricks will transform your Power Query experience!

🔍 What's Inside:
▪️ Power Query Editor Shortcut: Learn the Alt + F12 shortcut to instantly access Power Query Editor from any workbook.
▪️ Quick Access Toolbar Customization: Customize the Power Query Quick Access Toolbar to include your most-used features for quicker access.
▪️ M-Function Typing Tip: Avoid typing errors in M functions with a simple trick.
▪️ Zoom-In/Out Shortcut: Use Ctrl + Shift and the plus/minus keys to zoom in and out in the Power Query Editor.
▪️ Automatic Column Header Sorting: Learn how to sort column headers automatically for better data organization.
▪️ Import Entire File Content: Discover how to import all data from a file, including future sheets, using the folder icon.
▪️ Add Table Name to Quick Access Toolbar in Excel: Make table renaming easier by adding the table name box to Excel's QAT.
▪️ Copy & Paste Queries Between Files: Effortlessly copy queries from one Excel file to another.
▪️ Add Slicers to Tables: Enhance table interactivity by adding slicers for user-friendly filtering.
▪️ Adjust Refresh Settings in Excel: Set your Power Query results to refresh automatically at specific intervals.

In this video we'll unlock some hidden gems in your Excel Power Query Editor that you had this WHOLE time. They are simple but they will make your work life a lot easier. Some are also hidden tips when you work with Excel power query results - such as updating query refresh times, adding slicers to tables and also making it easier to change table names in Excel.

00:00 Hidden features your Excel Power Query you had this whole time
00:22 Power Query Editor Excel Shortcut
01:14 Quick Access Toolbar in Power Query
02:27 New Course: Automate with Power Query from Leila
04:25 Properly Enter M-Functions in Power Query Editor
05:32 Zoom-in and out Shortcut Keys in PQ Editor
06:05 Automatically Sort Column Headers
06:48 Import Entire File Content in Power Query
08:01 Add Table Name to QAT-Bar in Excel
09:10 Copy & Paste Power Queries to Different Excel Files
10:01 Add Slicers to Tables
11:09 Adjust Refresh Settings in Excel
11:45 Wrap Up

🌍 My Online Courses ► https://www.xelplus.com/courses/

Read the blog post here: https://www.xelplus.com/power-query-1...

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / xelplus  

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #powerquery

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

You Won't Believe These Crazy PIVOT TABLE Hacks!

You Won't Believe These Crazy PIVOT TABLE Hacks!

Excel Time-Savers - 5 Hidden Features for Busy People

Excel Time-Savers - 5 Hidden Features for Busy People

7 Power Query Tricks You’ll Regret Not Knowing

7 Power Query Tricks You’ll Regret Not Knowing

7 Things You're Doing WRONG⚡in Excel

7 Things You're Doing WRONG⚡in Excel

10 Power Query tips EVERY user should know! | Excel Off The Grid

10 Power Query tips EVERY user should know! | Excel Off The Grid

Excel's NEW Checkboxes Are Incredibly Cool! Here's why

Excel's NEW Checkboxes Are Incredibly Cool! Here's why

Power Query - Avoid

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)

How to Merge Excel Files with Different Headers in Power Query | List.Accumulate

How to Merge Excel Files with Different Headers in Power Query | List.Accumulate

Power Query for Beginners: Transform Excel Data in Minutes  (2025 Tutorial Part I)

Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)

How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data

How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]