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.
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.