NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

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:

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

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

Lifetime Access

Become a Power Query PRO
$ 29
  • 38 HD Videos
  • 2.2 Hours of Video
  • Lifetime Support

30 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 30-days of enrollment. No questions asked.

FOR ENQUIRY ABOUT POWER QUERY COURSE? CONTACT US:

[email protected]

US: +1 203-349-9909 / IN: +91-8080042523

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