Home

/

Courses

/Mastering Power Query by CA Saran Kumar U

Mastering Power Query by CA Saran Kumar U

Learn with Saran Kumar U

24 modules

English

Access for 180 days

Transform Your Data Analysis Game with Power Query Mastery

Overview

This course is designed to help you become proficient in Power Query, a powerful data transformation tool in Microsoft Excel and Microsoft Power BI. You will learn how to clean, transform, and merge data from multiple sources with ease. Get ready to take your data analysis skills to the next level with Power Query!

Key Highlights

Learn advanced data transformation techniques

Master the art of cleaning and merging data

Boost your Excel data analysis skills

Learn M Formulas as a Pro!!

Automation Assignments

What you will learn

Enhanced Data Transformation Skills

Master advanced techniques for transforming data in Excel using Power Query.

Efficient Data Cleaning and Merging

Learn how to clean and merge data from various sources seamlessly.

Advanced Data Analysis Techniques

Take your data analysis skills to the next level by leveraging the power of Power Query.

Modules

Session 1 - Learning Path - Introduction to PQ

1 attachment

Preview

Session 1 - Working Files

Preview

Session 2 - More in-depth and first query

1 attachment

Session 2 - Working Files

Session 3 - In and Out of Query

1 attachment

Session 3 - Working Files

Session 4 - Around M Functions

1 attachment

Session 4 - Working Files

Session 5 - Analysis of M Functions, Excel.CurrentWorkbookFn

1 attachment

Session 5 - Working Files

Session 6 - Deepdive into Excel.CurrentWorkbook Fn

1 attachment

Session 6 - Working Files

Session 7 - Deepdive into Excel.Workbook Fn

1 attachment

Session 7 - Working Files

Session 8 - In-depth into List, Custom Functions etc

1 attachment

Session 8 - Working Files

Session 9 - Dyanmic Path, Files, Column Names etc.

1 attachment

Session 9 - Working Files

Session 10 - Append Multiple Folders, Sub Folders files

1 attachment

Session 10 - Working Files

Session 11 - Merge Queries in PQ, All Types of Join

1 attachment

Session 11 - Working Files

Session 12 - Fuzzy Matching, Merge with More Keys

1 attachment

Session 12 - Working Files

Session 13 - Pivot, Unpivot, Split, GroupBy

1 attachment

Session 13 - Working Files

Session 14 - Relative Size Factor, Merge within Query

1 attachment

Session 14 - Working Files

Session 15 - Case Study leveraging VBA, GPT and PQ

1 attachment

Session 15 - Working Files

Session 16 - Custom Functions in Excel and Power Query

1 attachment

Session 16 - Working Files

Session 17 - Connect Web Data and Google Form Data

1 attachment

Session 17 - Working Files

Session 18 - Case Study - Dealing with Consistent Headers

1 attachment

Session 18 - Working Files

Session 19 - Reconciliation of 2 Datasets - Leveraging AI for Comments

1 attachment

Session 19 - Working Files

Session 20 - Deep Dive into Custom Functions - Web Data Automation

1 attachment

Session 20 - Working Files

Session 21 - Automation of Currency Rate Extraction from Web

1 attachment

Session 21 - Working Files

Session 22 - Deep Dive into Pdf Data Import, Transform and Analysis

1 attachment

Session 22 - Working Files

Session 23 - Deep Dive into Meta and Connect to Mail Exchange

1 attachment

Session 23 - Working Files

Session 24 - Deep Dive into Connecting Tally to PQ

1 attachment

Session 24 - Working Files

FAQs

How can I enrol in a course?

Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.

Can I access the course materials on any device?

Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.

How can I access the course materials?

Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.

Can I interact with the instructor during the course?

Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.

How long I can access this course?

You can access the course for 6 months from the date of enrollment.

About the creator

About the creator

Learn with Saran Kumar U

Get access to high-quality content including courses, ebooks, webinars, memberships, exclusive members-only community and more.

Rate this Course

₹ 6999.00

×

Order ID:

This course is in your library

What are you waiting for? It’s time to start learning!

Illustration | Payment success

Share this course

https://undefined/courses/MasteringPowerQuery-66b06c01101d6149c1d487b8

or

×

Wait up!

We see you’re already enrolled in this course till Access for 180 days. Do you still wish to enroll again?

Illustration | Already enrolled in course