Skill Course By Satish Dhawale

Menu
Login
  • Home
  • Courses
  • Power Query In Excel Pro Course

Power Query In Excel Pro Course

Clean, Transform and Summarize Microsoft Excel Data Quickly and effectively using PowerQuery
4.9 Rating
★★★★★ 5/5
  • 1391 Students Enrolled
  • Created By Satish Dhawale
  • In Hindi
  • 32 Lessons

₹499

₹1999

85% off

Enroll Now
Play Video

Course Description

Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.

In this course you will learn Excel power Query from Beginners to Advance. (Courses by Satish Dhawale Sir) सभी कोर्सेस आसान हिंदी भाषा में | Read More पे क्लिक करे और कोर्स के फीचर्स जानने के लिए |

Course Features
✅सभी कोर्सेस सरल हिंदी भाषा में
✅Power Query In Excel बेसिक से एडवांस कोर्सेस
✅25+ DETAIL वीडियोस
✅ कोर्स प्रैक्टिस फाइल्स उपलब्ध
✅कोर्स कम्पलीशन सर्टिफिकेट
✅इंस्टेंट एक्सेस –
⬇️ Download Video in APP

This course is Created by : Satish Dhawale
सतीश सर को कंप्यूटर के क्षेत्र में टीचिंग का लगभग 16 साल का अनुभव हैं जिसमे उन्होंने 14 साल तक ऑफलाइन कंप्यूटर संस्थान में 40000+ से अधिक स्टूडेंट्स को और अपने Online अपने Learn More Channel के माध्यम से लगभग 17,00,000+ से ज्यादा स्टूडेंट्स को कंप्युटर कि शिक्षा देने का कार्य किया हैं। YouTube : 7 Silver and 1 Gold Button Award Winner for their 7 YouTube Channels

Course Benefits

  • Introduction of Power Query in Excel
  • Features and uses of Power Query in Excel
  • Installation of Power Query
  • Creating connection with excel table
  • Creating connection with text file
  • Creating connection with access database
  • Create Pivot table on Text file data
  • Merge multiple sheets
  • Power Query - Refine Data
  • Create Pivot table on Multiple Sheets

Materials Included

  • 25+ Video tutorial
  • 5 Hours on demand duration
  • Real Job Problem scenario
  • Downloadable Practice file available
  • Course completion ISO certificate
  • WhatsApp and Call Support

Course Curriculum

Power Query : Module - 1

Preview

Play Video

01 - Introduction and Installation

Preview

Play Video

02 - Create Connections with Excel Table

Preview

Play Video

03 - Create Connections with Text file and Access Database

04 – Reconnect Data in Power Query 07:14 Min
05 – Create Pivot table on Text file data 07:31 Min

Power Query : Module - 2

01 – Merge Multiple sheets using M Language 10:40 Min
02 – Create Pivot table on Multiple Sheets 04:27 Min
03 – Close and Load to Explain Home tab Query Group 07:32 Min
04 – Home Tab – Manage Column and Rows Group 11:05 Min
05 – Home Tab – Split Column into rows and columns 07:29 Min
06 – Power Query – Home Tab – Group by using Basic and Advance Option 05:55 Min
07 – Home Tab – Data type & Replace Values 06:50 Min
08 – Transform data Dynamically 08:51 Min
09 – Combine 1000+Tables with 1 Function 07:11 Min
10 – Alter options of VLOOKUP inside Power query 07:54 Min
11 – Multiple columns lookup 13:43 Min

Power Query : Module - 3

01 – Remove Weekends and Holidays 10:27 Min
02 – Calculate Age with simple Method 04:48 Min
03 – Calculate Task Timings 05:00 Min
04 – Add Column Date Options in Detail 09:21 Min
05 – Time and Duration Options in Details 07:42 Min
06 – Transform Raw Data – Real Job Query 11:00 Min
07 – Few clicks to get Trim, Proper case and Merge Data 08:13 Min
08 – Merge Workbooks and Create Pivot 12:03 Min
09 – Merge Workbooks with File Name as Column 21:40 Min
10 – Raw Data to Pivot 13:07 Min
11 – Merge Vs Append 10:22 Min

Course Instructor

Satish Dhawale

Founder & CEO of CoursePe

Satish Dhawale has over 15 years of experience in the field of computer education, he has been promoting computer education through his blog www.learnmoreindia.in and YouTube channel Learn More with 1.5 M+ subscribers for more than 5 years now. 1 Gold Play and 5 Silver Play Awards have been awarded by YouTube. Learn More YouTube channel provides tutorials related to computer and technology in the Hindi language to Learn and improve your life. 

Course Completion Certificate

₹499

₹1999

85% off

Enroll Now

Course Rating By Summary

5.0
Rated 5.0 out of 5
5.0 out of 5 stars (based on 5 reviews)
Excellent100%
Very good0%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

​

Prasad Patil

Rated 5.0 out of 5
February 9, 2023

Great sir.

Prasad Patil
Verified

Sanjay Singh Sidar

Rated 5.0 out of 5
February 9, 2023

Very good amazing course

Sanjay Singh Sidar
Verified

Rohit Gupta

Rated 5.0 out of 5
February 9, 2023

awesome

Rohit Gupta
Verified

Praveen Pandey

Rated 5.0 out of 5
February 9, 2023

This is a wonderful course and upgrade my knowledge at optimum level & Thanks to Satish Sir

Praveen Pandey
Verified

Bhavin Goklani

Rated 5.0 out of 5
February 9, 2023

Explanied technical terms in Layman’s launguage

Bhavin Goklani
Verified

Send your doubt

“Please note: You will receive a reply from our team on your email ID within 24 to 48 hours.”