office tech skill logo

FREE POWER QUERY COURSE

Log in
ENROLL NOW
office tech skill logo
ENROLL NOW

Power query Mastery Unleashed

Begin Your Free Power Query Mastery Journey

  • Boost Confidence
  • Practical, Hands on Learning
  • Enhance Efficiency
ENROLL NOW
C927 Image 2 01

UNLOCK YOUR LEARNING JOURNEY

Your Course Includes

Take your Power Query skills to the next level with our comprehensive and free video course, which covers everything from basic transformation to advanced data manipulation.

Power Query Basics

Grasp the essentials.

Power Query Starter Kit

Learn Power Query editor and data transformation.

Data Connection

Connect to various data souces.

Basic Transformation

Tackle basic transformations to reshape your data.

Organizing Data

Learn sorting and filtering techniques.

Text Transformation

Manipulate text data with ease.

Number Transformation

Perform numerical analysis.

Load Data

Export data in Excel.

Course Curriculum

1. Introduction to Power Query

Overview: Explore the foundations of Power Query, its uses, and its evolution over time.

Key Lessons:

  • Understanding the basics and significance of Power Query.
  • The historical development and various versions of Power Query.
  • Decision-making scenarios: Power Query vs. VBA vs. Excel for Data Transformation.
2. Power Query Starter Kit

Overview: Familiarize yourself with the Power Query Editor and learn key data transformation techniques.

Key Lessons:

  • Navigating and utilizing the Power Query Editor.
  • Understanding and applying ‘Transform’ vs. ‘Add Column’.
  • Managing data views and types, renaming, and deleting queries.
3. Data Connection

Overview: Gain proficiency in connecting a wide range of data sources.

Key Lessons:

  • Techniques for connecting tables, ranges, and various file types.
  • Extracting data from databases, web pages, JSON, and PDF files.
  • Collating data from different folders.
4. Basic Connection

Overview: Master the essentials of transforming columns and rows in your data.

Key Lessons:

  • Efficiently choosing, navigating, rearranging, and removing columns.
  • Strategies for row transformation: keeping and removing rows.
  • Selecting and auto-detecting data types, promoting/demoting headers.
  • Rename column, replace and fill values.
5. Organizing Data

Overview: Learn how to sort and filter data effectively to enhance your analysis.

Key Lessons:

  • Sorting data in single and multiple columns.
  • Advanced techniques for filtering data in Power Query.
6. Text Transformation

Overview: Discover various methods to manipulate and transform text data.

Key Lessons:

  • Splitting columns by delimiter, number of characters, or positions.
  • Formatting text data including case adjustments and cleaning.
  • Merging columns and extracting specific text data.
7. Number Transformation

Overview: Delve into statistical calculations and numerical operations for insightful data analysis.

Key Lessons:

  • Performing basic statistical calculations like sum, min, max, and average.
  • Standard calculations such as addition, subtraction, multiplication, and division.
  • Rounding numbers and understanding information.
8. Load Data

Overview: Focuses on efficiently exporting data to Excel

Key Lessons:

  • Close & Load.
  • Close & Load To.
ENROLL NOW

office tech skill

Your Instructor

Hello, I’m Mihir Kamdar. With ten years immersed in various industries, I excel in Power Query, a tool I’ve successfully leveraged in finance and manufacturing. My abilities extend beyond standard data tasks, emphasizing solving intricate problems with Power Query.


I am dedicated to disseminating this expertise through informative articles and digital courses, ensuring my instruction is straightforward, actionable, and rooted in practical applications. I aim to empower others to fully utilize Power Query in their careers.

YT Profile 800 x 800

Frequently Asked Questions

Still have question?

Contact us and we will answer you as soon as possible

GET IN TOUCH

or email us at [email protected]

How long is the course?

The course is self-paced. Typically, learners complete it in 2-3 hours, but you have the flexibility to learn at your own speed.

Do I need any prior experience with Power Query?

No prior experience is necessary. Our course is designed to guide beginners from the basics and gradually advance to more complex topics.

Is the course entirely free?

Absolutely! The entire course, including all video tutorials.

What will I be able to do after completing this course?

You’ll be proficient in Power Query basics, data connection, organizing data, text, number, and date & time transformation, equipping you with skills applicable in many professional roles.

Can I get support during the course?

Yes, we offer support for any queries or difficulties you might encounter. Feel free to reach out at [email protected].

Are there any certification or credentials upon completion?

While this course does not include formal certification, completing it will significantly boost your Power Query skills and confidence.

Can I access the course material after completion?

Yes, you have lifelong access to the course materials, so you can revisit them anytime.

Will I receive any files or resources to follow along with the course?

Yes, we provide downloadable files for each section of the course. These files are designed to help you practice and apply what you learn in real-time, enhancing your learning experience.