Home

/

Courses

/Consolidation of Datasets using Power Query in Excel

Consolidation of Datasets using Power Query in Excel

Learn with Saran Kumar U

8 modules

English

Certificate of completion

Access for 182 days

Streamline data consolidation using Power Query!

Overview

This course covers advanced techniques in Excel using Power Query to consolidate and clean datasets efficiently. You will learn how to merge, append, and transform data from multiple sources, saving time and avoiding errors in your analysis. The course also includes tips on automating workflows and troubleshooting common issues.

The following are the scenarios covered in this course.

  • XYZ Workbook --> ABC Worksheet --> All Datasets (Columns in Same Order)
  • ​XYZ Workbook --> 'N' Worksheets --> All Datasets (Columns in Same Order)
  • ​'N' Workbooks --> ABC Worksheet --> All Datasets (Columns in Same Order)
  • 'N' Workbooks --> 'N' Worksheets --> All Datasets (Columns in Same Order)
  • ​'N' Workbooks --> 'N' Worksheets --> All Datasets (Columns in Different Order)
  • ​'N' Folders --> 'N' Workbooks --> 'N' Worksheets --> All Datasets
  • ​'N' Folders --> 'N' Sub Folders --> 'N' Workbooks --> 'N' Worksheets --> All Datasets
  • ​PDF --> All Pages --> All Tables
  • 'N' PDFs --> All Pages --> All Tables
  • ​'N' Folders --> 'N' Sub Folders --> 'N' PDFs --> All Pages --> All Tables
  • ​'N' Folders --> 'N' Sub Folders --> 'N' CSV Files --> All Pages --> All Tables
  • Many more.

Key Highlights

Master Power Query for data consolidation

Merge and append datasets seamlessly

Automate workflows for data cleaning

Troubleshoot common data consolidation issues

What you will learn

Enhanced Data Consolidation

Learn advanced techniques to consolidate and clean datasets efficiently.

Automation Tips

Discover how to automate data cleaning workflows for increased productivity.

Troubleshooting Strategies

Master techniques to troubleshoot common data consolidation issues effectively.

Modules

Session 1 - Learning Path, Intro to Power Query, First Transformation in PQ etc.

1 attachment

Session 1 - Working Files

Session 2 - Rules of Power Query, Intro to M Functions etc.

1 attachment

Session 2 - Working Files

Session 3 - Consolidation of Data from the Same Workbook

1 attachment

Preview

Session 3 - Working Files

Preview

Session 4 - Consolidation of Data from Different Workbooks

1 attachment

Session 4 - Working Files

Session 5 - Consolidation of all files data from Folder

1 attachment

Session 5 - Working Files

Session 6 - Consolidation of all files from multiple folders of sub folders etc.

1 attachment

Session 6 - Working Files

Session 7 - Consolidation of Data from Web, CSV, PDF etc.

1 attachment

Session 7 - Working Files

Session 8 - Merge of Two Datasets using Excel Power Query (All Types of Join)

1 attachment

Session 8 - Working Files

Certification

When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.

Course Certificate

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?

The course you may access till 12 months from the date of enrollment of the course.

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

₹ 1999.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/Consolidation-of-Datasets-using-Power-Query-in-Excel-66e03c6875471f030c7f047c-66e03c6875471f030c7f047c

or

×

Wait up!

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

Illustration | Already enrolled in course