POWER QUERY TUTORIALS

Excel and Power BI – BOTH use Power Query to automate data fetching, data preparation, and reporting. No coding needed. Learn Power Query today to be updated.

This Course includes:

  • 2.2 Hours of On-Demand Video
  • 38 HD Video Lecture
  • Premium eBooks | Practice files
  • Lifetime Support & Access
  • Course Completion Certificate
Enroll Now
LEARN MORE
Nip_Fab_testimonial_page_1.png
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”

Course Curriculum

0101 Introduction to Power Query: What is it? How to access it?
0102 – Power Query User Interface – A Walkthrough
0103 – Power BI Nov 2009 Update
0104 – M-Query Basics – Reading Commands in Power Query Editor
0105 – Activate your “Applied Steps” Panel
0106 – Getting the List of all M-Query Commands
0107 – Importing Data (incl Use First Rows as Header)

Download Course Curriculum

0201 – Combine or Merge Multiple Files from a Folder
0202 – Importing Data from the Web
0203 – Merge Queries vs. Append Queries
0204 – JOIN Types for Beginners
0205 – Understanding JOIN Concept and its Types
0206 – JOINS in Action – Basic Example
0207 – Quick DOs and DONTs for Merge Queries
0208 – Merging Queries with more than 1 KeyID Column
0209 – Fuzzy Lookup

Download Course Curriculum

0301 – Using First Rows as Header
0302 – Cleaning Up Data with Case Change, TRIM, CLEAN
0303 – Working with Data Types
0304 – Fill Down Feature
0305 – Removing Duplicates and Blank Rows
0306 – Split Column – Part 1 (Delimiter & By Position)
0307 – Split Column – Part 2 (Digit vs Non-Digit)
0308 – Split Column – Part 3 (Split to Rows)
0309 – Rectify Date format using Data Type (Locale)
0310 – Working with Column From Examples feature
0311 – Adding a Conditional Column
0312 – Merge Columns (Concatenate)
0313 – Replace Values & Extract Characters

Download Course Curriculum

0401 – Unpivot Column – Cross Tab vs. Flat File
0402 – Group By – Basic to Advanced
0403 – Pivot Column – An Overview
0404 – Transpose

Download Course Curriculum

0501 – Find Top 3 Analysts

Download Course Curriculum

0601 – Copy Data from Power Query Tables
0602 – Column Profiling and Distribution
0603 – Duplicate and Rename Queries
0604 – Index Column

Download Course Curriculum

COURSE INSTRUCTOR

Rishabh Pugalia

Course Narrator

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

We’ve helped over 7,800 learners overcome their learning “plateau”...

Don’t take my word for it – check out this feedback from some of the professionals representing virtually every business domain, background and experience level…
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”
Peter Klugsberger - Yodalearning Student
Peter Klugsberger
Mckinsey & Company
“The courses are not only technically very knowledgeable, but also genuinely helpful for professionals who want to work smarter, not harder.”
Karnika Bhalla - Yoda Learning Student
Karnika Bhalla
Delloite
“The training curriculum and course was extremely well designed, thorough and catered to use cases relevant to our domain of work.”
Yoshika Chhabra
Yoshika Chhabra
E & Y
Read More Testimonials

Lifetime Access

Become a Power Query PRO
$ 29
  • 38 HD Videos
  • 2.2 Hours of Video
  • Lifetime Support
ENROLL NOW
Get started now!

Click here to make payment in INR

For a newcomer to online training, this program dispelled all my apprehension. Over the years, I learned about MS Office progressively at the workplace. But Yoda learning gave me an insight into Excel. Word and PowerPoint. I can do scores of my activities in a matter of few minutes instead of several man-days. Thank you, Yoda.
Nobinkumar Pradhan
Nobinkumar Pradhan
This course is full of hidden tricks, tools, tips, and amazing learning. The way of teaching of sir is beyond the traditional no confusion lies after you had listened to him carefully. I would like to recommend everyone excel learners go for a structured learning platform ie Yoda Learning Course Excel Ninja.
CA NIRMAL CHOUDHARY
CA NIRMAL CHOUDHARY
Great syllabus for real-life applications. Rishabh's videos and worked examples on file downloads make a huge difference to the learning experience. I have learned a lot through Yoda Learning which has sped up my work and created better presentations and analysis.
Adam
Adam
Previous
Next

14 days Money-back Guarantee

FAQ

DO YOU PROVIDE SUPPORT DURING THE COURSE?

We have a chat panel in every lecture window. You can take screenshots, upload file, and send queries to our support desk. QnA should be related to the case study files ONLY.

WHAT VERSION OF EXCEL DO YOU TEACH?

We use Excel 2013 and we have added all new features up to Office 365.

DO I GET A CERTIFICATE AT EACH LEVEL?

No, you do not get a Certificate at each level. We only provide the course completion certificate.

CAN I DOWNLOAD THE COURSE?

No. But, you can watch the videos unlimited number of times.

CAN I ACCESS THE COURSE FROM MORE THAN ONE COMPUTER?

Yes, you can access the course from only 2-3 devices (computer or mobiles) with your login credentials.

EXPLAIN THE REFUND POLICY.

You can ask for refund within 14-days of enrollment. No questions asked.

FOR ENQUIRY ABOUT POWER QUERY COURSE? CONTACT US:

[email protected]

IN: +91-7738922884

Feel free to call us for any query related to the course. Our support team will resolve your issue.