Skip to main content

Introduction to Power Query in Excel

Explore Excel Power Query for advanced data transformation and cleansing to boost your decision-making and analysis.

Start Course for Free
3 Hours9 Videos27 Exercises

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies


Course Description

Embark on a transformative journey through Excel Power Query, where data manipulation becomes an art. Designed for novices and experts alike, this course unlocks new efficiencies in data handling, leaving behind time-consuming manual processes. Discover the power to connect with varied data sources, streamline your datasets, and ready them for insightful analysis. Excel Power Query's suite of tools awaits to elevate your reporting and decision-making prowess, saving time and revealing valuable insights from your data.

Discovering Power Query in Excel

Begin with a comprehensive overview of Power Query, transforming Excel into a potent data analysis tool. Learn to import and systematically organize data with intuitive commands, tracking each step with precision. This foundational knowledge sets the stage for sophisticated data manipulation within the familiar Excel workspace.

Cleansing Data for Clarity

Dive into Power Query's cleaning features to produce immaculate datasets. Tackle errors, fill gaps in data, and eradicate duplicates. This chapter hones your skills in data refinement, ensuring your dataset's integrity and priming it for complex analysis.

The Art of Data Transformation

Conclude with a deep dive into data transformation techniques. Master the essentials of column transformations, including numerical, date/time, and text adjustments, leveraging Power Query's built-in functions. Experience advanced structuring methods like transposing, pivoting, and grouping, and learn to interlink queries for a comprehensive analytical narrative.

This condensed course promises a hands-on approach to mastering data efficiency and insight extraction with Excel Power Query, empowering you to become a savvy data analyst.
  1. 1

    Getting Started with Power Query in Excel

    Free

    Imagine Excel as you've never seen it before – Power Query opens a window to a whole new world of data possibilities! In this chapter, you’ll explore the layout and features of Power Query and its interplay with traditional Excel workbooks. You’ll load data from multiple sources and learn to structure them through column and row manipulations while maintaining an applied steps log of all your actions.

    Play Chapter Now
    Introduction to Power Query
    50 xp
    Excel Workbooks vs Excel Power Query
    100 xp
    Navigating the Power Query Editor
    50 xp
    Getting Started and Loading Data
    100 xp
    Managing Columns
    100 xp
    Extracting PDF Data
    100 xp
  2. 2

    Data Cleaning and Preparation

    In this chapter, you’ll harness Power Query’s digital cleaning features to prepare a squeaky-clean dataset! Column profiling features will be covered, allowing you to handle errors and missing data effectively. You’ll also master eliminating duplicate data and correcting for data entry issues and outliers.

    Play Chapter Now
  3. 3

    Column Transformations

    It’s time to transform! This chapter covers many basic column transformations - a vital step in the journey from raw data to meaningful insights. You will learn how and when to apply numeric, date/time, and text transformations to both transform and derive column contents with Excel Power Query’s many built-in features.

    Play Chapter Now
  4. 4

    Shaping and Grouping Data

    It’s all about shaping and grouping in this final chapter! You will get hands-on experience with powerful transformation options to bring your analysis prep to the next level. You’ll learn how and when to apply transpose, pivot, and group-by transformations - all within the Power Query editor. You’ll also learn how to leverage existing queries to build new ones and track their connection in the Query Dependencies tree.

    Play Chapter Now

Datasets

Exercises and Datasets

Collaborators

Collaborator's avatar
Carl Rosseel
Collaborator's avatar
Iason Prassides
Lyndsay Girard HeadshotLyndsay Girard

Analytics Consultant, Halton Healthcare Services Corp

Lyndsay Girard is a highly skilled analytics consultant with Halton Healthcare Services Corp. She has over 15 years of experience in hospital analytics, utilizing BI tools and advanced analytical methods to drive data-driven decisions and transformative change. Lyndsay holds a Master’s of Science degree in Epidemiology from McGill University and is passionate about helping learners grow their analytics skills and bring their careers to the next level! When not delving into data, Lyndsay enjoys weightlifting and wilderness camping adventures.
See More

What do other learners have to say?

Join over 13 million learners and start Introduction to Power Query in Excel today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.