How To Use Power Query | Introduction To Power Query | EP1 [Hindi]
Excel Tutorial
Learn More:- https://exceltutorial.net
============================================================
Previously In this Channel; 👉What If Analysis Part 3 :- https://www.youtube.com/watch?v=kln06yoYrJw 👉Data Table In Excel :- https://www.youtube.com/watch?v=ZbxU3dynRJo 👉Quick Analysis Tool :- https://www.youtube.com/watch?v=xxW7FQ_-9OY 👉Goal Seek In Excel : https://www.youtube.com/watch?v=fRD0HbPS8YU 👉Scenario Manager In Excel :- https://www.youtube.com/watch?v=m8hKqWnZbWo 👉 SUMPRODUCT Function in Excel :- https://www.youtube.com/watch?v=O_Nx0NBPaEI 👉 INDEX MATCH Vs VLOOKUP :- https://www.youtube.com/watch?v=m6wJmTLPxZY 👉 match fUNCTION - https://www.youtube.com/watch?v=P7931gLCNVU 👉 INDEX Function In Excel:- https://www.youtube.com/watch?v=SjbtNMDTe5Y ✔SUMIFS Function In Excel :- https://www.youtube.com/watch?v=asQhai96qTE 👉Exact Match Vs Approximate Match :- https://www.youtube.com/watch?v=ejcZVn49Z-c 👉NOW, TODAY, TIME Function In Excel :- https://www.youtube.com/watch?v=4SBULeQi7jU ✔ How to Count Words In Excel :- https://www.youtube.com/watch?v=s4fFnoHF1X8 👉Formula Auditing In Excel:- https://www.youtube.com/watch?v=48aAb9c3OUs 👉 CONVERT Function In Excel :- https://www.youtube.com/watch?v=tiVSr6wP1vs 👉Cover Any Excel Error With IFERROR Function :- https://www.youtube.com/watch?v=AtrspSmpFvI 👉Formula Based Conditional Formatting : https://www.youtube.com/watch?v=4SK-0V0UO-U ✔Merge And Center Across Selection : https://www.youtube.com/watch?v=EAdhP8N-KpE ✔How to Create Heatmaps In Excel: https://www.youtube.com/watch?v=ow2CJe5HGVY ✔Freeze Panes In Excel :- https://www.youtube.com/watch?v=_hj3BNREGcM ✔Formatting Cells In Excel - https://www.youtube.com/watch?v=Ro07XuUMsBY ✔Format Painter in Excel With Conditional Formatting - https://www.youtube.com/watch?v=HNOnpxpM46k ✔Advanced Filter In Excel:- https://www.youtube.com/watch?v=QuH7YnQ20NA ✔ Sort & Filter in Excel:- https://www.youtube.com/watch?v=xiulgk_CtfU ✔ VLookup Function in Excel Introduction:- https://www.youtube.com/watch?v=OKEb8A6RYNs ✔ Synchronous Scrolling In Excel:- https://www.youtube.com/watch?v=6LdLd9tJS6Y ✔ Import TXT Data to CSV/XLSX - https://www.youtube.com/watch?v=OUYUKv1HP9Y ✔ Extract Unique Values With Advance Filter:- https://www.youtube.com/watch?v=ZW-0gIDLtGY 👉 Create Drop Down List In Excel:- https://www.youtube.com/watch?v=xhE4XZjbaAA 👉 Remove Blanks In Excel:- https://www.youtube.com/watch?v=gwSVVbgfKUo 👉 Alt Key Shortcuts in Excel:- https://www.youtube.com/watch?v=6OkKe-eIQ14 👉 CTRL G In Excel - https://www.youtube.com/watch?v=KU7ZNFWaqNc 👉customize Quick Access Toolbar:- https://www.youtube.com/watch?v=ONC_dmV9XbI 👉Create a Custom Tab:- https://www.youtube.com/watch?v=kN0gnlwEelM 👉 Excel Navigation Shortcuts:- https://www.youtube.com/watch?v=9Ugh-oLv2DA 👉Customize Excel Footer Stats:- https://www.youtube.com/watch?v=c68VKmFx_6w 👉Flash Fill in Excel: https://www.youtube.com/watch?v=dtfXkmalQyM 👉Fix 6 Common Excel Errors You're Sick Of Seeing:- https://youtu.be/JjCC-4FKQCo 👉Get Email name from Email Address:- https://www.youtube.com/watch?v=5HUH7SeBDLY 👉Add Row Index In Power Query:- https://youtu.be/jbZTdpg7ZZc 👉Month Name and Number :- https://www.youtube.com/watch?v=WJexkRPo-SY 👉COUNTIF:- https://www.youtube.com/watch?v=gpYCgLqciuA 👉Rounddown:- https://www.youtube.com/watch?v=U13Ounbk4Jg 👉COUNT FUNCTIONS:- https://www.youtube.com/watch?v=NBPgxlFqg1E ========================================================='=== In this episode of Power Query, We will be learning about how to use power query and its just an introduction video where we will analyse our data and rechange using queries and connection. This way you can edit your data again nd again. follow the table of contents below for more;
Table Of Content: 00:00 Introduction 01:40 Power Query Using Range/Tables (Example 1) 03:40 Power Query Using TXT/CSV Files directly (Example 2) 16:00 Conclusion
Hope you get to know what we are trying to say, if you want to learn more please do subscribe to our channel and do buy our Excel Masterclass Course.
Disclaimer:- The Character/person in cover picture is for representation purpose only. ... https://www.youtube.com/watch?v=e24eqV5r5MQ
121404088 Bytes