4.92
(12 Ratings)

Excel Power Query Beginner to Advance

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

पावर क्वेरी एक्सेल २०१०, 2013 और 2016 & Above version में है पर बहुत सारे लोग इसे ignore करते है, जब आपके पास लार्ज डाटा होता है और उसमे आप एक्सेल में फार्मूला इस्तेमाल करके सोलुशन निकालते हो तो ये थोड़ा काम्प्लेक्स भी हो जाता है और फाइल साइज heavy भी हो जाती है उसकी जगह आप पावर क्वेरी इस्तेमाल कीजिये जो आपको इन सारे परेशानी से दूर रखेगी |

पावर क्वेरी : Power query : will help you to refine raw data, इसका मतलब ये के आपके पास अगर टेक्स्ट फाइल, एक्सेस फाइल या फिर SQL SERVER से डाटा आता है और वो प्रोपर नहीं है तो उसे प्रॉपर करने का काम ये क्वेरी करती है, डाटा को अच्छेस से सॉर्ट फ़िल्टर या फिर क्लीन करके के अच्छे डाटा में कन्वर्ट करना इसमें आपको सीखने मिलेगा |अभी १२ वीडियोस अपलोड किये है आगे वीडियोस जल्द ही अपलोड होंगे और आपने कोर्स खरीद भी लिया तो आगे के वीडियो भी आपके लॉगिन में दिखाई देंगे |

जब डाटा एक्सेल के अंदर क्लीन करना मुश्किल लगता है तभी पावर क्वेरी एडिटर की जरुरत पड़ती है, जब डाटा पे काम आता है तो पावर क्वेरी तो आना चाहिए |

You will learn how we can refine data and Transform data, with the help of power query tools you can easily get large data into your required format, power query will save you time with doing simple stuff no need coding, no need to spend hours to solve problem, even no complicated formulas just few mouse click will help you to get solve your problem.

अगर आपको Excel का पूरा कोर्स करना है, तो आप इस पे क्लिक करके सिख शकते है |

Show More

What Will You Learn?

  • Power Query - Refine Data
  • Create Pivot table on Multiple Sheets
  • Create Pivot on Text File
  • Transform Data Dynamically
  • Merge 10000+ Table with 3 Clicks
  • Calculate Age with 1 Click
  • Date and Time Options
  • Convert Raw Data to Structured Data

Course Content

Excel Power Query Course Videos

  • 1 – Power Query – Introduction and Installation (Watch Free)
    06:43
  • 2 – Power Query – Create Connections with Excel Table (Watch Free)
    07:20
  • 3 – Power Query – Create Connections with Text file and Access Database (Watch Free)
    09:23
  • 4 – Power Query – Reconnect Data in Power Query (Watch Free)
    07:14
  • 5 – Power Query – Create Pivot table on Text file data
    07:31
  • 6 – Power Query – Merge Multiple sheets using M Language
    10:40
  • 7 – Power Query – Create Pivot table on Multiple Sheets
    04:27
  • 8 – Power Query – Close and Load to Explain – Home tab – Query Group
    07:32
  • 9 – Power Query – Home Tab – Manage Column and Rows Group
    11:05
  • 10 – Power Query – Home Tab – Split Column into rows and columns
    07:29
  • 11 – Power Query – Home Tab – Group by using Basic and Advance Option
    05:55
  • 12 – Power Query – Home Tab – Data type & Replace Values
    06:05
  • 13 – Power Query – Transform data Dynamically
    08:51
  • 14 – Power Query – Combine 1000+Tables with 1 Function
    07:11
  • 15 – Power Query – Alternate options of Vlookup inside Power query
    07:54
  • 16 – Power Query – Multiple columns lookup
    13:43
  • 17 – Power Query – Remove Weekends and Holidays
    10:27
  • 18 – Power Query – Calculate Age with simple Method
    04:48
  • 19 – Power Query – Calculate Task Timings
    05:00
  • 20 – Power Query – Add Column Date Options in Detail
    09:21
  • 21 – Power Query – Time and Duration Options in Details
    07:42
  • 22 – Power Query – Transform Raw Data – Real Job Query
    11:00
  • 23 – Power Query – Few clicks to get Trim, Propercase and Merge Data
    08:13
  • 24 – Power Query – Merge Workbooks and Create Pivot
    12:03
  • 25 – PowerQuery – Merge Workbooks with File Name as Column
    21:40
  • 26 – PowerQuery – Raw Data to Pivot
    13:07
  • 27 – Power Query – Merge Vs Append
    10:22
  • Ye Course me naye naye aur videos aate rahenge

Trial Paper Final Exam for Certificate

Student Ratings & Reviews

4.9
Total 12 Ratings
5
11 Ratings
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
AS
1 month ago
Very Well explained. Looking for videos with more examples. Try to create a module for Power BI as well covering this as well for better understanding.. Much appreciated for the efforts done
RG
5 months ago
awsome
PP
5 months ago
Great sir.
SS
6 months ago
Very good amezing course
S
6 months ago
Excellent course...!!!
AS
10 months ago
Very very help ful course
AP
12 months ago
Excellant explaination.
AC
1 year ago
Great Learning Thank you..
(Can you please Provide Cources On SQL, Power BI Also)..
SA
1 year ago
Wonderful course!! The concept was made understood in a very easy and simple language. Real life project was shared and worked on the same which was the best part of the course for me. That was just amazing!! Thanks a lot Mr. Satish Sir!!! Thanks a lot!!!!
MD
1 year ago
Indeed course was beneficial and helpful .
In short excellent.
ND
2 years ago
Very helpful for all student and employees proper working process completed here
AS
2 years ago
Meri company me sab data text file me hota hai aur us raw data pe mujhe reports banane the is course se meri bahut help ho gayi hai ji. Thank you so much.