Power Query and Power Pivot for Excel
Free Intermediate course · 10 lessons · 3 weeks · Certificate on completion
Automate data cleaning and build data models inside Excel. Across 10 lessons you'll move from fundamentals to a portfolio-ready outcome — at your own pace, with quizzes after each lesson and a final exam to certify your mastery.
What you'll learn
- When formulas aren't enough
- Power Query editor
- Combining files
- Unpivoting and reshaping
- Merging queries
- Refreshable workflows
Skills you'll pick up
- When formulas aren't enough
- Power Query editor
- Combining files
- Unpivoting and reshaping
- Merging queries
- Refreshable workflows
Tools covered
- Power Query
- Real-world projects
- Quizzes
- Final exam
Course modules
Module 1: When formulas aren't enough
Module 1 of Power Query and Power Pivot for Excel. 3 lessons · 3h
Module 2: Unpivoting and reshaping
Module 2 of Power Query and Power Pivot for Excel. 3 lessons · 3h
Module 3: Power Pivot data models
Module 3 of Power Query and Power Pivot for Excel. 2 lessons · 2h
Module 4: PivotTables over models
Module 4 of Power Query and Power Pivot for Excel. 2 lessons · 2h
Lessons in this course
- When formulas aren't enough
- Power Query editor
- Combining files
- Unpivoting and reshaping
- Merging queries
- Refreshable workflows
- Power Pivot data models
- DAX measures in Excel
- PivotTables over models
- Sharing automated workbooks
Instructor
James Okafor — Data Platform Architect
James Okafor is a Data Platform Architect with years of hands-on experience teaching Power Query to thousands of learners worldwide.
Who this course is for
This intermediate course on Power Query suits self-directed learners, students and working professionals who want a structured path instead of scattered videos and articles. It assumes basic familiarity with the subject and focuses on applying it in practice.
How learning works on Learnera
- Each lesson follows the same clear structure: introduction, core concept, worked example and summary.
- A short quiz follows every lesson; you need at least 40% to mark the lesson complete and unlock the next one.
- After all lessons, a final exam checks your understanding of the whole course.
- Your progress, streak and certificate are saved to your free account, so you can learn at your own pace on any device.
- Lessons are written with AI assistance from a curated outline; always cross-check critical facts with official sources.
Certificate
Finish every lesson and pass the final exam to earn a free, verifiable Learnera certificate for Power Query and Power Pivot for Excel. It can be downloaded as a PDF and shared on LinkedIn.
Career outcomes
Median global salary $90,000 per year · median India salary ₹12,60,000 per year · 63,393 open roles worldwide
- Power Query Specialist
- Senior Power Query Lead
- Power Query Consultant
Frequently asked questions
Is the Power Query and Power Pivot for Excel course free?
Yes. Every Learnera course, including Power Query and Power Pivot for Excel, is completely free — lessons, quizzes, the final exam, and the certificate.
How long does Power Query and Power Pivot for Excel take?
10 lessons, typically completed in 3 weeks at a comfortable pace.
Do I get a certificate?
Yes — pass the final exam and you receive a free, verifiable certificate you can share on LinkedIn.