Automate all your mundane repetitive data cleaning tasks.

A typical Excel report or dashboard goes through three essential phases.

  1. You get data from multiple sources, consolidate it, clean it (VLOOKUP, filter, add-delete columns or rows and a bunch of other mundane repetitive tasks.)
  2. Analyse it - Formulas, PivotTables
  3. Present it - Charts, Conditional Formatting, Sparklines, tables.


Nearly 80% of the time is consumed in performing repetitive data cleaning tasks.

And the worse part.. you've got to do this again tomorrow, next week, next month. In fact, each time you need to create the report.

Power Query converts these tasks into one click of a button. It is truly sensational.

Who is this course for?

  • If you spend countless hours cleaning and shaping data before it can be put to use, this course is a must for you.
  • Data Analysts, Finance, Accounts, HR and MIS / Operations Professionals can tremendously enhance their productivity through this course.


The course is split into two parts.

Part 1 - Fundamentals

These are short easy case studies to learn the most important features of Power Query from scratch.

Part 2 - Practical Case Studies

These are more advanced close to real-life case studies to apply learning from part 1 on how to automate your repetitive tasks.

"If you are looking to take your data analysis skills to the next level, this course will be worth every penny and minute of your time."

Course curriculum

  • 1

    Power Query Fundamentals

    • Introduction to the Power Query Course

    • Download the Practise Files

    • Getting Started & Becoming Familiar - Part 1

    • Getting Started & Becoming Familiar - Part 2

    • Combine Data from Multiple Excel Files - Same Structure

    • Combine Data from Multiple Excel Files - Uneven Data Structure - Part 1

    • Combine Data from Multiple Excel Files - Uneven Data Structure - Part 2

    • Combine Data from Multiple Excel Sheets - Part 1

    • Combine Data from Multiple Excel Sheets - Part 2

    • Loading Data from Web

    • Working with Dates in Power Query

    • Exercise - Clean this Data

    • Answer - Clean this Data

    • Errors & Things to be Cautious of in PQ

    • What is Unpivoting?

    • Answer - What is Unpivoting?

    • Grouping

    • The Reverse of Unpivoting - Pivoting

    • Joins in Power Query - Part 1

    • Joins in Power Query - Part 2

    • Application of Join - Vlookup in PQ

    • Application of Join - Dynamic Filter in PQ

    • Parameters and templates in Power BI

    • Cartesian Join

    • Scheduled Refreshes

    • M Code & Concepts - Part 1

    • M Code & Concepts - Part 2

  • 2

    Case Studies

    • Complex Date Transformations

    • Working with > Million Rows

    • Complex Unpivoting - 2 Headers

    • Very Complex Unpivoting and Combining Data - Part 1

    • Very Complex Unpivoting and Combining Data - Part 2

    • Combine Data from Multiple Excel Files - Advanced - Part 1

    • Combine Data from Multiple Excel Files - Advanced - Part 2

    • Refer to the Previous Row

    • Filtering Headers

    • Transpose Rows into Columns in Excel

    • Combine Duplicate Values into a Single Row

    • Repeat Row N Times

    • Unstack Rows to Columns

    • Unstack Uneven Rows to Separate Columns

    • Create a Dynamic Data Source Path - Part 1

    • Create a Dynamic Data Source Path - Part 2

Your Instructor

Chandeep is an Excel & Power BI trainer, consultant and blogger. He is the founder of the Goodly blog and YouTube channel.

He lives in Dubai, UAE and used to work as a Financial Analyst for an Investment Bank in Mumbai (India). Back in December 2013, he quit to start Goodly.

Being an Analyst, he became really good with Excel and now teaches Excel and Power BI around the world through online courses, Blog, YouTube and live corporate training programs.