Extract Data Based On Drop Down List in Excel using Power Query | Power Query | Jitendra Kumar
Extract Data Based On Drop Down List in Excel using Power Query | Power Query | Jitendra Kumar
In this video you will learn how to extract data from a table based on a drop down list selection in Excel using Power Query. No Excel function has been used here. No VBA coding has been don here. You can do it by using some button clicks using Power Query.
✅For more videos please subscribe our channel: https://youtube.com/c/PowerExbyJitendra
Download our practice file:
==============================
https://docs.google.com/spreadsheets/d/1CMgnWmq1KaeKomMA2o4gJFnSPgwVhTyh/edit?usp=sharing&ouid=110173023604601251691&rtpof=true&sd=true
==============================
Power Query Playlist:
https://www.youtube.com/playlist?list=PLBy4kMPmMt7Qp0F_gR5GLLYD5jBoNjv3b
Playlists of our top videos:
1. Stock Management System in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7QWl0YvOQumw4A730f36qAV
2. Advanced Excel Formulas
https://youtube.com/playlist?list=PLBy4kMPmMt7TI0y3zNNVYqc-y0JfFjwgg
3. Awesome MS Word Videos
https://youtube.com/playlist?list=PLBy4kMPmMt7SYFXHhY2tWTSL3uYG5dRG-
4. Conditional Formatting in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7Q8udcHSUO4va9eE_mL1aBL
5. Data Entry Form
https://youtube.com/playlist?list=PLBy4kMPmMt7TyCiEa2z_j2Hh3pCJrARjT
6. Custom Number Formatting Tricks
https://youtube.com/playlist?list=PLBy4kMPmMt7TJknWcSfKA17oiaRZDnI0H
7. Recent Uploads
https://youtube.com/playlist?list=PLBy4kMPmMt7RIG4EhjmidQOsB5uuLX5QF
8. Best Excel Shortcut Keys
https://youtube.com/playlist?list=PLBy4kMPmMt7Qpqc7rr8GrRYj70_m5Lulm
9. Power Query Tutorials
https://youtube.com/playlist?list=PLBy4kMPmMt7Qp0F_gR5GLLYD5jBoNjv3b
10. MIS Report in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7TTHMnzfqIP5vWeLKpK5nOY
11. Power BI for Beginners
https://www.youtube.com/playlist?list=PLBy4kMPmMt7QJGRCEG04HKDO36kDxUELl
------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#powerquery
#powerexbyjitendra
#excel
Subscribe on Telegram:
https://t.me/powerexbyjitendra
Contact Us:
Instagram: https://instagram.com/kumarjitendra11?igshid=zd7v216sfxr7
Facebook : https://www.facebook.com/PowerEx-by-Jitendra-108422660912839/
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks
Видео Extract Data Based On Drop Down List in Excel using Power Query | Power Query | Jitendra Kumar канала PowerEx by Jitendra
In this video you will learn how to extract data from a table based on a drop down list selection in Excel using Power Query. No Excel function has been used here. No VBA coding has been don here. You can do it by using some button clicks using Power Query.
✅For more videos please subscribe our channel: https://youtube.com/c/PowerExbyJitendra
Download our practice file:
==============================
https://docs.google.com/spreadsheets/d/1CMgnWmq1KaeKomMA2o4gJFnSPgwVhTyh/edit?usp=sharing&ouid=110173023604601251691&rtpof=true&sd=true
==============================
Power Query Playlist:
https://www.youtube.com/playlist?list=PLBy4kMPmMt7Qp0F_gR5GLLYD5jBoNjv3b
Playlists of our top videos:
1. Stock Management System in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7QWl0YvOQumw4A730f36qAV
2. Advanced Excel Formulas
https://youtube.com/playlist?list=PLBy4kMPmMt7TI0y3zNNVYqc-y0JfFjwgg
3. Awesome MS Word Videos
https://youtube.com/playlist?list=PLBy4kMPmMt7SYFXHhY2tWTSL3uYG5dRG-
4. Conditional Formatting in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7Q8udcHSUO4va9eE_mL1aBL
5. Data Entry Form
https://youtube.com/playlist?list=PLBy4kMPmMt7TyCiEa2z_j2Hh3pCJrARjT
6. Custom Number Formatting Tricks
https://youtube.com/playlist?list=PLBy4kMPmMt7TJknWcSfKA17oiaRZDnI0H
7. Recent Uploads
https://youtube.com/playlist?list=PLBy4kMPmMt7RIG4EhjmidQOsB5uuLX5QF
8. Best Excel Shortcut Keys
https://youtube.com/playlist?list=PLBy4kMPmMt7Qpqc7rr8GrRYj70_m5Lulm
9. Power Query Tutorials
https://youtube.com/playlist?list=PLBy4kMPmMt7Qp0F_gR5GLLYD5jBoNjv3b
10. MIS Report in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7TTHMnzfqIP5vWeLKpK5nOY
11. Power BI for Beginners
https://www.youtube.com/playlist?list=PLBy4kMPmMt7QJGRCEG04HKDO36kDxUELl
------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#powerquery
#powerexbyjitendra
#excel
Subscribe on Telegram:
https://t.me/powerexbyjitendra
Contact Us:
Instagram: https://instagram.com/kumarjitendra11?igshid=zd7v216sfxr7
Facebook : https://www.facebook.com/PowerEx-by-Jitendra-108422660912839/
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks
Видео Extract Data Based On Drop Down List in Excel using Power Query | Power Query | Jitendra Kumar канала PowerEx by Jitendra
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Replace Values and Errors in Power Query in Excel](https://i.ytimg.com/vi/zE1SG7B6H08/default.jpg)
![How to Convert Conditionally Formatted Cells to Shapes in Excel | Conditional Formatting to Shapes](https://i.ytimg.com/vi/PGg2E36ji2U/default.jpg)
![How to use Find and Search Function in Excel](https://i.ytimg.com/vi/_05xlWZRCuA/default.jpg)
![Text Functions in Power Query | Advanced Excel Power Query Tutorial in Hindi](https://i.ytimg.com/vi/QbjSTVRZINk/default.jpg)
![How to use Goal Seek in Excel (Hindi) | Goal Seek in Microsoft Excel | Jitendra Kumar](https://i.ytimg.com/vi/RUytVPn9i-o/default.jpg)
![Custom Number Formatting in Excel | Trick 3 | Hide or Replace Zero Values](https://i.ytimg.com/vi/bap32kLpIdQ/default.jpg)
![Highlight Alternate Rows using Conditional Formatting in Excel](https://i.ytimg.com/vi/YRw6MCgBRYU/default.jpg)
![How to Use VLOOKUP Approximate Match | Excel VLOOKUP Function](https://i.ytimg.com/vi/DEaKScs2zMo/default.jpg)
![How to use Forecast Function in Excel (Hindi)](https://i.ytimg.com/vi/QamkJQC0AYY/default.jpg)
![How to Download, Install Power BI Desktop Free | Upgrade Features in Power BI | Power BI Tutorial](https://i.ytimg.com/vi/-1jGFYsdYag/default.jpg)
![How to Create an Amazing To Do List in Excel | Jitendra Kumar](https://i.ytimg.com/vi/BiQ-KXgPNo8/default.jpg)
![VLOOKUP Interview Question solved | Excel Job Interview Question](https://i.ytimg.com/vi/UhVsr3J0CMk/default.jpg)
![How to Split Columns in Power Query in Excel](https://i.ytimg.com/vi/do-FwU_Mpos/default.jpg)
![How to Insert and Filter Picture in Excel](https://i.ytimg.com/vi/AkChRw6mZwg/default.jpg)
![Aging Analysis Report in Excel | Aging Analysis of Accounts Receivable](https://i.ytimg.com/vi/r23ILQau0Kc/default.jpg)
![Custom Number Formatting in Excel | Trick-1](https://i.ytimg.com/vi/0O8SukGUXwE/default.jpg)
![Custom Number Formatting in Excel | Trick 5 | Show Negative Numbers in Red Color](https://i.ytimg.com/vi/XBhKHrvX3Vo/default.jpg)
![Fully Automatic Student Report Card in Excel | Student Result Card in Excel](https://i.ytimg.com/vi/wvcxlQyv9O8/default.jpg)
![3 Best Ways to Transpose Excel Data Vertical to Horizontal | Hindi](https://i.ytimg.com/vi/4OdUR0whx-4/default.jpg)
![How to create a Column Chart in Power BI | Power BI Tutorials for Beginners | By Jitendra Kumar](https://i.ytimg.com/vi/r4rIscZMbao/default.jpg)
![How to use Vlookup with Subtotal Function in Excel | Vlookup with Subtotal Function in Excel](https://i.ytimg.com/vi/3lqmhKnHYjM/default.jpg)