Excel मे Power Query क्या है? What is Power Query in Excel In Hindi

Image: Unsplash.com By Satish Dhawale

What is Power Query in Excel In Hindi

[{"selector":"#anim-4aace5e4-be57-45ba-aa60-4368501707de [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-717e2ff7-2a07-4745-be20-d17bec0c95b2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b19f5054-1dfb-4753-b9d9-fc7923e3112e","keyframes":{"transform":["translate3d(0px, -637.13474%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b41447dc-1eef-484f-b0d4-f2181c0932dc","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Image: Unsplash.com

Excel मे Power Query का उपयोग क्यों करना चाहिए?

[{"selector":"#anim-ddfb2244-102a-41ef-b438-a4e333d68013 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-5c884d48-2451-4319-bfd5-8d427228cd2d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bab14c54-d4bb-4ca7-98ad-1f815d963d39","keyframes":{"transform":["translate3d(0px, -644.29644%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6918d2fc-9680-4b53-9aec-d41869012a45","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Image: Unsplash.com

Excel मे Power Query काम कैसे करता है?

[{"selector":"#anim-80e88382-2f27-420d-825b-b0490c4e40d1 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-4f8aea95-4b3d-46ba-8096-21bb7db9fb13","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4a54095c-b752-4327-8d03-f33ef4e7a6ab","keyframes":{"transform":["translate3d(0px, -644.29644%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3f1aeecc-9ceb-4bca-b632-55986579ec87","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Image: Unsplash.com

Excel मे Power Query कहाँ होता है?

[{"selector":"#anim-8e35759f-91d9-4c3b-aa84-6e8560351a22 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-36eb7571-ab99-4b09-a137-e37e977d2851","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8d1e6943-93b0-4e88-9a48-238d7e5515bb","keyframes":{"transform":["translate3d(0px, -644.29644%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-23564a02-cf1a-4975-8aa7-dfb43512eb5a","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Image: Unsplash.com

Power Query Editor in Excel In Hindi

[{"selector":"#anim-ead35e8b-0822-4e27-a8bf-0efaeb5f962f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-adff3816-672b-47fe-abae-58d615eb8165","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-da936d96-d52e-445a-a979-60b66a447c66","keyframes":{"transform":["translate3d(0px, -644.29644%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2fe6ae54-ba03-4778-8c8c-5bd5a898b84c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Power Query खोलने के लिए, आपको Data Tab पर जाना होगा और Get & Transform > Get Data > launch Power Query Editor में जाना होगा। जिसके बाद आपके कंप्युटर मे Power Query का Editor खुल जाएगा। Image: Unsplash.com

Excel Power Query Course in Hindi

[{"selector":"#anim-e436504b-4aab-4a84-963d-8aaedfe54d67 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-3e6410dd-a7fe-42cf-b848-f9d2ac6d515e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bcd11cf3-1211-4adc-b225-e8a7fe456a63","keyframes":{"transform":["translate3d(0px, -644.29644%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-703f348d-454b-47d9-892d-3707c63df873","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] पावर क्वेरी एक्सेल २०१०, 2013 और 2016 & Above version में है पर बहुत सारे लोग इसे ignore करते है, जब आपके पास लार्ज डाटा होता है और उसमे आप एक्सेल में फार्मूला इस्तेमाल करके सोलुशन निकालते हो तो ये थोड़ा काम्प्लेक्स भी हो जाता है Image: Unsplash.com

Excel मे Power Query क्या है? What is Power Query in Excel In Hindi

[{"selector":"#anim-774be308-52fe-448e-887a-ec83e94c595c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-11.655405457015213%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":5000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-c05cbee7-35ae-4cc5-85b6-543a03262902","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-78849c36-d098-496c-993e-8cc92e233490","keyframes":{"transform":["translate3d(108.19210%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

Excel मे Power Query क्या है? What is Power Query in Excel In Hindi

What is Power Query in Excel In Hindi

Power Query एक Excel Add-in (इक्सेल ऐड-इन) है, जिसका उपयोग आप ETL के लिए कर सकते हैं। ETL का मतलब Extract, Transform, Load है, जिसमे आप.

Read More

Excel मे Power Query का उपयोग क्यों करना चाहिए?

विभिन्न डेटा स्रोत (Different Data Sources): आप विभिन्न डेटा स्रोतों से Power Query Editor में डेटा लोड कर सकते हैं, जैसे, CSV, TXT, JSON, आदि।

Read More

Excel मे Power Query काम कैसे करता है?

Read More

Excel मे Power Query कहाँ होता है?

Read More

Power Query Editor in Excel In Hindi

Read More

Excel Power Query Course in Hindi

Read More

Excel मे Power Query क्या है? What is Power Query in Excel In Hindi