Power Query In Excel Pro Course

Clean, Transform and Summarize Microsoft Excel Data Quickly and effectively using PowerQuery

4.9 Rating

★★★★★ 5/5

₹299

₹1999

85% off

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

01 - Introduction and Installation

Preview

02 - Create Connections with Excel Table

Preview

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

₹299

₹1999

85% off

Course Rating By Summary

5.0

5.0 out of 5 stars (based on 5 reviews)

Excellent100%

Very good0%

Average0%

Poor0%

Terrible0%

Submit Your Feedback

Prasad Patil

February 9, 2023

Great sir.

Prasad Patil

Sanjay Singh Sidar

February 9, 2023

Very good amazing course

Sanjay Singh Sidar

Rohit Gupta

February 9, 2023

awesome

Rohit Gupta

Praveen Pandey

February 9, 2023

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

Praveen Pandey

Bhavin Goklani

February 9, 2023

Explanied technical terms in Layman’s launguage

Bhavin Goklani